php-ext-xlswriter

Why use php-ext-excel-export

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;

中文文档 Documents

1、Install the dependencies

Ubuntu

sudo apt-get install -y zlib1g-dev

git clone https://github.com/jmcnamara/libxlsxwriter.git && cd libxlsxwriter && make && sudo make install

Mac

brew install libxlsxwriter

Windows

Build the basic PHP build environment.

cd PHP_BUILD_PATH/deps

git clone --recursive https://github.com/jmcnamara/MSVCLibXlsxWriter.git

To build the DLL of the library open the LibXlsxWriterProj/LibXlsxWriter.sln project in MS Visual Studio and build the solution using the "Build -> Build Solution" menu item.

In the default configuration this will build an x64 debug LibXlsxWriter .lib and .dll in:

PHP_BUILD_PATH\deps\MSVCLibXlsxWriter\LibXlsxWriterProj\x64\Debug

32Bit: Copy .dll files to c:\Windows\System32 64Bit: Same thing

Add the lib path to the LIB environment variable.

2、Get the source code via Git

Unix

git clone https://github.com/viest/php-ext-excel-export.git
cd php-ext-excel-export
phpize && ./configure
make && make install

add the extension=excel_writer.so to php.ini file.

Windows

Clone the project to the ext directory in PHP, configure add --with-excel_writer parameter.

If you need .dll files, you should use the --with-excel_writer=shared parameter.

PHP compilation tutorial

License

PHP License 3.01