?
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
Medium Priority
?
320 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 2000 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

765 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