将两个或多个xls文件组合为工作表PHPExcel [英] Combine two or more xls files as worksheets PHPExcel

问题描述

我一直在到处寻找如何使用两个现有文件执行此操作，好像所有文档都在创建新文件一样.我想获取其中一个文件，并将第二个文件添加为新工作表，然后将其保存到服务器. 我一直在尝试无济于事:

I've been looking everywhere on how to do this with two existing files, looks like all documentation is on creating new files. I'd like to take one of the files and add the second file to it as a new worksheet then save it to the server. I've been trying with no avail like this:

$file="test.xls";
$file2="test2.xls";
$outputFile = "final.xls";
$phpExcel = new PHPExcel($file);
$phpExcel->getActiveSheet();
$phpExcel->setActiveSheetIndex(0);
$phpExcel->addSheet($file2);
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$outputFile");
header("Cache-Control: max-age=0");
$objWriter = PHPExcel_IOFactory::createWriter($phpExcel, "Excel5");
file_put_contents($outputFile, $objWriter);

任何帮助将不胜感激. PHP的新手.

Any help would be greatly appreciated. Very new to PHP.

推荐答案

这几天没人读过文档吗?文件夹/Documentation中有一个完整的文档，涉及将文件读取到PHPExcel对象(称为PHPExcel User Documentation - Reading Spreadsheet Files)，以及数十个示例(/Documentation/Examples/Reader文件夹是一个不错的地方)，它们都不使用new PHPExcel($file).保存时，任何示例或任何文档均未使用file_put_contents().

Doesn't anybody ever read documentation these days? There's a whole document in the folder called /Documentation about reading files to PHPExcel objects (it's called PHPExcel User Documentation - Reading Spreadsheet Files), together with dozens of examples (the /Documentation/Examples/Reader folder is a good place to look), and none of them use new PHPExcel($file). Nor do any of the examples or any of the documents say to use file_put_contents() when saving.

$file1="test.xls";
$file2="test2.xls";
$outputFile = "final.xls";

// Files are loaded to PHPExcel using the IOFactory load() method
$objPHPExcel1 = PHPExcel_IOFactory::load($file1);
$objPHPExcel2 = PHPExcel_IOFactory::load($file2);

// Copy worksheets from $objPHPExcel2 to $objPHPExcel1
foreach($objPHPExcel2->getAllSheets() as $sheet) {
    $objPHPExcel1->addExternalSheet($sheet)
}

// Save $objPHPExcel1 to browser as an .xls file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel1, "Excel5");
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$outputFile");
header("Cache-Control: max-age=0");
$objWriter->save('php://output');

这篇关于将两个或多个xls文件组合为工作表PHPExcel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！