Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xslx
Message
De
08/12/2014 12:51:36
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Xslx
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01611889
Message ID:
01612001
Vues:
74
>>>>
>>>>oXL = CreateObject("Excel.Application")
>>>>oXL.Workbooks.Open("YourFile.XLS")
>>>>oXL.ActiveWorkbook.Save("YourFile", nDesiredFormat)
>>>>oXL.Quit()
>>>
>>>
>>>>
>>>>
>>>>Use 56 for Excel 97 format. That said, I don't think newer versions can actually produce an Excel 97 format that VFP can read. You have to go back to Excel 5 format for that to work; I think the constant you want is 39.
>>>>
>>>>Tamar
>>>
>>>
>>>Tamar
>>>
>>>I don't understand - the file I am trying to convert is an xslx file to xls file - will your code do that?
>>
>>It should - just use xlsx as extension in the sample. Why you don't want to try that code first to test?
>
>This is my VFP code - comes up with unrecognised command verb on first line - what am I doing wrong?
>
>
>oXL = CreateObject("Excel.Application")
>oXL.Workbooks.Open("c:\aatemp\global.XLSX")
>oXL.ActiveWorkbook.Save("c:\aatemp\globalnew.xls", 56)
>oXL.Quit()
>
You must have a typo or something, though I cut your first line and executed it in the Command Window with no problem.

Tamar
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform