- Excel导出
function exportExcel($expTitle, $expCellName, $expTableData) {
require_once 'PHPExcel/PHPExcel.php';
$xlsTitle = iconv('utf-8', 'gb2312', $expTitle);
$fileName = $expTitle . date('_YmdHis') . '.xls';
$cellNum = count($expCellName);
$dataNum = count($expTableData);
$objPHPExcel = new PHPExcel();
$cellName = range('A', 'Z');
foreach (range('A', 'Z') as $char) {
foreach (range('A', 'Z') as $char2) {
$cellName[] = $char . $char2;
}
}
$objPHPExcel->getActiveSheet()->mergeCells('A1:' . $cellName[$cellNum - 1] . '1');
$objPHPExcel->getActiveSheet()->setCellValue('A1', $xlsTitle)
->setCellValue('A2', 'Export time: ' . date('Y-m-d H:i:s'));
for ($i = 0; $i < $cellNum; $i++) {
$objPHPExcel->getActiveSheet()