CODEWITHSUNDEEP
javaexcel
jai
jai

Reputation: 21897

How to convert Excel to XML?

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

Upvotes: 0

Views: 2988

Answers (3)

Monica Singh
Monica Singh

Reputation: 1

For Reading an Excel file you need to use POI jars and for creating an XML you can use JDOM jar file (Jdom Parser to Parse XML).

Please find below link which has complete code of reading an Excel file and with that Excel file it is creating XML.

Link : https://github.com/monica11aug/ExploringThings/tree/main/ExcelToXmlConvertor

Upvotes: 0

bastianneu
bastianneu

Reputation: 2069

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!

Upvotes: 0

Martin K.
Martin K.

Reputation: 4703

Use Apache POI

Upvotes: 1

Related Questions