Question Re: Excel to XML conversion in Technology Q&A

Excel to XML conversion

Former Member — Wed, 16 Mar 2005 10:07:53 GMT

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

Re: Excel to XML conversion

Former Member — Wed, 16 Mar 2005 11:55:39 GMT

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.

Re: Excel to XML conversion

Former Member — Thu, 17 Mar 2005 06:29:56 GMT

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