Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPxWorkbookXLSX Manual File Creation
Message
From
07/05/2021 19:56:52
 
 
To
06/05/2021 20:52:06
General information
Forum:
Visual FoxPro
Category:
VFPX/Sedna
Miscellaneous
Thread ID:
01680200
Message ID:
01680229
Views:
33
>Take a look at the Demo() method -- it has example calls for creating a multi-sheet workbook. The problem you came across is due to creating a workbook with a sheet and not assigning any text or values to any of the cells. In this case, since there is not any text assigned, the internal strings.xml is not needed and is removed. But I had an error in the logic that removes the string.xml from being written which causes the sheet to not be written. I have actually fixed this issue and will be uploading a new beta version (probably tomorrow).

Along the same lines, I tried creating multiple worksheets (15) in a new workbook in a loop. When each was left blank, only the first 2 sheets were created. However, if as part of the sheet creation process I added a value to a cell on that sheet, all 15 sheets were created.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform