Copy and paste multiple excel rowes into a fillable PDF all at once
Hi I was wondering if anyone could help me out with an issue that I am currently facing at work. I have a large quantity of data that I have to plug into standardized fillable PDFs. Changing the PDF form is not an option as this is the form that my company insists that we use.
Basically, I have rows and rows of data from excel that I have to transfer over to the PDF form.
The PDF form displays one field to enter the information. The current process is to take one line from excel at a time and then copy it into the PDF field. When the line is copied, I hit an ADD button at the button of the form, and a new field in the PDF is created. I then take the next line from excel, copy it into the PDF, hit add and then repeat.
This is obviously an inefficient practice. What I would like to do is just copy all of the data at once and transfer it to the PDF form. However, when I try this all of my data goes into the one PDF field. Everything just gets lumped together. The PDF does not create multiple rows for me.
Any suggestions on how to fix this would be greatly appreciated!
By the way I have been experiementing with selecting Tools -->Forms---> More Form Options ---> Import to try and get the data in that way, but for some reason the program is only letting me import XML files for some reason. Does anyone know what could be causing this problem as well?
The only form of data Dynamic XFA forms can import/export through the UI is XML.
You have to create an XML schema and map it to both the Excel spreadsheet and your PDF through Designer. You don't have to change the look of your company's form but you do have to break it open to map to the schema.