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: 190

Filed under:
|
|
|
|

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

Related posts about excel

Related posts about python