This Python script extracts tables, images, and embedded files (such as PDFs) from an Excel file and saves them in a specified output folder.
- Extracts tables from all sheets in the Excel file and saves them as CSV files.
- Extracts embedded images from sheets and saves them as PNG files.
- Extracts embedded PDF files from Excel and saves them separately.
Ensure you have the following Python libraries installed:
pip install pandas openpyxl pillow- Place your Excel file in the project directory.
- Update the
excel_file_pathvariable with your file name. - Run the script:
python main.pyoutput/
βββ Sheet1.csv
βββ Sheet2.csv
βββ Sheet1_image_1.png
βββ Sheet2_image_2.png
βββ embedded_file_1.pdf
This project is open-source and can be modified as needed.
Created by MrDodgerX