php导出excel表格

来源:互联网 发布:有关人工智能电影 编辑:程序博客网 时间:2024/04/24 05:24
require_once ROOT_PATH . '/includes/PHPExcel/PHPExcel.php';require_once ROOT_PATH . '/includes/PHPExcel/PHPExcel/IOFactory.php';require_once ROOT_PATH . '/includes/PHPExcel/PHPExcel/Writer/Excel5.php';$resultPHPExcel = new PHPExcel ();ob_end_clean ();//标题$resultPHPExcel->getActiveSheet ()->setCellValue ( 'A1', '单号' );$resultPHPExcel->getActiveSheet ()->setCellValue ( 'B1', '名称' );//内容foreach ( $orders as $k => $v ) {  $k = $k +2;  $resultPHPExcel->getActiveSheet ()->setCellValue ( 'A' . $k, $v ['seller_name'] );  $resultPHPExcel->getActiveSheet ()->setCellValue ( 'B' . $k, $v ['order_sn'] );}// 设置导出文件名$outputFileName = gmtime().'total.xls';$xlsWriter = new PHPExcel_Writer_Excel5 ( $resultPHPExcel );header ( "Content-Type: application/force-download" );header ( "Content-Type: application/octet-stream" );header ( "Content-Type: application/download" );header ( 'Content-Disposition:inline;filename="' . $outputFileName . '"' );ob_end_clean ();$xlsWriter->save ( "php://output" );///////////导出到指定文件夹//创建文件夹$dayes = date('Ymd',time());$path = "excel/".$dayes;if(!is_dir($path)){    $path_r = mkdir($path); }$outputFileName ='路径'.'/'.gmtime().'total.xls';$xlsWriter = new PHPExcel_Writer_Excel5 ( $resultPHPExcel );ob_end_clean ();$xlsWriter->save($outputFileName);
0 0
原创粉丝点击