Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to Excel
Message
From
22/04/2002 14:07:19
 
 
To
22/04/2002 13:59:48
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00647684
Message ID:
00647725
Views:
23
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform