I want to merge worksheets from multiple excel sheets into 1 worksheet in a new excel file.
I referred to the discussion
I did not understand what MarkBaker meant by using toArray(). I mean how do I use it.
My Current Code is:
$objPHPExcel1 = PHPExcel_IOFactory::load($file1);
$outputFile = "output.xlsx";
$objPHPExcel2 = PHPExcel_IOFactory::load($file2);
$sheet = $objPHPExcel2->getActiveSheet();
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel1);
With this I am able to get different worksheets of various files into a new workbook but as different sheets.
What should I do to get it all onto the same sheet like vitman said?