Strona główna Odkrywaj Pomoc
Zaloguj się
hugh
/
php-ext-xlswriter
1
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki

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

Drzewo: fd5bd28130
Gałęzie Tagi
php-ext-xlsw...
ZIP TAR.GZ
viest fd5bd28130 update doc 5 lat temu
.github e1625d5e92 Update FUNDING.yml 5 lat temu
backup 56f20cf67c windows config: 6 lat temu
ide-helper 00836531c4 Feat: gridline and zoom 5 lat temu
include 739412ef94 Feat(Read): sheet list 5 lat temu
kernel e7048e045f Merge pull request #195 from viest/dev 5 lat temu
library 7e23816db5 Feat(Read): load xlsx file 5 lat temu
resource 79b2d995cb readme update 5 lat temu
tests 739412ef94 Feat(Read): sheet list 5 lat temu
travis 1b8478cef9 Trim trailing whitespace 6 lat temu
.appveyor.yml 0fa7e207a8 config.m4 5 lat temu
.gitignore b1a74ec0bf Style(Config.w32): Format 6 lat temu
.gitmodules 7e23816db5 Feat(Read): load xlsx file 5 lat temu
.travis.yml 5176a92fc2 Test: read cell by callback 5 lat temu
CREDITS e8b993e214 project init 7 lat temu
LICENSE 8b517d734c License BSD 7 lat temu
README.md fd5bd28130 update doc 5 lat temu
README_zh.md 5fa3a3e119 update doc 5 lat temu
config.m4 8139123b63 allow to build with system libxlsxio 5 lat temu
config.w32 2fca01c326 Fix(win32): include 6 lat temu
excel.php 74a8faea12 add: tests 7 lat temu
package.xml 739412ef94 Feat(Read): sheet list 5 lat temu
php_xlswriter.h 49ab8c557f 1.3.1 5 lat temu
xlswriter.c feb5b1a4c9 report libxlsxio in phpinfo 5 lat temu

README.md

php-excel

[![Build Status](https://travis-ci.org/viest/php-ext-xlswriter.svg?branch=master)](https://travis-ci.org/viest/php-ext-xlswriter) [![Build status](https://ci.appveyor.com/api/projects/status/w4cfjo9e4gsrs6rn/branch/master?svg=true)](https://ci.appveyor.com/project/viest/php-ext-excel-export/branch/master) [![](https://img.shields.io/github/release/viest/php-ext-excel-export.svg)](https://github.com/viest/php-ext-xlswriter)

Build Status Build status Financial Contributors on Open Collective FOSSA 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:

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

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

IDE Helper

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

Exchange group

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

FreeBSD license

FOSSA Status