How to convert Excel to XML?

Question

I've a requirement something like this. I've to convert an Excel to XML Spreadsheet. After googling, I found jexcelApi. But it's not retaining the format.

Any suggestions on How to convert an Excel to XML format, retaining the Excel formatting?

Thanks :)

Answer 1

Use Apache POI

Answer 2

Maybe you like this one too...it is not Open Source but matches your needs: http://www.xml.com/pub/a/2002/01/09/q-and-a.html

Edit: Comments on that Article are interessting too!

Answer 3

You can use "cz excel converter" to Excel to xml Format, and this tool supports command line interface, so you can call it from your application, you can get demo version and more information from http://www.convertzone.com/excel_converter/help.htm

If you need batch convert converts PDF, XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, DIF and more, "cz excel converter" will help you, it can convert many excel xls files at one time.

Please note: To support XML and MHTML format, you must install MS Excel 2002 or above.

regards
flyaga