Consulting

Results 1 to 2 of 2

Thread: convert and change report format from PDF to Excel

  1. #1

    convert and change report format from PDF to Excel

    Hi
    I have a series of pdf files that are a report of a software, I need to change this report into an Excel file in my preferred format and language, what I am doing now is as follows:
    I open the pdf file in word, then I copy the desired text (from the beginning to "Hand analysis Report") in excel file, in excel with formula, for each cell according to the range of each item (range of each item at the end of each The table is in the PDF file.) I calculate the value and replace the required text.
    For example, liver fat is normal if it is in the range of 0.097 - 0.419, if liver fat is in the range of 60.23-90.36 is the result of fatty liver syndrome, and so on.
    Is there a way to do these steps automatically without having to open the pdf files one by one and follow the steps I mentioned?
    Sample pdf file and excel output are attached.
    Attached Files Attached Files

  2. #2
    BoardCoder
    Licensed Coder
    VBAX Expert mark007's Avatar
    Joined
    May 2004
    Location
    Leeds, UK
    Posts
    622
    Location
    You might want to look into a combination of an Excel template workbook with some macros and an AutoIt script (https://www.autoitscript.com/) to open and copy paste from the pdf.
    "Computers are useless. They can only give you answers." - Pablo Picasso
    Mark Rowlinson FIA | The Code Net

Posting Permissions

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