Solved

Automated import pdf to excel

Posted on 2012-03-31
6
316 Views
Last Modified: 2012-05-03
Hi All,

I have a monthly report that is generated as a pdf (it can only be generated as a pdf). I need to capture a table out of the report and export it to excel; The table is bookmarked but is varies in length.
-Is there an automated way to capture this?
-Is the a way to batch multiple reports in a single folder??

Thanks!
0
Comment
Question by:J_Drake
  • 3
  • 2
6 Comments
 
LVL 41

Expert Comment

by:dlmille
ID: 37792269
Can you upload a sample and identify the table you want?
0
 

Author Comment

by:J_Drake
ID: 37792287
The entire report or just a sample with the bookmarked table?

Thanks,
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37792288
Enough for testing against.  Your call :).
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:J_Drake
ID: 37792297
I'll post a sanitized version of a portion of the report (the table always begins on pg3 with a variable length). Post up in a few.

Thanks,
0
 
LVL 41

Accepted Solution

by:
dlmille earned 200 total points
ID: 37792495
I've done a bit of research on this and its quite sophisticated to read PDF files from Excel, though doable.  First, do you have Acrobat Pro?  I don't believe you can get what you want using just Acrobat reader.  There are converting utilities out there you might use to convert your PDF file to Excel:


http://www.pdftoexcel.org/

http://www.pdftoexcelonline.com/

http://www.pdftoexcelconverter.net

Here's a manual approach to move PDF tables to Excel:  http://techsupporthelp.org/export-pdf-tables-to-microsoft-excel/ and http://forums.techarena.in/tips-tweaks/1116598.htm


This one looks very promising for your current question, as it has a utility to convert tables directly to Excel.  Its $60, but has the ability for batch conversion of PDF files in a folder, as you stated.

http://www.simpopdf.com/guide/how-to-export-pdf-to-excel.html

Dave
0
 
LVL 8

Expert Comment

by:Amit Khilnaney
ID: 37792586
If you are looking at high volume conversion i.e. batch conversion of multiple pdf to editable formats you can consider solutions provided by


www.abbyy.com

You can either use ABBYY Transformer or go for higher edition i.e. recognition server depending upon your needs.

My company one of the solutions from them
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now