• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help me to Data Transfer from PDF to Excel

S

sampath

Member
Hello Sir,

Need to transfer all the numerical, alphapet and alphanumaric data's from pdf sheets to excel. I have one pdf package, which has 300 sheets. I need to transfer that pdf data to excel sheets.

Note : Every pdf sheet data to be come to every excel column.

Please help me it is very urgent for our project.

Thank with regards,
Sampath.S
 
Dear Debraj,

We cannot installed that converter to our system due to office administration restriction and that project pdf is very confidential. So could you help me for any macros or VBA scripts for the same.

Thank with regards,
Sampath.S
 
Hi,​
​
so without any converter, you can use Adobe Acrobat to open the source .pdf file …​
​
Also if you're good enough in VBA development, you can try a copy from Acrobat Reader​
and in a VBA code paste the clipboard in memory to process it to cells.​
​
I already did such a process but only for 30 sheets of a .pdf file (code is on a non english forum),​
300 sheets is huge, maybe not a problem if your computer have 32 GB RAM …​
​
'cause your .pdf file is very confidential, you're on your own …​
​
 
Hello Sampath,

Can you please tell me is your PDF documents are kind of Text Files or Form Files.
I mean
Text Files: kind of text books and simply eBooks
Form Files: Where you have Text Fields/Boxes where you have text/data to be copied to excel
 
Hi Raghu ram Alla,

I have attached the example pdf and needed output.

could you provide any macros for the same.

Regards,
Sampath.S
 

Attachments

  • Data Conversion.zip
    96.2 KB · Views: 1
You must log in or register to reply here.
Back
Top