Copy link to clipboard
Copied
Hi,
I'm trying to export multiple pdfs of about 500 pages each (2000KB), into excels, since the pdf are basically tables. I had originally 1 pdf with approx 4,6K pages, but it was to big to export, so I split it in about 10 docs.
Exporting each pdf takes a lot of time, so I would like some code so I can leave it running all night. I'm new in Javascript, so I don't know how to write that simple script and I haven't found the answer after googling a lot. Could someone help me writing it? I'm sure it's just a simple loop that opens files and export them.
Thanks
Copy link to clipboard
Copied
This needs to be done in an Action, which has its own limitations and probably won't be able to process all of your files in a single go.
Acrobat is simply not suited for this kind of heavy batch processing, unfortunately.
Copy link to clipboard
Copied
Is the problem the size of the document or the number of documents? What if I split it in more, smaller, documents (100pg, 400kb each?). Would that help?
What is the alternative for getting this data into excels then?
Not sure if it is relevant, but I'm using Adobe Acrobat Pro DC.
Thanks
Copy link to clipboard
Copied
Both could be an issue. You didn't mention how many files you want to process, though...
Copy link to clipboard
Copied
I have a single document of 4893 pages (22000 kb), I can easily split it in whatever number of documents I need (i.e. 10 docs of 500p each, 20 docs of 250p each, etc... ). Another important thing to mention is that I don't need it to be exported to a single excel... I can easily merge and clean later as many excels as I want using another program.
What do you recommend for converting this data into excel?.
Copy link to clipboard
Copied
Ah, in that case it might work. I would try either of these combinations.
And you don't need a script. Just add a Save command and then specify its settings to export the file to an Excel spreadsheet.
Copy link to clipboard
Copied
Great!!!
How do I do the Save command? and how can I run it automatically to several documents sequentially?
Copy link to clipboard
Copied
You can set an Action to process multiple files by selecting them when you
run it. You can also select the folder where they are located.
To set the files to export to Excel documents add a Save command to your
Action and then click on Specify Settings beneath it. Select "Export
files(s) to alternate format" and then "Excel Workbook". That's it, pretty
much.
On Fri, Aug 12, 2016 at 4:50 PM, gonzalop29 <forums_noreply@adobe.com>
Copy link to clipboard
Copied
I think that will work!! At least it did in my small pilot... I'll let you know once I have time to export the entire file to confirm it works.
Thanks very much!
Find more inspiration, events, and resources on the new Adobe Community
Explore Now