Coding

:: PDF Data Extraction to Excel ::

PDF :: Extract Data from PDF file - Export to Excel - Word or Phrase search based on starting Part word search

Purpose: To Extract Data by either word or phrase search, based on starting part word, and save to excel file.

Useful to extract data easily from a large PDF file.

Motivation to create:

We have a Electrical and Instrumentation drawings in PDF file. File has more than 200 pages.

To get all the barriers data, IO cards data and other details from PDF file to excel, I have written this program.

This can be used on any size PDF file, and can be used as general purpose program to extract data to excel file.

Language: Python

inputs: 

1. PDF File

Outputs: Excel file with extracted data

How to Use: Run the given program (exe file)

Sample Screenshots:

References: Taken CHAT GPT Help

Disclaimer: This is Just a Hobby kind of project. Tried and tested at my level. Can't guarantee, stability and other issues. use at your Risk and always make backup copy of original files.

Attachments:

Converted Python code to executable distribution.

Just RUN "PDF-word-pharase-search-by-partword.exe" file.

keep your pdf in the same folder or give complete path while using program.

Executable file link

PDF-word-pharase-search-by-partword.zip

:: PDF Bookmarking ::

Creating up to 5 Level hierarchy Bookmarks in a PDF file based on Excel file input

Purpose: Bookmarking Large Unorganized PDF file which are essential for day to day operations.

Language: Python

inputs: 

1. PDF File
2. Excel file which has the Hierarchy Levels defined. 
   Columns A to E are used for Levels
   Column F used for Page number

Outputs: PDF file with bookmarks

How to Use: Run the given program (exe file)

Sample Screenshots:
 

References: Taken CHAT GPT Help

Challenges faced: making CHAT GPT understood my requirement clearly. And provided depreciated function list to CHAT GPT priorly to avoid repeated mistakes by CHAT GPT.

Disclaimer: This is Just a Hobby kind of project. Tried and tested at my level. Can't guarantee, stability and other issues. use at your Risk and always make backup copy of original files.

Attachments:

Converted Python code to executable distribution.

Just RUN "Bookmarks-Master-file-Excel-Input.exe" file.

keep your pdf & excel in the same folder or give complete path while using script.
 

Executable file link:

PDF_Bookmarking_from_Excel_data

:: PDF Data Extraction from "Specific fixed locations" to Excel ::

PDF :: Extract Data from "Specific fixed locations" PDF file - Export to Excel 

Purpose: To Extract Data from "Specific fixed locations" of PDF file and export to excel file.

Useful to extract data easily from a large PDF file.

Motivation to create:

We have a Electrical and Instrumentation drawings in PDF file. File has more than 200 pages.

To get all the data  from "Specific fixed locations" of PDF file to excel, I have written this program.

This can be used on any size PDF file, and can be used as general purpose program to extract data to excel file.

Language: Python

inputs: 

1. PDF File
2. Excel File (Which has Rectangular coordinates details)

Outputs: Excel file with extracted data

How to Use: Run the given programs (exe files)

Steps:

1. For Identifying the Coordinates (x0,y0,x1,y1) of a specific Location, we need to draw a "Text Box" from "Comment" Option of Adobe reader and save the PDF File

2. Run the Exe file "Rect-coordinates-TextBox-Annotation.exe"

Give the PDF file name and page number as inputs, and after processing, an excel file automatically popups with the result i.e Rectangular coordinates of the "Text Box" from the given page number

3. Now, we have the "Coordinates" of Required locations.

These coordinates are the inputs for the Next Program, from which we get extract data from PDF file to Excel file.

Most of the Drawing PDF files have common footer with details of

• Sheet Number
• Sheet Description
• Box number
• etc... depends on your PDF drawing file

Save the required coordinates in a excel file as shown below, this excel becomes input for the PDF file

4. Now Run "Rect-Coordinates-Data-extraction-w.r.t-excel-coordinates.exe" file

References: Taken CHAT GPT Help

Disclaimer: This is Just a Hobby kind of project. Tried and tested at my level. Can't guarantee, stability and other issues. use at your Risk and always make backup copy of original files.

Attachments:

Converted Python code to executable distribution.

keep your pdf in the same folder or give complete path while using program.

Executable files links

1. Rect-coordinates-TextBox-Annotation

2. Rect-Coordinates-Data-extraction-w.r.t-excel-coordinates