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

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

"Ram" wrote in message
...
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

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...

--
Best regards,
Ram


"NickHK" wrote:

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

"Ram" wrote in message
...
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

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

"Ram" wrote in message
...
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...

--
Best regards,
Ram


"NickHK" wrote:

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

"Ram" wrote in message
...
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