<?php/** * Composer安装: composer require mk-j/php_xlsxwriter *//** * 导出用户表 * @param $exportlist * dh */public function _exportExcel($exportlist){ $title = array ( 0 => 'ID', 1 => '会员昵称', 2 => '会员邮箱', 3 => '手机号码', 4 => '会员备注', 5 => '创建时间', 6 => '积分', ); $filename = "会员".date('Y-m-d',time()).".xlsx"; expordExcel($exportlist,$title,$filename);}/** * 导出EXCEL * 写在在公共方法里面 * dh */if(!function_exists('expordExcel')) { function expordExcel($export_date = [],$title_list = [],$filename = '') { //设置 header，用于浏览器下载 header('Content-disposition: attachment; filename="'.$filename.'"'); header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); header('Content-Transfer-Encoding: binary'); header('Cache-Control: must-revalidate'); header('Pragma: public'); $writer = new XLSXWriter(); $fields = []; $datalen = 0; foreach ($export_date as $key => $value) { $k=$key+1; if(is_array($value) && $k == 1) { foreach ($value as $ik=>$iv) { $fields[] = $ik; } $datalen = count($value); } if($fields) { foreach ($fields as $fieditem) { $data_array[$k][] = $export_date[$key][$fieditem]; //对每列指定数据类型，对应单元格的数据类型 $col_style[] = is_float($export_date[$key][$fieditem]) ? 'price' : 'string'; } } } //工作簿名称 $sheet1 = 'sheet1'; $widths = []; for ($i=0;$i<$datalen;$i++) { $widths[$i] = 20; } //设置列格式，suppress_row: 去掉会多出一行数据；widths: 指定每列宽度 $writer->writeSheetHeader($sheet1, $col_style, ['suppress_row'=>true,'widths'=> $widths] ); //写入第二行的数据，顺便指定样式 $writer->writeSheetRow($sheet1, [$filename], ['height'=>28,'font-size'=>16,'font-style'=>'bold','halign'=>'center','valign'=>'center']); /*设置标题头，指定样式*/ $styles1 = array( 'font'=>'微软雅黑','font-size'=>10,'font-style'=>'bold', 'fill'=>'#eee', 'halign'=>'center', 'border'=>'left,right,top,bottom'); $writer->writeSheetRow($sheet1, $title_list, $styles1); // 最后是数据，foreach写入 foreach ($data_array as $value) { foreach ($value as $item) { $temp[] = $item;} $rows[] = $temp; unset($temp); } $styles2 = ['height'=>16]; foreach($rows as $row){ $writer->writeSheetRow($sheet1, $row,$styles2); } //合并单元格，第一行的大标题需要合并单元格 $writer->markMergedCell($sheet1, $start_row = 0, $start_col = 0, $end_row = 0, $end_col = $datalen); //输出文档 $writer->writeToStdOut(); exit(0); }}