Accueil Explorer Aide
Connexion
hugh
/
php-ext-xlswriter
1
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki

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

Aborescence: 862d1fc6e8
Branches Tags
php-ext-xlsw...
ZIP TAR.GZ
viest 862d1fc6e8 Feat: margins il y a 3 ans
.github 005aaf7fba action il y a 4 ans
backup 56f20cf67c windows config: il y a 6 ans
ide-helper 00836531c4 Feat: gridline and zoom il y a 5 ans
include 862d1fc6e8 Feat: margins il y a 3 ans
kernel 862d1fc6e8 Feat: margins il y a 3 ans
library 6b63297431 library update il y a 4 ans
resource dc92fbb767 financial donation il y a 5 ans
tests 862d1fc6e8 Feat: margins il y a 3 ans
travis 1b8478cef9 Trim trailing whitespace il y a 6 ans
.appveyor.yml c5af9159ae appveyor 8.0.0 il y a 4 ans
.gitignore 5aebad7e18 1.3.7 beta il y a 4 ans
.gitmodules 6b63297431 library update il y a 4 ans
.travis.yml f27344cd96 Fix: 8.0 arg info il y a 4 ans
CREDITS e8b993e214 project init il y a 7 ans
LICENSE 8b517d734c License BSD il y a 7 ans
README.md e9f3dea398 Update README.md il y a 4 ans
README_zh.md 14e4606ef9 Update README_zh.md il y a 4 ans
config.m4 fdcd294f52 Feat: exception message and reader il y a 3 ans
config.w32 28605a6dd5 Feat: validation il y a 4 ans
excel.php 74a8faea12 add: tests il y a 7 ans
package.xml a8ac46dbac release 1.3.7 il y a 4 ans
php_xlswriter.h d64ee720e1 Feat: helper function il y a 4 ans
xlswriter.c 28605a6dd5 Feat: validation il y a 4 ans

README.md

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:

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

pecl

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

FOSSA Status

Stargazers over time

Stargazers over time