phpexcel 导出数据库

1,088次阅读

一个很初级的实例，也是常用的方法；

case "daochu":
        date_default_timezone_set('Asia/Shanghai');
        require "include/PHPExcel.php";
        $dir=dirname(__FILE__);
        $objPHPExcel=new PHPExcel();
        $objSheet=$objPHPExcel->getActiveSheet();
        $objSheet->setTitle("账单");
//        $objSheet->setCellValue("A1","张三")->setCellValue("B1","分数");
        $sql = "SELECT `id`, `mingcheng`, `jine`, `time`, `jingban`, `didian`, `fukuan`, `sfxx` FROM `jizhang` LIMIT 0, 30";
        $result=$conn->query($sql);
        $objSheet->setCellValue("A1","编号")->setCellValue("B1","名称")->setCellValue("C1","金额")->setCellValue("D1","时间")->setCellValue("E1","经办人")->setCellValue("F1","地点")->setCellValue("G1","是否付款")->setCellValue("H1","是否学校支出");
        $i=2;
        while (list($id,$mingcheng,$jine,$time,$jingban,$didian,$fukuan,$sfxx)=$result->fetch_row()){$objSheet->setCellValue("A$i","$id")->setCellValue("B$i","$mingcheng")->setCellValue("C$i","$jine")->setCellValue("D$i","$time")->setCellValue("E$i","$jingban")->setCellValue("F$i","$didian")->setCellValue("G$i","$fukuan")->setCellValue("H1","$sfxx");
            $i++;
            }
        $objwriter=PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");
        brower_export('Excel2007','zhangdan.xlsx');
        $objwriter->save("php://output");
//        $objwriter->save($dir."/zhangdan.xlsx");

        break;

function brower_export($type,$filename){if ($type=="Excel5"){header('Content-Type: application/vnd.ms-excel');
    }else{header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    }

    header('Content-Disposition: attachment;filename="'.$filename.'"');
    header('Cache-Control: max-age=0');
}

正文完