xlswriter

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.

Writer

- 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.

Reader

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

License: BSD license

Latest releases

Version Release Download
1.4.0 2021-07-18 xlswriter-1.4.0.tgz
1.3.7 2021-01-01 xlswriter-1.3.7.tgz
1.3.6 2020-06-17 xlswriter-1.3.6.tgz
1.3.5 2020-05-25 xlswriter-1.3.5.tgz
1.3.4.1 2020-04-12 xlswriter-1.3.4.1.tgz
Show all releases

Changelog

Version Message
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
1.3.6 - Fix musllibc.
- Fix null in cell callback.
- Feat cell comment.
- Feat timestampFromDateDouble static method.
- Feat Check for existence before opening file.
1.3.5 - Feat activate sheet.
- Feat mergeCells type writer.
1.3.4.1 - Feat directory not exist error change to exception.
- Windows full function support.
Show complete changelog