How to write a service to read from a Excel file and map to a XML file.

Feedback & ideas
,
1

Hi friends,
Please advise how to write a service to read from a excel file and to map to a XML file and how to convert excel file to XML file.

Thanks in advance,
Khirabdhi.

2

Hi,
Use JXL or POI APIs to read the XL file. You can read each cell of each row of the xl and then add that to an IS document list in a simple java service. Then convert the IS doc to XML. You can download POI API from [url]http://poi.apache.org/[/url]

Cheers
Guna