The Xlsx writer exports spreadsheets to Excel 2007+ format (.xlsx), also known as Office Open XML SpreadsheetML format.
Namespace: PhpOffice\PhpSpreadsheet\Writer\Xlsx
Extends: BaseWriter
Class Overview
The Xlsx writer creates ZIP archives containing XML files that conform to the Office Open XML standard. It supports the full range of PhpSpreadsheet features including styles, formulas, charts, images, and more.
Constructor
public function __construct(Spreadsheet $spreadsheet)
The spreadsheet object to write
Key Methods
save()
public function save($filename, int $flags = 0): void
File path or resource to write to
setOffice2003Compatibility()
public function setOffice2003Compatibility(bool $office2003compatibility): self
True to enable Office 2003 compatibility
setExplicitStyle0()
public function setExplicitStyle0(bool $explicitStyle0): self
True to write explicit style 0
setForceFullCalc()
public function setForceFullCalc(?bool $forceFullCalc): self
True to force full calculation, false to allow cached values, null for default behavior
setRestrictMaxColumnWidth()
public function setRestrictMaxColumnWidth(bool $restrictMaxColumnWidth): self
True to restrict column widths to 255
setUseCSEArrays()
public function setUseCSEArrays(?bool $useCSEArrays): void
True to use CSE arrays, false for dynamic arrays, null for auto
Usage Examples
Basic Export
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.xlsx');
With Charts
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$writer = new Xlsx($spreadsheet);
$writer->setIncludeCharts(true);
$writer->save('chart.xlsx');
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$writer = new Xlsx($spreadsheet);
$writer->setPreCalculateFormulas(false);
$writer->save('fast.xlsx');
Download to Browser
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
// Set headers for download
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="report.xlsx"');
header('Cache-Control: max-age=0');
$writer = new Xlsx($spreadsheet);
$writer->save('php://output');
exit;
LibreOffice Compatibility
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$writer = new Xlsx($spreadsheet);
$writer->setExplicitStyle0(true);
$writer->save('libreoffice.xlsx');
Memory Optimization
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$writer = new Xlsx($spreadsheet);
$writer->setUseDiskCaching(true, '/tmp/phpspreadsheet');
$writer->save('large.xlsx');
- ✅ Multiple worksheets
- ✅ Cell formatting (fonts, colors, borders, fills)
- ✅ Number formats
- ✅ Formulas and formula calculation
- ✅ Charts
- ✅ Images and drawings
- ✅ Rich text
- ✅ Merged cells
- ✅ Data validation
- ✅ Conditional formatting
- ✅ Page setup and print settings
- ✅ Headers and footers
- ✅ Document properties
- ✅ Named ranges
- ✅ Autofilters
- ✅ Tables
- ✅ Comments
- ✅ Hyperlinks
