Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading xlsx files in VFP
Message
From
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:
01647042
Views:
67
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform