php导出excel表格

最新推荐文章于 2022-11-17 15:26:54 发布

Yguang666

最新推荐文章于 2022-11-17 15:26:54 发布

阅读量394

点赞数

分类专栏： PHP 文章标签： php excel

本文链接：https://blog.csdn.net/SunGuangSir/article/details/50467790

版权

PHP 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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);