Welcome to PhpSpreadsheet's documentation
PhpSpreadsheet 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.
File formats supported
|Open Document Format/OASIS (.ods)||✓||✓|
|Office Open XML (.xlsx) Excel 2007 and above||✓||✓|
|BIFF 8 (.xls) Excel 97 and above||✓||✓|
|BIFF 5 (.xls) Excel 95||✓|
|SpreadsheetML (.xml) Excel 2003||✓|
|PDF (using either the TCPDF, Dompdf or mPDF libraries, which need to be installed separately)||✓|
PHP version 7.2 or newer to develop using PhpSpreadsheet. Other requirements, such as PHP extensions, are enforced by
composer. See the
require section of the composer.json file
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.
Use composer to install PhpSpreadsheet into your project:
composer require phpoffice/phpspreadsheet
Or also download the documentation and samples if you plan to use them:
composer require phpoffice/phpspreadsheet --prefer-source
This would be the simplest way to write a spreadsheet:
<?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $writer->save('hello world.xlsx');
Learn by example
A good way to get started is to run some of the samples. Don't forget to download them via
flag. And then serve them via PHP built-in webserver:
php -S localhost:8000 -t vendor/phpoffice/phpspreadsheet/samples
Then point your browser to:
The samples may also be run directly from the command line, for example:
Learn by documentation
Or browse the API documentation.
Please refer to the contributor list for up-to-date credits.