Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

Exporting from PDF to Excel

Avatar

Level 2

Good afternoon all....I have a 2 page form that has a number of fields (Checkboxes, text, drop downs, etc.) that I am trying to export to a format I can then import to Access.  I have some areas in the form that I do not want exported (for example, I have Authorisation requirements and I don't want to export this).  Is there someway that I can specify a) which fields to export and b) export them so one request form is converted to a single row?  I don't know if there's a Mapping feature where I can say "Put data from Field A into Column B"...

The form was created using LiveCycle 8.0 and I have Office 2007....

Thanks

Chris

2 Replies

Avatar

Level 10

Create a Custom DSC component that used Apache Poi API.

You can read the XDP data and create an Excel file from there.

Nith

Avatar

Level 2

...Hi Nith,

Thanks for the reply; actually, I was playing around with my form late last night and found the whole "Binding" section in the individual objects.  Because my end goal is to upload the data from the PDF Form to Access, this will make my life a whole lot easier.  (I was using Excel as a middleman between the two).

Thanks again for your time and have a great day

Chris