Startsida Utforska Hjälp
Logga in
hugh
/
php-ext-xlswriter
1
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki

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

Träd: 0c10ea3896
Grenar Taggar
php-ext-xlsw...
ZIP TAR.GZ
viest 0c10ea3896 Fix: minizip multiple definition 5 år sedan
backup 56f20cf67c windows config: 6 år sedan
include 4aa86eda0e Fix(property): return val 5 år sedan
kernel 8b47d5ac46 version 1.2.7 5 år sedan
library 7e23816db5 Feat(Read): load xlsx file 5 år sedan
resource 79b2d995cb readme update 5 år sedan
tests 8b47d5ac46 version 1.2.7 5 år sedan
travis 1b8478cef9 Trim trailing whitespace 6 år sedan
.appveyor.yml 0fa7e207a8 config.m4 5 år sedan
.gitignore b1a74ec0bf Style(Config.w32): Format 6 år sedan
.gitmodules 7e23816db5 Feat(Read): load xlsx file 5 år sedan
.travis.yml 22a736fd8b Travis CI 5 år sedan
CREDITS e8b993e214 project init 7 år sedan
LICENSE 8b517d734c License BSD 7 år sedan
README.md a8dc808a05 DOC Update 5 år sedan
README_zh.md a8dc808a05 DOC Update 5 år sedan
config.m4 0c10ea3896 Fix: minizip multiple definition 5 år sedan
config.w32 2fca01c326 Fix(win32): include 6 år sedan
excel.php 74a8faea12 add: tests 7 år sedan
package.xml 8b47d5ac46 version 1.2.7 5 år sedan
php_xlswriter.h 294d5f1530 package 5 år sedan
xlswriter.c dacebc8430 Style(include): merge to include dir 6 år sedan

README.md

php-excel

Build Status Build status

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

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:

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

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

文档|Documents

PECL Repository

pecl

Exchange group

License

FreeBSD license