Skip to main content
Participant
April 19, 2020
Question

Is acrobat the right program for this project, and how do I implement this? (Details below)

  • April 19, 2020
  • 1 reply
  • 300 views

Looking to upgrade work documents. There's a lot of paperwork to fill out, sometimes repeating the same information multiple times. One aspect is that we have to lookup data on an embedded excel sheet that works kind of like a book. Column A = book title, B=Page, C=paragraph D=sentence and each row is a sentence. Is there a way to "attach" an excel sheet to adobe, and somehow write a program or format it so it will auto populate the D column if given the Columns A-C and they are all in the same row? 
I have heard Indesign might be a suitable program to make this, but still don't know how to implement it. I really don't want to make a matrix in java with all the data because there are THOUSANDS of columns. Any help is appreciated. 

This topic has been closed for replies.

1 reply

jane-e
Community Expert
Community Expert
April 19, 2020

Hi 

You can place an Excel table into InDesign as a link and then update the link with the information changes in Excel. You need to format the table in InDesign using Styles for the paragraphs (text), cells, and the table.

 

You've asked in the Acrobat forum, though. Shall I move this thread to the InDesign forum?

 

~ Jane

ScpfahlerAuthor
Participant
April 19, 2020

If you think that program is much better to accomplish the task, yes please!