![]() ![]() The trick here is that you access the data via the xfa object: 1.Field1.rawValue = tmpDoc.getField("Field1").value You now have to copy the data from that form to your final XFA form. For each record - until you reach the end of the file - the fields in your temporary form you've just created will be set. You can now iterate over the data in your tab separated text file using the Acrobat JavaScript function Doc.importTextData(). Then create an AcroForm that has three fields you need to export, using the column name from your Excel document as the field name. Here is the outline of what I would do:Įxport your Excel file as a tab separated text file. And, it's probably a bit too complex for this forum as well. With this methodology you would read a row data from the excel file and use a name mapping object to match the filed name in PDF to the column name in the Excel file.Going from Excel to a LiveCycle form is a bit more complex than doing this with an AcroForm. And the data block in the excel file has to be named, so it appears as a table to ODBC. So your excel file has to be ODBC registered. This is Acrobat's database connection interface. There is another way to approach this that will allow you more flexibility in naming the excel columns in a friendly way. If not, then maybe you should consider a different path. If you have an automated method for doing this you're in good shape. The problem now is filling it out the excel file since the form is all cryptic names. If you import the text file, that you exported from Acrobat, into excel, you will have your base excel file, with properly named columns. For this purpose, the first row in the Excel WorkSheet has to be the column names. However, you need to be able to match fields in the form to columns in the Excel file. This is all very good info, getting a list of field names. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |