Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export to Excel
Message
De
22/04/2002 14:07:19
 
 
À
22/04/2002 13:59:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00647684
Message ID:
00647725
Vues:
24
>The 16384 row limit is imposed by the version of Excel that you are exporting to. The XLS option, if I remember correctly, exports to version 4.0 Excel file which has this limit. It appears that XL5 option also has this limit. You can export data to FOXPLUS dbf table and open that in EXCEL 2000 as a dbase4 format file without this 16384 limit. From EXCEL 2000 you can then save this DBF file to Excel 2000 XLS file.

>You can probably automate excel to export the data to the later version XLS file. But using VFP Copy to XLS and XL5 format imposes this limit. I don't know if VFP7 made any changes to copy to excel functionality.

Thanks Elmer, that's really a good workaround and I'll use it!

Fernando
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform