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

**URL:** <https://techcommunity.softwareag.com/t/how-to-write-a-service-to-read-from-a-excel-file-and-map-to-a-xml-file/125422>\
**Category:** Feedback & ideas\
**Tags:** Discussions-on-this-Forum-System, New-User-Welcome-and-Introductions\
**Created:** [April 6, 2009, 4:28pm UTC](https://techcommunity.softwareag.com/t/how-to-write-a-service-to-read-from-a-excel-file-and-map-to-a-xml-file/125422 "2009-04-06T16:28:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![khirabdhi](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@khirabdhi](https://techcommunity.softwareag.com/u/khirabdhi)\
**Post date:** [April 6, 2009, 4:28pm UTC](https://techcommunity.softwareag.com/t/how-to-write-a-service-to-read-from-a-excel-file-and-map-to-a-xml-file/125422/1 "2009-04-06T16:28:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Gunasekhar\_Tirupati1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/gunasekhar_tirupati1/32/710_2.png) [@Gunasekhar\_Tirupati1](https://techcommunity.softwareag.com/u/Gunasekhar_Tirupati1)\
**Post date:** [April 6, 2009, 6:19pm UTC](https://techcommunity.softwareag.com/t/how-to-write-a-service-to-read-from-a-excel-file-and-map-to-a-xml-file/125422/2 "2009-04-06T18:19:06Z")

</div>

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]](http://poi.apache.org/%5B/url%5D)

Cheers  
Guna