This Custom DSC will be helpful to Convert your Excel files into XML data.
This component uses the Apache's POI to read the Excel content and returns org.w3c.dom.Document.
The resultant XML will contain a root tag named 'ExcelContent' with each Sheet name as its immediate children.
Each row of the sheets will be appended as nested chil
Optionally, you can ignore the first row of the sheets in the resultant XML and use them as tag names instead.
The Component can be downloaded from here
The Source Code is available here
The Apache POI is available here
Steps to use this Custom DSC:
Step1: Deploy the Apache POI library into Adobe LCES Server
The path will usually be
:\Adobe\Adobe LiveCycle ES2\jboss\server\ \lib
Step2: Restart application server
Step 3: Install the component
Goto Workbench -> Component panel, right click on Component -> Install Component
Choose the JAR file
Step 4: Activate the Service
Right click on the Component -> Start Component
You are done with the Component.
You can drag the Service into any process and set the Input & Output parameters.