/** {@inheritdoc} */ public function create($path, array $firstRow, $sheetName = '') { $workbook = new Workbook(); $sheet = new Sheet($workbook); $table = new Table(); $table->setRow($firstRow); $sheet->addTable($table, new Coordinate(1, 1)); $workbook->addSheet($sheet); $writerFactory = new WriterFactory(); $writer = $writerFactory->createWriter(new Excel5($path)); $phpExcel = $writer->convert($workbook); $writer->write($phpExcel); }
/** * Convert Table to PHPExcel_Worksheet data * * @param PHPExcel_Worksheet $phpExcelWorksheet The current worksheet of the workbook * @param Table $table The Table to convert * * @return PHPExcel_Worksheet */ public function writeTable(PHPExcel_Worksheet $phpExcelWorksheet, Table $table) { $coordinate = $table->getCoordinate(); // Labels handling if (null !== ($label = $table->getLabel())) { $this->labelWorker->writeLabel($label, $phpExcelWorksheet, $coordinate); } // Table handling foreach ($table->getTable() as $row) { foreach ($row as $index => $cell) { $this->cellWorker->writeCell($cell, $phpExcelWorksheet, $coordinate); $coordinate->nextXAxis(); } $coordinate->resetXAxis()->nextYAxis(); } }