Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create a title for a workshseet that is created from a t
Message
 
À
05/09/2003 08:53:14
Olatunji Beckley
O. A. Beckley Ventures
Nigéria
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00826363
Message ID:
00826369
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
What is "a title for an Excel worksheet"? Do you mean, WorkSheet Name or page Header, or Column Title on the first row?
Anyway you need to use Excel Automation. For instance:
ObjExcel= CREATEOBJECT("Excel.Application")
with ObjExcel
    .Workbooks.Open(fullpath(excelfile))
    .Worksheets(1).Name="Hello"
    .ActiveWorkbook.Save
    .Workbooks.Close
endwith
ObjExcel.Quit
ObjExcel=.null.
RELEASE ObjExcel
>Hello all,
>
>I need to create a title for an Excel worksheet that is generated from a table.
>
>I already know how to create an Excel worksheet from a table using COPY TO.
>
>Thanks,
>
>Tunji.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform