Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating XLS Files
Message
 
 
À
03/02/2004 21:10:28
Mike Smith
Doncaster Office Services
Oakville, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00873719
Message ID:
00873725
Vues:
21
You can use Automation to remove first row after creating XLS file.
COPY TO (lcXlsFile) XLS
oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Workbooks.Open(lcXlsFile)
oWorkbook.ActiveSheet.Range("a1:iv1").Delete()
oWorkbook.Save()
oExcel.Quit
>I am converting a .dbf file to an Excel File by using the command below:
>
>COPY FIELDS FIELD1, FIELD2 .......... TO C:\TEMP\FILE1 TYPE XLS
>
>This command creates an Excel file but the first row of the Excel file has the field names from the .dbf file.
>
>I would like to create the Excel file without that first row.
>
>I have tried adding the parameter OFF to the command and that doesn't work.
>
>If anyone has a solution for this. I would be pleased to hear from you.
>
>Mike Smith
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform