Skip to main content
H
HickingbothamIT
New Participant
November 4, 2019
Question

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

  • November 4, 2019
  • 2 replies
  • 1522 views

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.

This topic has been closed for replies.

2 replies

Thom Parker
Community Expert
Thom ParkerCommunity Expert
Community Expert
November 5, 2019

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_Interapp_Commun_SectionPage%2FAcro_Interapp_Commun_SectionPage.htm

 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
try67
Community Expert
try67Community Expert
Community Expert
November 5, 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.

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