PHP7 Study Notes (12) Phpexcel vs Phpspreadsheet and Php_xlsxwriter

Objective

Phpspreadsheet is the next version of Phpexcel. It breaks compatibility and greatly improves the quality of the codebase (namespaces, PSR Compliance, using the latest PHP language features, etc.). As all efforts are shifted to the phpspreadsheet,phpexcel will no longer be maintained. All contributions to phpexcel, patches, and new features should be directed towards the Phpspreadsheet development Branch.

The difference

Phpexcel is an open-source framework for processing Excel,cvs files based on Microsoft's OPENXML Standard and PHP language. It can be used to read and write spreadsheets in different formats, which is the most common Excel processing tool in PHP so far, but it has a very deadly disadvantage: especially in memory, the large amount of tabular data will almost make people tired of love, processing speed is very slow, but it is very rich, the API is very many, So when you export a complex format Excel table, you often have to use it, it's really love and hate.

Unfortunately, Phpexcel officially no longer maintained the project, the official team on GitHub on a new project, called Phpspreadsheet, the new project uses a lot of new PHP features, such as namespaces, PSR Standard, performance is much higher than phpexcel. Now the latest release is 1.2.0 (2018-03-12)

Today the update relies on this warning that always appears

So, just a little bit of a replacement.

Reference:

Http://www.jb51.net/article/118791.htm

PHP7 Study Notes (12) Phpexcel vs Phpspreadsheet and Php_xlsxwriter