Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to convert pdf file into excel?
i am receivign pdf file , i have to insert all details into excel
mannualy is it possible to import detail of pdf file to excel or to convert pdf file to excel?. i will be thankfull to in advance for solving my problem |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to convert pdf file into excel?
There are a few diffferent types of pDF files. Some are exculsively pictures and some contain mixtures of text and pictures, so are pictures that contain text. I assume you are trying to extract the text portion of the pdf and put into excel. For the text that in the form a a picture you have to use a OCR converter to get to text. Professional version of Word has an OCR reader. You can also convert from PDF to word using utilites provided with Adobe Writer (not free like the reader). Sometimes you are able to save the pdf as text and with a little manual manipultion remove the special formating characters from the readable text. I'm sometimes successful by copy the pdf file and pasting into Notepad (whicyh removes some of the invisible characters and then paste into word/excel. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=182124 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to convert pdf file into excel?
Hi
As joel says, copy with the mouse and paste into notepad. Remove any text you don't like then save and close the file. In excel do Data, Import and see what the data looks like when you try different deliminators (tab or space separated with "treat common deliminators as one" might do the trick). regards Paul On Feb 24, 11:37*am, joel wrote: There are a few diffferent types of pDF files. *Some are exculsively pictures and some contain mixtures of text and pictures, so are pictures that contain text. *I assume you are trying to extract the text portion of the pdf and put into excel. For the text that in the form a a picture you have to use a OCR converter to get to text. *Professional version of Word has an OCR reader. *You can also convert from PDF to word using utilites provided with Adobe Writer (not free like the reader). Sometimes you are able to save the pdf as text and with a little manual manipultion remove the special formating characters *from the readable text. *I'm sometimes successful by copy the pdf file and pasting into Notepad (whicyh removes some of the invisible characters and then paste into word/excel. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=182124 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert email address file in Excel 2000 to Word file with commas | Excel Discussion (Misc queries) | |||
excel 2002 -how can you convert a file to a pdf read only file? | Excel Discussion (Misc queries) | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
How do I convert a Quattro Pro 7 file to an Excel 2003 file? | Excel Discussion (Misc queries) | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) |