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
317 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
  • 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Title # Comments Views Activity
randomize data from excell cell 15 45
Excel formula to show $0.00 if negative number. 7 52
Response times in Excel 18 41
vba copy paste previous line 3 13
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
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 how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.

839 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