Thursday, February 24, 2011

Custom DSC - Convert Excel document into XML

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
dren nodes.

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.


No comments:

Post a Comment