cancel
Showing results for 
Search instead for 
Did you mean: 

Excel to XML conversion

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

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.