Question

I m using PHPExcel library for many Excel manipulations, combined with PHP/MySQL. That helps me well.

But I can t figure how to split an Excel document sheet by sheet,where each sheet is created as a new Excel document.

同时,我还需要删除新印制的Excel文件原始文件中的空线(最后数字)。

What s the best way to do it ?

All your experiences are greatly appreciated.

最好。

Answer 1

I have found the way of what I wanted.

这里的解决办法(也许不是最佳办法,而是做得当)

$file = $_POST[ file ];
$filename = pathinfo($file, PATHINFO_FILENAME);

require_once  phpexcel/Classes/PHPExcel.php ;

$xls = new PHPExcel();
$xlsReader= new PHPExcel_Reader_Excel5();
$xlsTemplate = $xlsReader->load($file);

$sheet1 = $xlsTemplate->getSheetByName( Sheet1 );
$xls->addExternalSheet($sheet1,0);
$xls->removeSheetByIndex(1);
$xlsWriter = new PHPExcel_Writer_Excel5($xls);
$xlsWriter->save($filename."_Sheet1.xls");

$sheet2 = $xlsTemplate->getSheetByName( Sheet2 );
$xls->addExternalSheet($sheet2,0);
$xls->removeSheetByIndex(1);
$xlsWriter = new PHPExcel_Writer_Excel5($xls);
$xlsWriter->save($filename."_Sheet2.xls");

$sheet3 = $xlsTemplate->getSheetByName( Sheet3 );
$xls->addExternalSheet($sheet3,0);
$xls->removeSheetByIndex(1);
$xlsWriter = new PHPExcel_Writer_Excel5($xls);
$xlsWriter->save($filename."_Sheet3.xls");

$sheet4 = $xlsTemplate->getSheetByName( Sheet4 );
$xls->addExternalSheet($sheet4,0);
$xls->removeSheetByIndex(1);
$xlsWriter = new PHPExcel_Writer_Excel5($xls);
$xlsWriter->save($filename."_Sheet4.xls");

$sheet5 = $xlsTemplate->getSheetByName( Sheet5 );
$xls->addExternalSheet($sheet5,0);
$xls->removeSheetByIndex(1);
$xlsWriter = new PHPExcel_Writer_Excel5($xls);
$xlsWriter->save($filename."_Sheet5.xls");

$sheet6 = $xlsTemplate->getSheetByName( Sheet6 );
$xls->addExternalSheet($sheet6,0);
$xls->removeSheetByIndex(1);
$xlsWriter = new PHPExcel_Writer_Excel5($xls);
$xlsWriter->save($filename."_Sheet6.xls");

然后,我原来的Excel案卷,载有6张表格,现在按我的愿望分为6份Excel案。

As you can see, it was not so hard to release, but the documentation is so confusing...

Hope this can help.

友情链接