Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

How do I import Excel data into a pre-existing LCD form?

Avatar

Level 2

I need to take the data from an Excel Spreadsheet and import that data into a PDF.

How do I get the data from the Excel into the PDF - programmatically?

Details:

  • Excel could contain approx 12 columns and up to 1200 rows of data
  • Need to import this data (csv, XML, etc) into a dynamic PDF that will add a row (and related button/checkbox) for every row in the Excel.
1 Reply

Avatar

Level 10

If you don't want to write any code, then check out this sample by John Brinkman

http://blogs.adobe.com/formfeed/2010/06/display_an_xml_spreadsheet.html