Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading xlsx files in VFP
Message
 
 
To
26/01/2017 13:14:06
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01647030
Message ID:
01647231
Views:
64
>I found the issue when calling the Demo() method a second time. The first step is to create the workbook reference:
>
>
>lnWb = this.CreateWorkbook("ExcelTest.xlsx")
>
>
>This returns a 'handle' to the workbook object (1 based index) that is created. If it fails or if the same workbook already exists, then 0 is returned to denote a failure. So, executing Demo() a second time this method returns 0 (no workbook created). I did not include any checking for success in the demo. I have now added the following:
>
>
>lnWb = this.CreateWorkbook("ExcelTest.xlsx")
>IF lnWb = 0
>	RETURN False
>ENDIF
>
Hi Greg,

Mark sent me more questions, he has a problem with the implementation in the actual application. He is wondering if there is a way to communicate with you directly.

Did you get my original email?

Thanks again.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform