Is it possible to update values in excel spreadsheet, which in turn update the pdf document?
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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:
Use the Acrobat JavaScript Reference early and often

