on 03-16-2005 10:07 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.