PDF Table to Excel Spreadsheet

[seven_percent]

This has been asked in numerous places all over the web but I have not
found a workable solution. We have a mainframe system that generates
PDF reports for billing. However, few people in our organization
these days speak mainframe. We need Excel to do calculations on the
data. I began working on a method for converting using UEdit Macros
and an Excel macro because the fields are fixed-width. My attempts
have been unsuccessful.

Here is what I want to accomplish:
-Copy a region of text from a PDF
-Paste into Excel
-Break the values out into the appropriate cells.

 

[Bob I]

http://www.google.com/search?hl=en&q=pdf+converter&btnG=Google+Search

 

[seven_percent]

http://www.google.com/search?hl=en&q=pdf+converter&btnG=Google+Search






- Show quoted text -

Thanks. I tried several last night but they didn't do precisely what
I wanted. Do you know of any that allow you to define field lengths
for dissecting the info in the PDF? E.g. first convert the data in
the file to a pure text format, then apply the field definitions?

 

[Bob I]

Thanks. I tried several last night but they didn't do precisely what
I wanted. Do you know of any that allow you to define field lengths
for dissecting the info in the PDF? E.g. first convert the data in
the file to a pure text format, then apply the field definitions?

Sorry, I hardly ever go from PDF to text, and so it's usually a print to
file and OCR it for anything I do.

 

[seven_percent]

Sorry, I hardly ever go from PDF to text, and so it's usually a print to
file and OCR it for anything I do.- Hide quoted text -

- Show quoted text -

Alright. Thanks again for taking the time to respond.