Results 1 to 1 of 1

Read text from PDF file and import to Worksheet maintaining each line of text in one row

Threaded View

Algior Read text from PDF file and... 10-31-2012, 09:59 AM
  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Geretsried, Germany
    MS-Off Ver
    Standard 2010
    Posts
    1

    Question Read text from PDF file and import to Worksheet maintaining each line of text in one row

    Hello everybody

    I enjoy so much your interesting discussions and your precious advices, in this Forum, and are very very Helpful.

    I have a problem and i am asking for your help.
    I was a very good programmer some years ago (don't say how many ) but for a long time haven't use my skills.
    For about a month have to do some scripting in my job and need a lot of help.

    Here is my issue:
    I need to convert Lists of Products with Code, 2 or 3 Descriptions and quantities, saved in PDF form, to Worksheets, in order to apply several functions and finally export to csv file.
    My problem is that if the list is a large one or contains grafics between text, the simple solution of exporting a text file with Adobe Professional (or several Pdf-Converters) mainly gives a mess by merging several lines together.
    So i thought that if I am able to export text to my Worksheet using Acrobat SDK, there is maybe a method to do this by reading the text line by line (considering that PDF file contains data in a form of table or using same structure for each line).
    It doesn't matter if the result is each line in a row of Worksheet or each line as text in a cell. Important is that each row/cell contains only one line of text as it appears on PDF file.

    I would appreciate any suggestion.
    Last edited by Algior; 11-01-2012 at 03:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1