Skip to content

PHP class for reading data from Excel XLSX files

License

Notifications You must be signed in to change notification settings

abhishekthanvi8/XLSXReader

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

PHP class for reading data from Excel XLSX files

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 100.0%