Retrieving data from PDF and to put it in an Excel sheet
I wanna ask you a favour that i'm in reallllly bad need for it:
I wanna know some way to collect data from a daily report from PDF files that are uploaded on certain web siet and put it in an excell sheet >how could i do that , any one can help????????
Re: Need help for retrieving data from PDF and to put it in an excell sheet
You can highlight the data in the PDF file and then copy/paste it into Excel. This will tend to put all the data in one column, so you can then apply Text-to-columns (on Data tab) to split it out into columns. You may need to remove header information etc.
An alternative is to use an OCR package.
Hope this helps.
Re: Retrieving data from PDF and to put it in an Excel sheet
Thanx alot PETE but this isn't what i'm askin' about, Again just to clarify :
If I got a punch of PDF files with the same form containing many data ,How could I make something to collect a certain data from a certain part in every PDF file and to put it in an Excell sheet without opening every file and copy/paste it . I wanna something to make it automatically.
I really appreciate your help gentle man
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1