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

导出数据导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;