数据:
Array
(
[明细] => Array
(
[0] => Array
(
[0] => 订单号
[1] => SKU
[2] => 数量
[3] => 单价
[4] => 金额
)
[1] => Array
(
[0] => PA00912006030006
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[2] => Array
(
[0] => DA00912006030007
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[3] => Array
(
[0] => PA00912006030011
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[4] => Array
(
[0] => PA00912006030012
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[5] => Array
(
[0] => PA00912006030013
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[6] => Array
(
[0] => PA00912006040007
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[7] => Array
(
[0] => PA00912006040008
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[8] => Array
(
[0] => PA00912006040009
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[9] => Array
(
[0] => PA00912006040010
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[10] => Array
(
[0] => PA00912006040011
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[11] => Array
(
[0] => PA00912006040012
[1] => KO111
[2] => 1
[3] => 20.00
[4] => 20
)
[12] => Array
(
[0] => PA00912006040013
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[13] => Array
(
[0] => PA00912006040014
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[14] => Array
(
[0] => PA00912006040015
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[15] => Array
(
[0] => PA00912006040016
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[16] => Array
(
[0] => PA00912006040017
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[17] => Array
(
[0] => PA00912006040018
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[18] => Array
(
[0] => PA00912006040019
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[19] => Array
(
[0] => PA00912006040020
[1] => KO111
[2] => 2
[3] => 20.00
[4] => 40
)
[20] => Array
(
[0] => 汇总
[1] =>
[2] => 27
[3] =>
[4] => 540
)
)
[汇总] => Array
(
[0] => Array
(
[0] => SKU
[1] => 数量
[2] => 单价
[3] => 金额
)
[1] => Array
(
[0] => KO111
[1] => 27
[2] => 20.00
[3] => 540
)
[2] => Array
(
[0] => 汇总
[1] => 27
[2] =>
[3] => 540
)
)
)
/**
* 导出 Excel
* @param array $content 内容
* @param string $fileName 文件名
* @throws PHPExcel_Exception
* @throws PHPExcel_Reader_Exception
* @throws PHPExcel_Writer_Exception
*/
public function exportExcel($content = array(), $fileName = '') {
if (empty($content)) die('内容不能为空!');
if (empty($fileName)) die('文件名不能为空!');
// 设置页面等待时间
set_time_limit(0);
// 不限制内存
ini_set('memory_limit', -1);
// 获取当前文件地址
$dqml = dirname(__FILE__);
// 引入库
require "{$dqml}/libs/PHPExcel.php";
$objPHPExcel = new PHPExcel();
// 所有单元格居中
$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$i = 0;
// 外循环产生每一项 Sheet
foreach ($content as $key => $value) {
// 创建新的工作空间 sheet
if ($i > 0) $objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex($i);
// 给 Sheet 设置名字
$objPHPExcel->getActiveSheet()->setTitle($key);
// 内容
$j = 1;
// 外循环产生每一列
foreach ($value as $val) {
// 内循环产生每一行
foreach ($val as $k => $v) {
// 数字列转换为字母列 如:27变为AA
$objPHPExcel->getActiveSheet()->setCellValue(PHPExcel_Cell::stringFromColumnIndex($k) . $j, $v);
}
$j++;
}
$i++;
}
$filename = iconv('UTF-8', 'UTF-8', $fileName);
header('Pragma: public');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Content-Type: application/force-download');
header('Content-Type: application/vnd.ms-execl');
header('Content-Type: application/octet-stream');
header('Content-Type: application/download');
header("Content-Disposition: attachment; filename=$filename");
header('Content-Transfer-Encoding: binary');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
}
phpexcel 多个 sheet
最新推荐文章于 2021-11-01 16:01:53 发布