Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Better way to code Excel automation?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01313820
Message ID:
01349794
Vues:
26
Check Importing data from a Microsoft Excel 2007 workbook using Visual FoxPro 9.0

>
>We get an Excel 2007 file with 5 sheets of different accounting data. I need to put each of them into a DBF. Since MS deprecated the Excel saveas DBF3 or DBF4, I have to find another solution. I have made saving to a CSV file work for data I know the structure of. For data I do NOT know the structure, I thought using XML would be straight forward using XmlToCursor. But once again, MS has every fileformat for the Excel saveas method except XML. If there is a better solution I am all ears. I do not know about XMLSS, but will check it out. Do you have any tips to shorten my learning curve?
>
>I am very new to the Office 2007 automation process. I have several solutions using Office 2003 and before, but 2007's object model is confusing. I have not used XML but for one app. I hope the solution is NOT building the Excel to XML line by line. I feel that would be very primitive compared to the object models available. We are not using .Net for a solution, only VFP and the Office object model.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform