Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reading xlsx files in VFP
Message
 
 
À
26/01/2017 13:14:06
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01647030
Message ID:
01647231
Vues:
65
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform