Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to import PDF into Excel?
I want to import some data from PDF files into Excel. Is there a
straight-forward way to do this? For example, see http://muddybuddy.com/pdf/sanjose/results-09.pdf. What I have done in the past is: open the PDF file, save as text, and write a VBA macro to read the text file and parse the data line-by-line, putting it into a worksheet in the form that I require. The issue is: the data in this particular file does not follow a consistent pattern when it is saved to text. For example compare the data for "Bib:" numbers 349, 299, 479 and 1084. (Aside: Can anyone explain why? The data appears consistently in the PDF file.) The issue is not insurmountable. I can recognize and deal with the different patterns in my parser. The problem is: I don't know (yet) how many different patterns are possible. I have found 4 so far. But I would have to look carefully at all 1032 entries to determine if there are other forms. (Actually, I would simply parse what I know and see what is missing, then add a parser for the missing pattern. But that's tedious.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to import PDF into Excel?
Oops, posted to an unintended m.p.excel NG. Wasn't paying attention when I
posted (sigh). Oh well, I know the right people will see this anyway. ----- original message ------ "JoeU2004" wrote in message ... I want to import some data from PDF files into Excel. Is there a straight-forward way to do this? For example, see http://muddybuddy.com/pdf/sanjose/results-09.pdf. What I have done in the past is: open the PDF file, save as text, and write a VBA macro to read the text file and parse the data line-by-line, putting it into a worksheet in the form that I require. The issue is: the data in this particular file does not follow a consistent pattern when it is saved to text. For example compare the data for "Bib:" numbers 349, 299, 479 and 1084. (Aside: Can anyone explain why? The data appears consistently in the PDF file.) The issue is not insurmountable. I can recognize and deal with the different patterns in my parser. The problem is: I don't know (yet) how many different patterns are possible. I have found 4 so far. But I would have to look carefully at all 1032 entries to determine if there are other forms. (Actually, I would simply parse what I know and see what is missing, then add a parser for the missing pattern. But that's tedious.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same | Excel Discussion (Misc queries) | |||
import pdf into excel | Excel Discussion (Misc queries) | |||
Import to Excel | Excel Discussion (Misc queries) |