2017 © Pedro Peláez
 

library xlsxreader

reads xlsx file contents: from https://github.com/gneustaetter/XLSXReader.git

image

yfwserver/xlsxreader

reads xlsx file contents: from https://github.com/gneustaetter/XLSXReader.git

  • Saturday, December 24, 2016
  • by yfwserver
  • Repository
  • 0 Watchers
  • 0 Stars
  • 1,591 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 47 Forks
  • 0 Open issues
  • 3 Versions
  • 13 % Grown

The README.md

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)

  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., (*2)

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., (*3)

Usage

Open an Excel file:, (*4)

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

Get a list of the sheets:, (*5)

$sheets = $xlsx->getSheetNames();

Get the data from a sheet:, (*6)

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

What it doesn't do

There are many things XLSXReader does not aim to do:, (*7)

  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., (*8)

The Versions

24/12 2016

dev-master

9999999-dev https://github.com/yfwserver/xlsxreader

reads xlsx file contents: from https://github.com/gneustaetter/XLSXReader.git

  Sources   Download

The Requires

  • php >=5.3.0

 

php excel xls spreadsheet xlsx openxml

24/11 2016

1.0.2

1.0.2.0 https://github.com/yfwserver/xlsxreader

reads xlsx file contents: from https://github.com/gneustaetter/XLSXReader.git

  Sources   Download

The Requires

  • php >=5.3.0

 

php excel xls spreadsheet xlsx openxml

24/11 2016

1.0.1

1.0.1.0 https://github.com/yfwserver/xlsxreader

reads xlsx file contents: from https://github.com/gneustaetter/XLSXReader.git

  Sources   Download

The Requires

  • php >=5.3.0

 

php excel xls spreadsheet xlsx openxml