PHP使用xlsxwriter导出Excel

首先使用composer安装xlsxwriter,示例如下:

composer create-project mk-j/php_xlsxwriter
// 或者
composer require mk-j/php_xlsxwriter

安装完成之后就可以使用了,下面是简单的使用示例:

$title = ['昵称','头像','手机号','日期'];//设置头

$sheet1 = 'sheet1';//设置工作簿名称

$writer = new \XLSXWriter();
$styles1 = array( 'font'=>'宋体','font-size'=>10,'font-style'=>'bold', 'fill'=>'#eee',
            'halign'=>'center', 'border'=>'left,right,top,bottom');//设置样式
$writer->writeSheetRow($sheet1, $title,$styles1);//写入头

$styles2 = ['height'=>16];//单独设置头的样式
//遍历数据
foreach($data as $row){
    $writer->writeSheetRow($sheet1,[$row['nickname'],$row['head_img'],$row['tel'],$row['add_time']],$