Extract table values from pdf in designated cells on excel spreadsheet

Community Beginner ,
Jun 21, 2020

Copy link to clipboard

Copied

Hi all. Is there a way to automate (e.g. JS button) the process of extraction from table in pdf (entire pdf layout is created in Word, than saved as pdf and made fillable with Acrobat) to designated cells in Excel, where the table layout is different from the one in pdf?

Something like; first table field (top left) in pdf is text field named "Text1" and its' value has to go in C5 cell in Excel spreadsheet and so on.

 

Any help and guidance is much appreciated.

Thanks

Most Valuable Participant
Correct answer by try67 | Most Valuable Participant

Well, you would need to write a script that collects the values of those fields into a string in the desired format and then writes that script to a "data object" (ie. a file attached to the PDF) and then exports it, so it can be saved locally.

The objects and methods needed to do all of that are documented in the Acrobat JA API Reference document, available here: https://www.adobe.com/devnet/acrobat.html

TOPICS
Acrobat SDK and JavaScript, Edit and convert PDFs, PDF forms

Views

154

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Extract table values from pdf in designated cells on excel spreadsheet

Community Beginner ,
Jun 21, 2020

Copy link to clipboard

Copied

Hi all. Is there a way to automate (e.g. JS button) the process of extraction from table in pdf (entire pdf layout is created in Word, than saved as pdf and made fillable with Acrobat) to designated cells in Excel, where the table layout is different from the one in pdf?

Something like; first table field (top left) in pdf is text field named "Text1" and its' value has to go in C5 cell in Excel spreadsheet and so on.

 

Any help and guidance is much appreciated.

Thanks

Most Valuable Participant
Correct answer by try67 | Most Valuable Participant

Well, you would need to write a script that collects the values of those fields into a string in the desired format and then writes that script to a "data object" (ie. a file attached to the PDF) and then exports it, so it can be saved locally.

The objects and methods needed to do all of that are documented in the Acrobat JA API Reference document, available here: https://www.adobe.com/devnet/acrobat.html

TOPICS
Acrobat SDK and JavaScript, Edit and convert PDFs, PDF forms

Views

155

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 21, 2020 1
Most Valuable Participant ,
Jun 21, 2020

Copy link to clipboard

Copied

If you are talking about actual form fields, then yes, although it will require a script and it can't generate an Excel file but something like a CSV file or a tab-delimited text file, which in turn can be imported into Excel.

If, on the other hand, the table is just static contents it might be possible to do it with a script, but it will be much more complicated.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 21, 2020 2
Community Beginner ,
Jun 21, 2020

Copy link to clipboard

Copied

Thank you "try" for your super quick answer.
Yes, table fields are actual form fields. If it's not too much to ask, can you provide an example of how would such script look like?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 21, 2020 1
Most Valuable Participant ,
Jun 22, 2020

Copy link to clipboard

Copied

Well, you would need to write a script that collects the values of those fields into a string in the desired format and then writes that script to a "data object" (ie. a file attached to the PDF) and then exports it, so it can be saved locally.

The objects and methods needed to do all of that are documented in the Acrobat JA API Reference document, available here: https://www.adobe.com/devnet/acrobat.html

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 22, 2020 1
Vortex99 LATEST
Community Beginner ,
Jul 06, 2020

Copy link to clipboard

Copied

Thank you!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 06, 2020 0