Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VfpxWorkBookXlsx
Message
From
06/10/2020 10:35:23
 
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01676306
Message ID:
01676485
Views:
39
>Could you please explain something. When I export a cursor to an XLSX file and specify a file that does not exist (e.g. "TEST1234"), I get a messagebox "sheet already exists, overwrite it?". I don't recall getting this question with the previous version of your library. Also, if I answer, No, the method WriteWorkBookXml goes to Catch To loException. And there is a SET STEP ON in the code. But mainly, why the question on a completely new XLSX file?

I searched my class code for "message" and "exist" but do not have any 'hits' that have this message text. The class does not provide any message text on its own; all the messages of possible error/warning conditions is raised as an Event via RAISEEVENT command calling the OnShowErrorMessage event. You would have to implement the code in OnShowErrorMessage to display text. So I am guessing that you implemented this method; so can you tell me from where in the code it is being raised so that I can look into this? Also, what is the text that is given by loException.Message at the CATCH statement? In the loop for writing the sheet(s) to be added to the XML there is a THROW command if the sheet is not found in the xl_sheets cursor -- is this where the exception is occurring? Can you provide example code to reproduce the error?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform