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

Is it possible to update values in excel spreadsheet, which in turn update the pdf document?

New Here ,
Nov 04, 2019 Nov 04, 2019

Is it possible to update values in excel spreadsheet, which in turn update the pdf document? The reason being this would be a flipbooks project. After updating the spreadsheet, and then saving the excel document as .pdf is too cumbersome, looking to see if there is a possibility for this process to be automated. Thank you.

TOPICS
Edit and convert PDFs , How to
1.4K
Translate
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 ,
Nov 05, 2019 Nov 05, 2019

Not really, unless the Excel file is saved as a plain-text file first and a script is embedded in the PDF to look at the contents of that file when opened.

Translate
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 ,
Nov 05, 2019 Nov 05, 2019
LATEST

There are a couple of ways to transfer data between Excel and Acrobat. Importing and exporting data files is one way. This can be partially automated with scripts in Acrobat, but is mostly a manual process on the Excel side. Another way is to write a VBA in Excel. This VBA could either automate the data extraction bit on the Excel side, or open a PDF form in Acrobat and write values directly into the PDF. Take a look at the IAC reference here:

https://help.adobe.com/en_US/acrobat/acrobat_dc_sdk/2015/HTMLHelp/#t=Acro12_MasterBook%2FAcro_Intera...

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Translate
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