Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import XLS files without Excel
Message
 
 
À
29/11/2018 16:47:47
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01663866
Message ID:
01663888
Vues:
45
>>>>I might be wrong, but I thought there was a tool that allows importing XLS files without having Excel installed?
>>>
>>>Unzip the xlsx, and then in the xl subfolder there's sheet1.xml, sheet2.xml etc. Then read the xml and get the values.
>>
>>PMFJI, but how do you Unzip an xlsx file? I am using legacy pkzip25.exe but I can't figure what you mean.
>
>Just like you unzip any other zip file, just
>
>pkzip25 -ext=all -nofix -over=all whatever.xlsx

My pkzip25 always looks for the extension .zip. That is, the above syntax creates an error
cannot find .zip file: whatever.xlsx.zip
But if I rename it to .zip, it works.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform