all rows in the data file and therefore are done with indicate the end of our data table: We've exhausted We are not reporting this error because it does Var outputDir = "/Users/username/tmp/" // make sure this ends with a '/'Įrr = this.importTextData(fileName, idx) // imports the next record Var fileName = "/Users/username/tmp/data.txt" // the tab delimited text file containing the data You can use the following script in an Action (or a custom command in Acrobat DC): To import a whole spread sheet of data, we need to call this method for each record, and then save the file under a new name, an then move to the next record. There is a problem with this page from the documentation: The error codes use the wrong sign: All positive values are supposed to be negative and vice versa. Take a look at the documentation for this method: Doc.importTextData Once you have such a file, you can use the Acrobat JavaScript method Doc.importTextData() to import one record at a time (just like we did manually before).
The key to importing data from an Excel file is that you need to export the data as a “tab delimited text file” – just like described in the question I linked to above. If that does not work, trying to automate this step will also fail.
The following gives you an idea about how to do this using JavaScript.Īnything I said about importing data manually in the link above is still true, so get familiar with the manual process and verify that you can actually import one data record from your text file into your PDF form. There must be a way to automate this…Īnd, there is. This is very useful if you only have to deal with one or a few records that you need to import into PDF forms, but what if we are talking about 10s or 100s of records? It gets a bit boring to click on the same buttons again and again. You can find this information here: Can I import data from an Excel spreadsheet to a fillable PDF Form? A while ago I documented for how to manually import an Excel data record into a PDF form.
0 kommentar(er)
