Best tools to create valid XML files from an Excel file
Posted
by systempuntoout
on Stack Overflow
See other posts from Stack Overflow
or by systempuntoout
Published on 2010-05-13T07:13:25Z
Indexed on
2010/05/13
7:24 UTC
Read the original article
Hit count: 195
I need to create a script that extracts some data from a complex Excel 2003 file (with multiple Sheets and different tables inside a single sheet) and produces different XML files that need to be validated against a given XSD file.
My preferred language is Python;
to create and validate XML files i would go with lxml.
What do you suggest for parsing XSL files?
Is xlrd the right tool to use for complex Excel files?
Or do i need to convert all the sheets in CSV manually, and read files line by line, splitting and getting data?
I accept C#, VB6 suggestions too.
© Stack Overflow or respective owner