Participating Frequently

Answered

Export specific PDF blocks to Excel cells

Forum|Forum|7 years ago
June 22, 2018
3 replies
2284 views

Hello All,

I have multiple PDF's with fillable data, each form that is filled out has unique data for each person that uses it. I would like to find a way to take portions of the form and export the data to an excel sheet in a formatted manner i.e. block 1 of the pdf is exported to cell 1A and block 2 to cell 1B of the excel workbook and so on. Then I would like it to open a second pdf and do the same but add the data from block 1 to cell 2A and so on down the row.

The systems that this would be run on do not allow third party software so I am limited in my potential solutions to Powershell, Java or builtin Microsoft or adobe products.

Thank You for your help

This topic has been closed for replies.

Correct answer try67

Try67,

As much as I would like to say I could allocate funding for this project I cannot. I am hoping to learn how to accomplish this task and implement it as a solution in the future.

Any chance you can give me a starting point on how I would accomplish this?

You need to learn how to use JavaScript in a LCD form.

You can start here: Adobe - Acrobat Developer Center | Adobe Developer Connection

The relevant forum: LiveCycle Designer

M

MrMcNAuthor

Participating Frequently

Thank you both for your input, I will submit this question to the LiveCycle Designer forum.

BarlaeDC

Community Expert

HI,

My understanding is that you don't have rights to change the form? is that correct?

And can you provide a the link, but I think, as try67 stated, it will be very difficult to manage this, particularly if you don't have rights to change the form.

Regards

Malcolm

try67

Community Expert

From what I understood there's no need to change the actual form, just extract the form data from it and export it to a text file. That should be possible with this file.

BarlaeDC

Community Expert

Hi,

I haven't had a chance to look at the file, will be doing that later this afternoon, but if the form doesn't have rights to export data then it may be difficult to get the data out. Will update once I have had a chance to look at the form.

Regards

Malcolm

try67

Community Expert

This can be done using JavaScript in Acrobat Pro. Are you allowed to use

that?

M

MrMcNAuthor

Participating Frequently

Try67,

Yes I can use Java script.

try67

Community Expert

In that case you can do it, if you have Acrobat Pro. It will require the development of a custom-made script, though.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded