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.
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/.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.