php 导出大量表格数据导出,PHPExcel 导出表格大量数据速度最快

/**

*兑换码下载实例

*/

public function excelCode($data)

{

$name     = '兑换码';

$header = ['兑换码‘]; //表头,名称可自定义

$this->excelExport($name,$header,$data);

}

/***

* excel表格导出

* @param string $fileName 文件名称

* @param array $headArr 表头名称

* @param array $data 要导出的数据

* @author static7

*/

public function excelExport($fileName, $headArr, $list)

{

//对数据进行检验

if (empty($list) || !is_array($list))

{

die("data must be a array");

}

//检查文件名

if (empty($fileName))

{

exit;

}

$date = date("Y_m_d_h:i", time());

$fileName .= "_{$date}.xls";

//加载PHPExcel类

vendor("Classes.PHPExcel");

//创建PHPExcel对象，注意，不能少了

$objPHPExcel =new \PHPExcel();

$objProps = $objPHPExcel->getProperties();

//设置表头

$key = ord("A");

foreach ($headArr as $v)

{

$colum = chr($key);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v);

$key += 1;

}

$column = 2;

$objActSheet = $objPHPExcel->getActiveSheet();

foreach ($list as $key => $rows)

{     //行写入

$span = ord("A");

foreach ($rows as $keyName => $value)

{    // 列写入

$j = chr($span);

$objActSheet->setCellValue($j . $column, $value);

$span++;

}

$column++;

}

$fileName = iconv("utf-8", "gb2312", $fileName);

//重命名表

// $objPHPExcel->getActiveSheet()->setTitle('test');

//设置活动单指数到第一个表,所以Excel打开这是第一个表

$objPHPExcel->setActiveSheetIndex(0);

ob_end_clean();

ob_start();

header('Content-Type: application/vnd.ms-excel');

header("Content-Disposition: attachment;filename=\"$fileName\"");

header('Cache-Control: max-age=0');

$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('php://output'); //文件通过浏览器下载

exit;

}