I wrote a code that only generates one row of cell values returned from my database.
I want for them to generate multiple rows starting from row 16th in my excel file.. It only sets one row of selected cells on row 16 when I want to continue generating all returned results like 16th, 17th, 18th row and so on..
How do I fix this?
This is my code:
phpExcelObject = $this->get('phpexcel')->createPHPExcelObject($filePath);
$copyFrom= "17";
$activeSheet = $phpExcelObject->getActiveSheet();
$rows = $this->get('app')->getData();
$row = 16;
if($rows) {
foreach ($rows as $row) {
$activeSheet->insertNewRowBefore($copyFrom, 1);
$activeSheet->duplicateStyle($activeSheet->getStyle('A16'.($copyFrom+1)), 'A16'.$copyFrom);
$lastColumn = $phpExcelObject->getActiveSheet()->getHighestColumn();
$rangeFrom = 'A'.($copyFrom+1).':'.$lastColumn.($copyFrom+1);
$activeSheet->fromArray($activeSheet->rangeToArray($rangeFrom), null, 'A'.$copyFrom);
$phpExcelObject->setActiveSheetIndex(0)
->setCellValue('G7', $row[0])
->setCellValue('H10', $row[1])
->setCellValue('G8', $row[2])
->setCellValue('A17', $row[3]);
$row++;
}
}
$writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel2007');
$response = $this->get('phpexcel')->createStreamedResponse($writer);
$dispositionHeader = $response->headers->makeDisposition(
ResponseHeaderBag::DISPOSITION_ATTACHMENT,
'the-file.xlsx'
);
$response->headers->set('Content-Type', 'text/vnd.ms-excel; charset=utf-8');
$response->headers->set('Cache-Control', 'maxage=1');
$response->headers->set('Content-Disposition', $dispositionHeader);
return $response;
}
I have tried other suggestions but it doesn't work for me.