Efficient and fast xlsx file extension.

xlswriter is a PHP C Extension that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.


- 100% compatible Excel XLSX files.
- Full Excel formatting.
- Merged cells.
- Defined names.
- Autofilters.
- Charts.
- Data validation and drop down lists.
- Worksheet PNG/JPEG images.
- Memory optimization mode for writing large files.
- Works on Linux, FreeBSD, OpenBSD, OS X, Windows.
- Compiles for 32 and 64 bit.
- FreeBSD License.
- The only dependency is on zlib.


- Full read data
- Cursor read data
- Read by data type
- Xlsx to csv

License: BSD license

Latest releases

Version Release Download
1.5.2 2022-04-28 xlswriter-1.5.2.tgz
1.5.1 2021-10-26 xlswriter-1.5.1.tgz
1.5.0 2021-10-07 xlswriter-1.5.0.tgz
1.4.0 2021-07-18 xlswriter-1.4.0.tgz
1.3.7 2021-01-01 xlswriter-1.3.7.tgz
Show all releases


Version Message
1.5.2 - Fix: Write failure on data reference.
- Fix: String is not zero-terminatedpage.
1.5.1 - Feat customize to enable or disable zip64.
1.5.0 - Feat set current line.
- Feat get current line.
- Feat rich string.
1.4.0 - Fix disable reader build failed.
- Fix insertDate use curtom format segmentation fault.
- Feat custom free resource.
- Feat writer validation.
- Feat writer data validation can be applied to a single cell or a range of cells.
- Feat reader add file path in open file exception message.
- Feat exit worksheet.
- Feat set paper.
- Feat set margins.
- Build read module is enabled by default.
- Perfect exception message.
- Compatible PHP 8.1 API.
- Destructive rename method setPrintedLandscape to setLandscape
- Destructive rename method setPrintedPortrait to setPortrait
1.3.7 - Fix IBM s390x.
- Fix header line no and sheet checkout not init line no.
- Fix single instance opens multiple files, but the file handle is not released.
- Feat worksheet printed.
- Feat worksheet hidden.
- Feat workbook custom first worksheet.
- Feat custom skip hidden rows.
- Feat skip empty rows.
- Feat set global type.
- Feat url text and tool tip.
- Feat work sheet protection.
- Helper xlswriter_get_version and xlswriter_get_author
Show complete changelog