hugh/php-ext-xlswriter: 🚀 PHP Extension for creating and reader XLSX files. fork from : https://github.com/viest/php-ext-xlswriter.git @ f44200c885ae67129d4ec4cf2b5838ac711b109c

🚀 PHP Extension for creating and reader XLSX files.
fork from : https://github.com/viest/php-ext-xlswriter.git

1 Atzari

viest f44200c885 version 1.5.1		3 gadi atpakaļ
.github	8852e3d26a Test: test show all	3 gadi atpakaļ
backup	56f20cf67c windows config:	6 gadi atpakaļ
ide-helper	00836531c4 Feat: gridline and zoom	5 gadi atpakaļ
include	6e18bbabea Feat: Customize to enable or disable zip64, as WPS cannot open zip64 files	3 gadi atpakaļ
kernel	6f0f4eccdd Merge pull request #411 from viest/dev	3 gadi atpakaļ
library	7fa322cde6 Library: libxlswirter 1.1.3	3 gadi atpakaļ
resource	dc92fbb767 financial donation	5 gadi atpakaļ
tests	9f70406a79 Merge pull request #402 from viest/dev	3 gadi atpakaļ
travis	1b8478cef9 Trim trailing whitespace	6 gadi atpakaļ
.appveyor.yml	8852e3d26a Test: test show all	3 gadi atpakaļ
.gitignore	5aebad7e18 1.3.7 beta	4 gadi atpakaļ
.gitmodules	6b63297431 library update	4 gadi atpakaļ
.travis.yml	8852e3d26a Test: test show all	3 gadi atpakaļ
CREDITS	e8b993e214 project init	7 gadi atpakaļ
LICENSE	8b517d734c License BSD	7 gadi atpakaļ
README.md	e9f3dea398 Update README.md	4 gadi atpakaļ
README_zh.md	14e4606ef9 Update README_zh.md	4 gadi atpakaļ
config.m4	fd6dfb743d Feat: rich string	3 gadi atpakaļ
config.w32	fd6dfb743d Feat: rich string	3 gadi atpakaļ
excel.php	74a8faea12 add: tests	7 gadi atpakaļ
package.xml	f44200c885 version 1.5.1	3 gadi atpakaļ
php_xlswriter.h	f44200c885 version 1.5.1	3 gadi atpakaļ
xlswriter.c	fd6dfb743d Feat: rich string	3 gadi atpakaļ

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;

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

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

Install

Unix

pecl install xlswriter

Windows

download dll

Benchmark

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

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

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

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

PECL Repository

IDE Helper

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

Exchange group

Financial donation

Contributors

Code Contributors

This project exists thanks to all the people who contribute. [Contribute].

Financial Contributors

Become a financial contributor and help us sustain our community. [Contribute]

Individuals

Organizations

Support this project with your organization. Your logo will show up here with a link to your website. [Contribute]

License

BSD License

README.md