PHPExcel 导入数据导多个工作区(sheet)

最新推荐文章于 2024-07-29 15:06:10 发布

JoLonn

最新推荐文章于 2024-07-29 15:06:10 发布

阅读量3.4k

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/qq_16149125/article/details/78489418

版权

PHP 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

导出数据导EXCEL中有时需要分开保存到多个工作区内，实现代码如下：

PS：貌似只能导出总共几万条数据，并不能每个工作区都几万条。

include_once 'include/tools/arrayfunction.php';
require_once 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/IOFactory.php';
require_once 'Classes/PHPExcel/Reader/Excel5.php';


$colmuns = array('coloumns1','coloumns2','coloumns3');
$profixs =  array('A','B','C','D','E','F','G','H','I','J','L','K','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');

$objPHPExcel     = new PHPExcel();
$objPHPExcel->getProperties()
    ->setCreator("Hohan")
    ->setLastModifiedBy("Hohan")
    ->setTitle("Office 2003 XLSX Test Document")
    ->setSubject("Office 2003 XLSX Test Document")
    ->setDescription("Test document for Office 2003 XLSX, generated using PHP classes.")
    ->setKeywords("office 2003 openxml php")
    ->setCategory("Test result file");
foreach($profixs as $key => $value){

    // 9-01号之前开发 最后出库日期是9-01之前或未出库  库存大于0
    $sql = " ";
    $sql = $dbcon->query($sql);
    $sql = $dbcon->getResultArray($sql);
	
	
    $objPHPExcel->createSheet();
    $objActSheet = $objPHPExcel->setActiveSheetIndex($key);


    $objPHPExcel->getActiveSheet()->setCellValue('A1','coloumns1');
    $objPHPExcel->getActiveSheet()->setCellValue('B1','coloumns2');
    $objPHPExcel->getActiveSheet()->setCellValue('C1','coloumns13');


    $i = 1;
    foreach($sql as $key2 => $val){

        $objPHPExcel->getActiveSheet()->setCellValue('A'.($i+1),$val['coloumns1']);
        $objPHPExcel->getActiveSheet()->setCellValue('B'.($i+1),$val['coloumns2']);
        $objPHPExcel->getActiveSheet()->setCellValue('C'.($i+1),$val['coloumns3']);

        $i ++;
    }

    $objPHPExcel->getActiveSheet()->setTitle($value);

}

$obwrite = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

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=mulit_sheet.xls");
header('Content-Transfer-Encoding:binary');
$obwrite->save('php://output');
exit;