介绍

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;

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.

• PECL

• 编译安装
• 创建一个简单的xlsx文件
• 图表添加数据
• 直方图
• 面积图
• 单元格插入文字
• 单元格插入链接
• 单元格插入公式
• 单元格插入本地图片
• 数据过滤
• 合并单元格
• 设置列单元格格式
• 设置行单元格格式
• 设置文字颜色
• 固定内存导出
• 创建工作表
• 组合样式
• 样式列表
• 颜色常量