/XLSXReader

PHP class for reading data from Excel XLSX files

Primary LanguagePHPOtherNOASSERTION

XLSXReader

What it does

XLSXReader is a small PHP class for reading data from Microsoft Excel XLSX (OpenXML) files. There are some much more comprehensive Excel libraries for PHP, but I created this because I was looking for a library that made it as easy as possible to:

  1. Open an Excel file
  2. Get a list of the sheets (names and sheetIds)
  3. Get the data out from a sheet into an array

XLSXReader requires the ZIP extension.

Thanks to Sergey Schuchkin for his SimpleXLSX library that served as the inspiration for XLSXReader. While most of it has been rewritten, some of his code still remains.

Usage

Open an Excel file:

require('XLSXReader.php');
$xlsx = new XLSXReader('sample.xlsx');

Get a list of the sheets:

$sheets = $xlsx->getSheetNames();

Get the data from a sheet:

$data = $xlsx->getSheetData('Sales');

What it doesn't do

There are many things XLSXReader does not aim to do:

  1. Handle sheets with a large amount of data - XLSXReader uses SimpleXML to read the sheet data, so the entire XML file is read into memory when accessing a sheet.
  2. Extract formatting, formulas, comments, headers, footers, properties, or charts
  3. Create or edit Excel files

If you need those capabilities, I would take a look at PHP-Excel.