Skip to main content
Vortex99
Vortex99
Participating Frequently
June 21, 2020
Answered

Extract table values from pdf in designated cells on excel spreadsheet

  • June 21, 2020
  • 1 reply
  • 1565 views

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

    This topic has been closed for replies.
    Correct answer try67

    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

    1 reply

    try67
    try67
    Community Expert
    June 21, 2020

    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.

      Vortex99
      Vortex99Author
      Participating Frequently
      June 22, 2020

      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?

        Vortex99
        Vortex99Author
        Participating Frequently
        July 6, 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


        Thank you!

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices