How can I copy a formated Excel table to auto-fill a Fillable PDF?

Forum|Forum|4 years ago
November 8, 2021
2 replies
2483 views

I created an Excel VBA script to create a table that is in the same format as a fillable tax spreadsheet. I would like to copy the cells from Excel to the fillable tax spreadsheet, but when I try to manually paste the Excel table into the Adobe PDF, it pastes into one cell instead of all the cells. How can I fix this?

I have attached the fillable pdf and my Excel data. I would like to paste the Excel table into the large table on the second page of the pdf.

Eventually, I would like to script this in VBA, but I want to know how to do it manually first.

Thank you.

f8949.pdf

testData.xlsx

Acrobat SDK and JavaScript

This topic has been closed for replies.

T

Test Screen Name

Legend

Possible as in "perhaps the pasted data could be programmatically parsed, split and assigned to appropriate fields". But I don't think so.

Certainly nothing you can do manually; you can put form fields in a grid in Acrobat, but there is no row or column relationship. They might look the same, but they need a completely different worldview.