Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPxWorkbookXLSX Manual File Creation
Message
From
10/05/2021 16:30:20
 
 
To
07/05/2021 20:36:56
General information
Forum:
Visual FoxPro
Category:
VFPX/Sedna
Miscellaneous
Thread ID:
01680200
Message ID:
01680297
Views:
34
>>>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.
>
>Have you updated to the latest beta version? I uploaded it this morning (Friday, May 7) which should fix the issue above.

After testing the most recent R33 beta I can confirm that a completely empty workbook, or a workbook with multiple empty worksheets can be created and saved successfully. Excel does not complain about any issues with the contents of the .xlsx. Thanks very much.
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
Reply
Map
View

Click here to load this message in the networking platform