Problem
I am needing a process that imports data columns from a user defined source excel sheet and populate a predefined PDf form with predefined fields.
Solution
I have created a custom DSC which can be used to convert Microsoft Excel documents into XML. The component accepts an excel document, creates XML nodes based on the first row (assumed as header and it can be omitted) and resulting org.w3c.dom.Document object. This XML can then be imported into dynamic PDF files.
Detailed explanation
Steps:
1. Download the Custom DSC file from
https://docs.google.com/leaf?id=0B8KcjZtz1YzXMjUyODU2MTYtNzNjMi00OTU1LWI4MWMtM2YyZWFhOTE2NzA1&hl=en_US
2. Install the Custom DSC
3. Create a process which uses this custom service.
4. Pass the Excel document as input parameter and retrieve the XML result.
5. Import XML data into PDF
There you go
Nith
nith.mof@gmail.com
+
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License. Permissions beyond the scope of this license, pertaining to the examples of code included within this work are available at Adobe.
