PHP High Performance Excel Extension 1.2.7 released

Why use php-ext-excel-export

xlswriter is a PHP C extension that can be used to write text, numbers, multiple worksheets in Excel 2007 XLSX files Formulas and hyperlinks.

It supports the following features:

● 100% compatible Excel XLSX files

● Complete Excel format

● Merge Cell

● AutoFilter

● Chart

● Data Validation and Drop-down List

● Worksheet PNG/JPEG Image

● Memory optimized mode for writing large files

● Applicable to Linux, FreeBSD, OpenBSD, OS X, Windows

● Compiled for 32-bit and 64-bit

● FreeBSD License

● The only dependency is zlib

##Benchmark

Test environment:

● Macbook Pro 13 inch

● Intel Core i5

● 16GB 2133MHz LPDDR3 Memory

● 128GB SSD Storage.

Export

Two memory modes, export 100W rows of data, 27 columns in a single row, 19 Chinese characters in each cell

● Regular mode: takes 29S, memory usage 2083MB;

● Fixed memory mode: takes 52S, memory usage

Read

Read 100W rows of data, 1 per row Column, cell data is int

● Full read: takes 3S, memory usage is 558MB;

● Cursor read: takes 2.8S, memory usage

Warehouse address

Github:

https://github.com/viest/php-ext-excel-exp...

Gitee:

https://gitee.com/viest/php-ext-xlswriter

PECL:

https://pecl.php.net/package/xlswriter

Documentation

https://xlswriter-docs.viest.me

For more PHP knowledge, please Visit

PHP Chinese website!

The above is the detailed content of PHP High Performance Excel Extension 1.2.7 released. For more information, please follow other related articles on the PHP Chinese website!