• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Extract table values from pdf in designated cells on excel spreadsheet

Community Beginner ,
Jun 21, 2020 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

TOPICS
Acrobat SDK and JavaScript

Views

481

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
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 22, 2020 Jun 22, 2020

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
Community Expert ,
Jun 21, 2020 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
community guidelines
Community Beginner ,
Jun 21, 2020 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
community guidelines
Community Expert ,
Jun 22, 2020 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
community guidelines
Community Beginner ,
Jul 06, 2020 Jul 06, 2020

Copy link to clipboard

Copied

LATEST

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
community guidelines