Excel to XML conversion

[Former Member]

Hi,

I need to convert Excel files into XML format using SAP WAS, SAP Developer Studio (only with Java). Can anybody help me how to approach in this regard.

Thanks in advance

Sreenivas

[Former Member]

you can go to this link http://jakarta.apache.org/poi for tutorials and libraries for accessing all Microsoft format files.

POI is an open source project from Apache and you include the libraries in your projects.

After reading the excel files using POI library, you can use DOM to build the XML. For building the XML you can use the JAXP APIs provided as part of the JDK1.4 included in NetWeaver Studio or you can use an open source library downloadable from http://xml.apache.org/xerces2-j/.

Regards,

Manish

[Former Member]

Please read my blog /people/prakash.singh4/blog/2005/03/16/create-an-excel-file-from-java-using-hssf-api

You can HSSF api to read an excel file. After you get the data, you can have java write an output file in xml format.