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
- php导出excel表格
- php导出excel表格
- php导出excel表格
- php导出excel表格
- php导出excel表格
- php导出EXCEL表格
- php导出EXCEL表格
- php导出excel表格
- php导出excel表格
- PHP导出 Excel表格数据
- php导入导出excel表格
- 【PHP】Excel表格导入导出
- 转 PHP导出Excel表格
- php导出excel表格文件
- PHP快速导出excel表格
- PHP导出excel表格,PHP导出Excel报表,PHP导出Xls表格!
- PHP导出Excel表格(最简易)
- php通过PHPExcel导出Excel表格
- maven mybatis generator自动生成代码
- Eclipse打war包
- 关于android 联系人数据库处理
- Flex 让组件动起来
- nodejs 设置proxy
- php导出excel表格
- Android Studio更新升级方法
- Swift开发IOS-UIButton
- window.open打开新窗口,防止浏览器阻止弹窗解决办法
- 转:Linux下/etc/shadow文件全面详解
- 影响布局的inline-block的空白符的问题
- oracle中merge into的用法
- Android:PopWindow
- StreamCQL 1.1版本RoadMap