PHPackages                             viest/xlswriter - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. viest/xlswriter

ActivePhp-ext[PDF & Document Generation](/categories/documents)

viest/xlswriter
===============

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.

2.4k23232[47 issues](https://github.com/viest/php-ext-xlswriter/issues)[5 PRs](https://github.com/viest/php-ext-xlswriter/pulls)CCI passing

Since Mar 9Pushed 2mo ago36 watchersCompare

[ Source](https://github.com/viest/php-ext-xlswriter)[ Packagist](https://packagist.org/packages/viest/xlswriter)[ RSS](/packages/viest-xlswriter/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (10)DependenciesVersions (1)Used By (0)

[![php-ext-xlswriter](resource/logo_now.png)](resource/logo_now.png)

[![php-ext-xlswriter](https://camo.githubusercontent.com/bb7d81da7539ae906096150e6c0ca6682ecde21b7f6a24139eb0a0bc9cf0e6e9/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f72656c656173652f76696573742f7068702d6578742d657863656c2d6578706f72742e737667)](https://github.com/viest/php-ext-xlswriter/releases)

[![php-ext-xlswriter](https://camo.githubusercontent.com/ffe1f5837ed0661e7d081081868978e02e2fdc8f74fd382c7c00d6712caf045d/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f706c6174666f726d2d6d61636f732532302537432532306c696e757825323025374325323077696e646f77732d627269676874677265656e2e737667)](https://github.com/viest/php-ext-xlswriter)

[![php-ext-xlswriter](https://camo.githubusercontent.com/278307252db537d5cf8848d00198ea5986bb1c1a3fe1bc166f8852328e60b75b/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f616374696f6e732f776f726b666c6f772f7374617475732f76696573742f7068702d6578742d786c737772697465722f6d61696e2e796d6c3f6272616e63683d6d6173746572266c6f676f3d676974687562)](https://github.com/viest/php-ext-xlswriter/actions)[![php-ext-xlswriter](https://camo.githubusercontent.com/6b8696d32489c575275c842acd49f636da0bccb1aec82f1ce034502d452231f8/68747470733a2f2f7472617669732d63692e636f6d2f76696573742f7068702d6578742d786c737772697465722e7376673f6272616e63683d6d6173746572)](https://travis-ci.com/viest/php-ext-xlswriter)[![php-ext-xlswriter](https://camo.githubusercontent.com/315e70afbc1328d686a8ef853f7dd345632c99c145201fc51ec3f96749b38f64/68747470733a2f2f63692e6170707665796f722e636f6d2f6170692f70726f6a656374732f7374617475732f773463666a6f3965346773727336726e2f6272616e63682f6d61737465723f7376673d74727565)](https://ci.appveyor.com/project/viest/php-ext-excel-export/branch/master)[![php-ext-xlswriter](https://camo.githubusercontent.com/0f9c00af68d4f83db09d8178a3021c492405ccbcbd01e26e0d0be3763d5fcc3c/68747470733a2f2f6170702e666f7373612e696f2f6170692f70726f6a656374732f6769742532426769746875622e636f6d25324676696573742532467068702d6578742d786c737772697465722e7376673f747970653d736869656c64)](https://app.fossa.io/projects/git%2Bgithub.com%2Fviest%2Fphp-ext-xlswriter?ref=badge_shield)

[![php-ext-xlswriter](https://camo.githubusercontent.com/86bd6c22cacbc28a2fcbf4c61cba675c47799269e2e128cfaa2bdc6013597adc/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f616c6c2f62616467652e7376673f6c6162656c3d66696e616e6369616c2b636f6e7472696275746f7273)](https://opencollective.com/php-ext-xlswriter)[![php-ext-xlswriter](https://camo.githubusercontent.com/4226c9c8b62bd44b0e95de95d201197f5196e1b78e8d771841a1d7b0ad98447f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048502d253345253344253230372e302d627269676874677265656e2e737667)](https://github.com/viest/php-ext-xlswriter)[![php-ext-xlswriter](https://camo.githubusercontent.com/a062e24003fb19828d278935f6f1bfc0dd465f85a6ffbb082529f0ed14474df3/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f636f6e7472696275746f72732f76696573742f7068702d6578742d657863656c2d6578706f72742e737667)](https://github.com/viest/php-ext-xlswriter)[![php-ext-xlswriter](https://camo.githubusercontent.com/915f87e956ba1ba46b605760796f97aaf2af77b571424e3a0cb4566f9bd9ee9d/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4253442d677265656e2e737667)](https://github.com/viest/php-ext-xlswriter)[![php-ext-xlswriter](https://camo.githubusercontent.com/1cf53e95c56aefc20a23debea335a0f26f720e555b732c60b0d3b97fb1967d00/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6973737565732f76696573742f7068702d6578742d657863656c2d6578706f72742e737667)](https://github.com/viest/php-ext-xlswriter)[![php-ext-xlswriter](https://camo.githubusercontent.com/f3d2638709976b94a3b84150aa8f1391fa3ec09cf03425790cc0b9b38e9a5d46/68747470733a2f2f686974732e736565796f756661726d2e636f6d2f6170692f636f756e742f696e63722f62616467652e7376673f75726c3d68747470732533412532462532466769746875622e636f6d25324676696573742532467068702d6578742d786c7377726974657226636f756e745f62673d253233373943383344267469746c655f62673d2532333535353535352669636f6e3d2669636f6e5f636f6c6f723d253233453745374537267469746c653d6869747326656467655f666c61743d66616c7365)](https://hits.seeyoufarm.com)

Why use xlswriter
-----------------

[](#why-use-xlswriter)

Please refer to the image below. PHPExcel has been unable to work properly for memory reasons at 40,000 and 100000 points, but it can be resolved by modifying the ini configuration, but the time may take longer to complete the work;

[![php-excel](resource/performance_comparison.png)](resource/performance_comparison.png)

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. It supports features such as:

###### Writer

[](#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

[](#reader)

- Full read data
- Cursor read data
- Read by data type

#### Install

[](#install)

###### Unix

[](#unix)

```
pecl install xlswriter
```

###### Windows

[](#windows)

[download dll](https://github.com/viest/php-ext-xlswriter/releases)

#### Benchmark

[](#benchmark)

Test environment: Macbook Pro 13 inch, Intel Core i5, 16GB 2133MHz LPDDR3 Memory, 128GB SSD Storage.

##### Export

[](#export)

> Two memory modes export 1 million rows of data (27 columns, data is string)

- Normal mode: only 29S is needed, and the memory only needs 2083MB;
- Fixed memory mode: only need 52S, memory only needs <1MB;

##### Import

[](#import)

> 1 million rows of data (1 columns, data is inter)

- Full mode: Just 3S, the memory is only 558MB;
- Cursor mode: Just 2.8S, memory is only <1MB;

[Documents](https://xlswriter-docs.viest.me/)
---------------------------------------------

[](#documents)

Includes extensive and detailed instructions that make it easy to get started with xlswriter.

PECL Repository
---------------

[](#pecl-repository)

[![pecl](resource/pecl.png)](https://pecl.php.net/package/xlswriter)

IDE Helper
----------

[](#ide-helper)

```
composer require viest/php-ext-xlswriter-ide-helper:dev-master
```

Contributors
------------

[](#contributors)

### Code Contributors

[](#code-contributors)

This project exists thanks to all the people who contribute. \[[Contribute](CONTRIBUTING.md)\]. [![](https://camo.githubusercontent.com/a84e8f11f73bc87c96ca290189274dfbbfead817276178bf1e5efa4d7f4ffc3e/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f636f6e7472696275746f72732e7376673f77696474683d38393026627574746f6e3d66616c7365)](https://github.com/viest/php-ext-xlswriter/graphs/contributors)

### Financial Contributors

[](#financial-contributors)

Become a financial contributor and help us sustain our community. \[[Contribute](https://opencollective.com/php-ext-xlswriter/contribute)\]

#### Individuals

[](#individuals)

[![](https://camo.githubusercontent.com/02883a925e75c781fd59e6e11942f8a855dd3e4afa4076ccc5dad3de767ddbb6/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f696e646976696475616c732e7376673f77696474683d383930)](https://opencollective.com/php-ext-xlswriter)

#### Organizations

[](#organizations)

Support this project with your organization. Your logo will show up here with a link to your website. \[[Contribute](https://opencollective.com/php-ext-xlswriter/contribute)\]

[![](https://camo.githubusercontent.com/c339328c23ee3162fcbb8c9bd5182bed63e2b4b35c5c47cd2c6940b2680b95ce/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f302f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/0/website)[![](https://camo.githubusercontent.com/30a4eb95aa68b02c225208706322a2db53f01b2ad9166990eee12fd681677529/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f312f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/1/website)[![](https://camo.githubusercontent.com/0430acaf464800cf9841da66f1d9ff83d2c1d0744a59c105ffe79d0a82e46508/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f322f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/2/website)[![](https://camo.githubusercontent.com/e0e6c2a0048fe46cf503a44abaed53da666c33cb704a2b73ca49bb66ac2dd253/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f332f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/3/website)[![](https://camo.githubusercontent.com/2c6e1878c01ad97fa594588f04be90ae37b99aeb2bbfe6e608dd5985e7040ff1/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f342f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/4/website)[![](https://camo.githubusercontent.com/3b75ce76e74d581ba88ed89fc9e875a8cdfdda2b24f3394ae664c2c06869c020/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f352f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/5/website)[![](https://camo.githubusercontent.com/a40b1a10008d348a7882845471c7a646ba07d3bad9e27e1ee6bddcd562765d31/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f362f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/6/website)[![](https://camo.githubusercontent.com/8b99ed867cfce4d7ab0b4e27fed900c5f53b436460c8b127a20924219615921e/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f372f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/7/website)[![](https://camo.githubusercontent.com/4a022241769f023774e5c1e83615cf35d893eb1e458d0dde4ed4003607fff9f5/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f382f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/8/website)[![](https://camo.githubusercontent.com/e08bded3f4f603568cdcf4a150b8e5e2276cd91b759e8c6d992224f42f65a56b/68747470733a2f2f6f70656e636f6c6c6563746976652e636f6d2f7068702d6578742d786c737772697465722f6f7267616e697a6174696f6e2f392f6176617461722e737667)](https://opencollective.com/php-ext-xlswriter/organization/9/website)

License
-------

[](#license)

BSD License

[![FOSSA Status](https://camo.githubusercontent.com/0040fe7f22299ed6c728d34f09f1323c135043f28586bb5b0840929488e6d159/68747470733a2f2f6170702e666f7373612e696f2f6170692f70726f6a656374732f6769742532426769746875622e636f6d25324676696573742532467068702d6578742d786c737772697465722e7376673f747970653d6c61726765)](https://app.fossa.io/projects/git%2Bgithub.com%2Fviest%2Fphp-ext-xlswriter?ref=badge_large)

Stargazers over time
--------------------

[](#stargazers-over-time)

[![Stargazers over time](https://camo.githubusercontent.com/b57a7209323eb2832272475717d4dae12ade548cf704e3715f344fcccaf3c127/68747470733a2f2f7374617263686172742e63632f76696573742f7068702d6578742d786c737772697465722e737667)](https://starchart.cc/viest/php-ext-xlswriter)

###  Health Score

34

—

LowBetter than 77% of packages

Maintenance61

Regular maintenance activity

Popularity37

Limited adoption so far

Community30

Small or concentrated contributor base

Maturity11

Early-stage or recently created project

 Bus Factor1

Top contributor holds 93% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/84c9bf729cfb5e1fc86c22f6f55b534b818a146c16f9fc39eaa6654e81730a62?d=identicon)[Viest](/maintainers/Viest)

---

Top Contributors

[![viest](https://avatars.githubusercontent.com/u/14308107?v=4)](https://github.com/viest "viest (676 commits)")[![remicollet](https://avatars.githubusercontent.com/u/270445?v=4)](https://github.com/remicollet "remicollet (30 commits)")[![motecshine](https://avatars.githubusercontent.com/u/7615270?v=4)](https://github.com/motecshine "motecshine (5 commits)")[![petk](https://avatars.githubusercontent.com/u/1614009?v=4)](https://github.com/petk "petk (4 commits)")[![gyalogmixi](https://avatars.githubusercontent.com/u/33487866?v=4)](https://github.com/gyalogmixi "gyalogmixi (3 commits)")[![HaiD84](https://avatars.githubusercontent.com/u/2562280?v=4)](https://github.com/HaiD84 "HaiD84 (2 commits)")[![fossabot](https://avatars.githubusercontent.com/u/29791463?v=4)](https://github.com/fossabot "fossabot (1 commits)")[![weltling](https://avatars.githubusercontent.com/u/22016?v=4)](https://github.com/weltling "weltling (1 commits)")[![molinchenxi](https://avatars.githubusercontent.com/u/26620861?v=4)](https://github.com/molinchenxi "molinchenxi (1 commits)")[![monkeywithacupcake](https://avatars.githubusercontent.com/u/7316730?v=4)](https://github.com/monkeywithacupcake "monkeywithacupcake (1 commits)")[![sergeyklay](https://avatars.githubusercontent.com/u/1256298?v=4)](https://github.com/sergeyklay "sergeyklay (1 commits)")[![stramunin](https://avatars.githubusercontent.com/u/1451700?v=4)](https://github.com/stramunin "stramunin (1 commits)")[![sy-records](https://avatars.githubusercontent.com/u/33931153?v=4)](https://github.com/sy-records "sy-records (1 commits)")

---

Tags

dllexcelexcel-exportexcelwriterextensionlaravellibxlsxwriterpeclphalconphpswoolexlswriterxlsxxlsx-filesxlsx-writerxlsxreaderxlsxwriter

### Embed Badge

![Health badge](/badges/viest-xlswriter/health.svg)

```
[![Health](https://phpackages.com/badges/viest-xlswriter/health.svg)](https://phpackages.com/packages/viest-xlswriter)
```

###  Alternatives

[phpoffice/phpspreadsheet

PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine

13.9k293.5M1.2k](/packages/phpoffice-phpspreadsheet)[spatie/browsershot

Convert a webpage to an image or pdf using headless Chrome

5.2k32.1M100](/packages/spatie-browsershot)[smalot/pdfparser

Pdf parser library. Can read and extract information from pdf file.

2.7k34.5M216](/packages/smalot-pdfparser)[barryvdh/laravel-snappy

Snappy PDF/Image for Laravel

2.8k24.8M48](/packages/barryvdh-laravel-snappy)[openspout/openspout

PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

1.1k57.6M128](/packages/openspout-openspout)[keboola/csv

Keboola CSV reader and writer

1451.8M21](/packages/keboola-csv)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)