导出excel

function download(){    $db =& db();    $conditions = $this->_get_query_conditions(array(        array(            'field' => '',            'equal' => '',            'name' => '',        ),          ));    $sort = "";    $order = "";    $sql = "select * from gov_order o     WHERE 1=1 AND o.finished_time>0 $conditions ORDER BY $sort $order ";    $repasts = $db->getAll($sql);    foreach ($repasts as $key => $v) {        $arr['0'] = $v['order_sn'];        $arr['1'] = $v['menu_type'];        $arr['2'] = $v['unit_name'];        $arr['3'] = $v['category'];        $arr['4'] = $v['job_num'];        $arr['5'] = $v['card_sn'];        $arr['6'] = $v['card_holder'];        $arr['7'] = $v['phone_mob'];        $arr['8'] = date('Y-m-d H:i:s', $v['add_time']);        $arr['9'] = 1;        $datas[] = $arr;    }    for ($i = 0; $i < 1; $i++) {        $datas[0]['10'] = $count;    }    $data = $datas;    include_once(ROOT_PATH . '/excel/toexcel/PHPExcel/IOFactory.php');    include_once(ROOT_PATH . '/excel/toexcel/PHPExcel/Reader/Excel5.php');    include_once(ROOT_PATH . '/excel/toexcel/PHPExcel.php');    $filename = local_date('YmdHis' . gmtime(), '');    $filename .= "就餐人数报表.xls";    header("Content-type: application/vnd.ms-excel; charset=utf-8");    header("Content-Disposition: attachment; filename=$filename.xls");    $excel = new PHPExcel();    //Excel表格式,这里简略写了8列    $letter = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O' . 'P');    //表头数组    $tableheader = array('订单号', '早/午/晚', '单位', '类别', '工号', '卡号', '持卡人', '手机', '订单时间', '就餐人数', '总就餐人数',);    //填充表头信息    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()->setTitle('Simple');            //$excel->getActiveSheet()->getStyle('A'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);            $excel->getActiveSheet()->setCellValue("$letter[$j]$i", " " . "$value");            $j++;        }    }    //创建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');}