working with PDF data

[Guest]

Hello,

Can anyone clarify...

Is it possible to extract data (in table format) from PDF file to excel.
When tried to copy the table data from PDF to excel, it is pasted as text.
And if try to break it with "Text to columns" it is not breaking exactly as
per the PDF format.

Best regards,
Ram

 

[NickHK]

Acrobat 6 (the paid version) has a function to "Select Table", then "Open
table in spreadsheet".
Acrobat Reader 6 (the free version) does not. Maybe later version do ?

A pdf table may look like a set of cells in Excel, but there is no
connection in the formats really. Unless the pdf component can put the data
into the clipboard that Excel can recognise as cells, then you will get
text. Maybe one of the other pdf components has such a feature ?

Otherwise, you need some means to recognise the end of each cell value. Then
TextToColumns or manipulating the clipboard data will be possible

NickHK

 

[Guest]

Hi Nick,

Thank you for your valuable suggestion... Is it possible to read or use the
PDF file in C++ program like a text file... Also is it possible to create
user defined functions and call them in excel...

 

[NickHK]

Ram,
As PDF is a binary format, it is not text; you have to understand the file
format. As for reading it in C++, you would have to ask in an appropriate
NG.
UDFs can be created in Excel. Depends what you want to do.

NickHK