PHPExcel 生成excel表



$excel = new \PHPExcel();
$excel->setActiveSheetIndex(0);
$letter = [];
$i = 'A';
for ($n=0; $n<26; $n++) {
    $letter[$n] = $i++;
}
$array = $_GET['post'];
$array = json_decode($array);//$array是要保存的数据
$name = $_GET['month'];
$data = [];
$tableheader = [];
$result = [];
foreach ($array as $k => $v){
    if($k =='data') {
        foreach($v as $kk=>$vv){
            $tableheader[] = $kk;
            foreach ($vv as $ke => $va) {
                $result[$ke][] = $va;
            }
        }
        foreach ($result as $key => $value) {
            array_unshift($value,$key);
            $data[] = $value;
        }
    }
}
array_unshift($tableheader, '时间');
for($i = 0;$i < count($tableheader);$i++) {
    $excel->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
}

for ($i = 2;$i <= count($data) + 1;$i++) {
    $j = 0;
    foreach ($data[$i - 2] as $key=>$value) {
        $excel->getActiveSheet()->setCellValue("$letter[$j]$i","$value");
        $j++;
    }
}
//创建Excel输入对象
$write = \PHPExcel_IOFactory::createWriter($excel, 'Excel5');
$filename = iconv("utf-8","gb2312","('$name')表名.xls");//避免出现乱码
//ob_end_clean();//清除缓冲区,避免乱码
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");$write->save('php://output');



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值