Download the PHP package kraenzle-ritter/spreadsheet-inspect without Composer
On this page you can find all versions of the php package kraenzle-ritter/spreadsheet-inspect. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download kraenzle-ritter/spreadsheet-inspect
More information about kraenzle-ritter/spreadsheet-inspect
Files in kraenzle-ritter/spreadsheet-inspect
Package spreadsheet-inspect
Short Description CLI tool to inspect and analyze Excel/ODS spreadsheet files
License MIT
Homepage https://github.com/kraenzle-ritter/spreadsheet-inspect
Informations about the package spreadsheet-inspect
Spreadsheet Inspect
A CLI tool to inspect Excel (.xlsx, .xls) and LibreOffice (.ods) spreadsheet files. Analyze sheet structures, column statistics, find cross-sheet references, and extract embedded images.
Features
- 📊 Sheet Analysis – List all sheets, view column headers, row counts, and fill rates
- 📈 Value Statistics – See distinct values per column with occurrence counts
- 🔗 Cross-Sheet Reference Check – Find where values from one sheet appear in others
- 🖼️ Image Inspection – Count and extract embedded images/drawings
- 📁 Multiple Formats – Supports Excel (.xlsx, .xls) and LibreOffice Calc (.ods)
Installation
Download PHAR (recommended)
Download the latest release:
Optionally move to your PATH:
From Source
Usage
Note: Replace
php inspectwithspreadsheet-inspectif using the PHAR.
List all sheets
Analyze a specific sheet
Output:
Analyze images in a sheet
Extract images to a directory
Cross-sheet reference check
Find where values from a column appear in other sheets:
Check against a specific target sheet:
Compare only against a specific column in target sheets:
Options
| Option | Description |
|---|---|
--sheets |
List all sheet names only |
--sheet= |
Inspect a specific sheet (by index or name) |
--column= |
Cross-search for values from this column |
--cross-sheet= |
Only check this target sheet |
--target-column= |
Only compare against this column in target sheets |
--images |
Count and list images in the sheet |
--extract-images= |
Extract images to specified directory |
--output= |
Output format: console (default), html, pdf |
--output-file= |
Output file path (required for html/pdf) |
--debug |
Show detailed matching values |
--memory= |
Memory limit in MB (default: 2000) |
Export to HTML or PDF
Generate a styled HTML report:
Generate a PDF report:
Supported Formats
- Microsoft Excel:
.xlsx,.xls - LibreOffice Calc:
.ods
Requirements
- PHP 8.3+
- Composer
Testing
Built With
- Laravel Zero – Micro-framework for console applications
- PhpSpreadsheet – Library for reading/writing spreadsheet files
- FastExcel – Fast Excel import/export
- Dompdf – HTML to PDF converter
License
MIT License. See LICENSE for details.
All versions of spreadsheet-inspect with dependencies
dompdf/dompdf Version ^3.1
laravel-zero/framework Version ^12.0.2
phpoffice/phpspreadsheet Version ^5.4
rap2hpoutre/fast-excel Version ^5.6