excel导出

//获取表格数据
$(function () { var leng =$(“#table tbody tr”).length;
var lengs = $(“#table thead tr td”).length; var a = new Array(); var b = new Array(); for(var i=0; i<=leng-1; i++) { a[i] = new Array(); for(var j=0; j<=lengs-1; j++){ a[i][j] =$(“#table tbody”).find(“tr”).eq(i).find(“td”).eq(j).text();
if(j != 3){
a[i][j] = a[i][j].replace(/[ ]/g,”“);
}

            if(i == 0){
                b[j] = $("#table thead").find("tr").eq(i).find("td").eq(j).html();
            }

        }
    }
    var content = JSON.stringify(a);
    $("#content").val(content);
    var head = JSON.stringify(b);
    $("#head").val(head);
});

//后台实现导出

public function export(){
vendor(“Excel.PHPExcel”);
error_reporting(E_ALL);
ini_set(‘display_errors’, TRUE);
ini_set(‘display_startup_errors’, TRUE);
//创建对象
$excel = new PHPExcel(); //Excel表格式,这里简略写了8列$letter = array(‘A’,’B’,’C’,’D’,’E’,’F’,’F’,’G’,’H’,’I’,’J’,’K’,’L’,’M’,’N’,’O’);
//表头数组
$head =$_POST[‘head’];
$content =$_POST[‘content’];
$head = json_decode($head,true);
$content = json_decode($content,true);

    $tableheader = array($head[0],$head[1],$head[2],$head[3],$head[4],$head[5],$head[6],$head[7],$head[8],$head[9],$head[10],$head[11],$head[12],$head[13],$head[14],$head[15]);
    //填充表头信息
    for($i = 0;$i < count($tableheader);$i++) {
        $excel->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
    }

    //表格数组
    $data = $content;
    //填充表格信息
    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
    $date = date("YmdHis",time());
    $num = $date.rand(10000,99999);
    $fileName = $num.".xls";
    //创建Excel输入对象
    $write = new PHPExcel_Writer_Excel5($excel);
    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');
}