I'm working on a travel form pdf and want to look up the travel distances in an external Excel spreadsheet (or cvs, tab-delimited text file, etc.). All I've found on this is creating an array or table in the pdf to search using javascript. That seems rather arduous given the number of cities in a given state. Any help here is appreciated.
Thanks,
Randall
Reader is not able to use most of the methods that Acrobat can to access data in external files, but it can read data in file attachments. So you could include a data file (e.g., tab delimited text) and read it using the doc.getDataObjectContents JavaScript method. This keeps the data with the document that uses it, so it's a portable solution. It could be rather slow depending on how much data is involved.
An alternative is to have each user install a folder-level JavaScript file that simply contains the data, similar to how you could by including it in a document. This approach would be faster than the previous one. It isn't really portable since each user would have to separately install the file, but the single data source would be readily available to any number of forms once it's installed.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices