SpreadSheet Maker Library

SpreadSheet Maker is a library written in pure PHP and offers a set of classes that allow you to read and write various spreadsheet file formats such as Excel and LibreOffice Calc.

SpreadSheet Maker is the next version of PHP Excel libraries. It breaks compatibility to dramatically improve the code base quality (namespaces, PSR compliance, use of latest PHP language features, etc.). 

Software requirements

PHP version 7.3 or newer to develop usingSpreadSheet Maker . Other requirements, such as PHP extensions, are enforced by composer. See the require section of the composer.json file for details.

PHP version support

Support for PHP versions will only be maintained for a period of six months beyond the end of life of that PHP version.

* Convert SQL to excel
* Convert Excel to SQL
* Supports PHP 7 >
* Require composer


Readers Writers Methods
XLS XLSX Excel2003XML Ods Gnumeric CSV SYLK XLS XLSX Ods CSV HTML PDF Getters Setters
Reader Options ✔ ✔ ● ● ✔ N/A N/A N/A N/A N/A N/A N/A N/A
Read Data Only (no formatting) ✔ ✔ ✖ ✖ ✔ N/A N/A N/A N/A N/A N/A N/A N/A $reader->getReadDataOnly() $reader->setReadDataOnly()
Read Only Specified Worksheets ✔ ✔ ✔ ✔ ✔ N/A N/A N/A N/A N/A N/A N/A N/A $reader->getLoadSheetsOnly() $reader->setLoadSheetsOnly()
$reader->setLoadAllSheets()
Read Only Specified Cells ✔ ✔ ✔ ✔ ✔ N/A N/A N/A N/A N/A N/A N/A N/A $reader->getReadFilter() $reader->setReadFilter()
Document Properties ● ✔ ✔ ✔ ✔ N/A N/A ● ✔ ✔ N/A N/A ●
Standard Properties ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ● N/A N/A ●
Creator ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ✔ N/A ✔ ✔ $spreadsheet->getProperties()->getCreator() $spreadsheet->getProperties()->setCreator()
Creation Date/Time ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ✔ N/A N/A ✖ $spreadsheet->getProperties()->getCreated() $spreadsheet->getProperties()->setCreated()
Modifier ✔ ✔ ✔ N/A N/A N/A N/A ✔ ✔ ✖ N/A N/A ✖ $spreadsheet->getProperties()->getLastModifiedBy() $spreadsheet->getProperties()->setLastModifiedBy()
Modified Date/Time ✔ ✔ ✔ ✔ N/A N/A N/A ✔ ✔ ✖ N/A N/A ✖ $spreadsheet->getProperties()->getModified() $spreadsheet->getProperties()->setModified()
Title ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ✔ N/A ✔ ✔ $spreadsheet->getProperties()->getTitle() $spreadsheet->getProperties()->setTitle()
Description ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ✔ N/A N/A ✖ $spreadsheet->getProperties()->getDescription() $spreadsheet->getProperties()->setDescription()
Subject ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ✔ N/A ✔ ✔ $spreadsheet->getProperties()->getSubject() $spreadsheet->getProperties()->setSubject()
Keywords ✔ ✔ ✔ ✔ ✔ N/A N/A ✔ ✔ ✔ N/A ✔ ✔ $spreadsheet->getProperties()->getKeywords() $spreadsheet->getProperties()->setKeywords()
Extended Properties ✔ ✔ ✔ N/A ✔ N/A N/A ✔ ● N/A N/A
Category ✔ ✔ ✔ N/A ✔ N/A N/A ✔ ✔ N/A N/A $spreadsheet->getProperties()->getCategor