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.

Merging an Excel File into an expandable table.

Avatar

Level 3

Hello,

I was just wondering if there is any way to maybe insert an excel file into an expandable table which would fill AND extend the matching cells and extend the table rows per every existing field in the excel sheet.

My table currently has 3 columns with a header and footer (see below) and sometimes the data can be really large having to insert MANY new rows. What I'm trying to avoid is having two different data sources or having to do double entering.

+NameId NumberTotal deposit
-John Smith0000000000$20
Total Deposit$20

THANK YOU VERY MUCH!!!!

3 Replies

Avatar

Level 10

Hi,

you can import a Excel Spreadsheet into a XFA form.

Here's a method, that imports the date from an attached xml (available from Office 2003).

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

Avatar

Level 3

Hi, is there any way I can laod an excel file into the PDF form instead?

Thanks,