Read Excel Files in PHP: 3 Options with Code Examples (2023)
If you are working with data, you might have come across Excel files that need to be imported and manipulated in your PHP application. There are several PHP libraries available that allow you to read Excel files. In this article, we'll cover three popular libraries: SimpleXLSX PhpSpreadsheet Spout Quick Comparison The following table provides a quick overview of the key features and differences between the three libraries. FeatureSimpleXLSXPhpSpreadsheetSpoutFile FormatsXLSX, XLSXLSX, XLS, CSVXLSX, CSVAdvanced FeaturesBasicAdvancedBasicReading EfficiencyGoodMediumExcellentWriting EfficiencyGoodMediumExcellentAPI ComplexitySimpleAdvancedSimpleMaintenanceLowHighMediumDocumentationBasicComprehensiveBasic Read Excel Files in PHP Code Examples Read Excel Files in PHP with SimpleXLSX <?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\IOFactory; $spreadsheet = IOFactory::load('example.xlsx'); $worksheet = $spreadsheet->getActiveSheet(); $data = $worksheet->toArray(null, true, true, true); print_r($data); ?> Read Excel Files in PHP with PhpSpreadsheet <?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\IOFactory; $spreadsheet = IOFactory::load('example.xlsx'); $worksheet = $spreadsheet->getActiveSheet(); $data = $worksheet->toArray(null, true, true, true); print_r($data); ?> Read Excel Files in PHP with Spout <?php require_once('vendor/autoload.php'); use Box\Spout\Reader\Common\Creator\ReaderEntityFactory; $reader = ReaderEntityFactory::createXLSXReader();…
