Solved

Script in order to open a pdf file, select all, copy, then paste into a new excel sheet?

Posted on 2011-02-16
5
318 Views
Last Modified: 2012-05-11
like the question states, I need to create a script in order to open 1 or more pdf files, then select all the contents, then paste it into new sheets in excel. i don't know what language would be the best to accomplish this so I need some ideas.

Thanks!
0
Comment
Question by:jtovar3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 32

Accepted Solution

by:
Robberbaron (robr) earned 500 total points
ID: 34914814
most pdf readers/extractor only allow output of unformatted text.

this wont paste well into excel.  But you may be able to then script the reformat process.

freeware pdf2txt
http://www.a-pdf.com/text/
http://text-mining-tool.com/
http://www.colorpilot.com/extract-pdf-text.html

all of there have a command line app that you can script using batch files / vba / vbs.  Personally I would look at the VBA method from within the target XL file.
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 34917143
Acrobat X allows to save a PDF document as an Excel spread sheet. You can download a 30 day eval version to see if that would fit your needs. If that works, we can work on automation.
0
 

Author Comment

by:jtovar3
ID: 34951722
Thanks for the great recommendations!

A-PDF text works like a charm, but I have no idea where to start in order to write a script to open the program and run it in order to convert the file. do you think you can provide any insight into that?

Thanks so much!
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 34951742
Sorry, I am not familiar with A-PDF.
0
 
LVL 32

Expert Comment

by:Robberbaron (robr)
ID: 34958225
The command line version is what is needed to script. But it is not free.$35. See the web page link to batch examples.
Ill see if there are other free options
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Outlook Free & Paid Tools
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

696 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