Is there a way to tell PHPExcel to just write rows supplied from an array, without doing any calculation / apply styling / any other thing it does while writing OR when using fromArray ?
Need this for performance.
$inputFileName = 'client_files/sample.xlsx'; $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); $objPHPExcel->getSheet(0)->setCellValue('D2', '@' . $user . ' followers'); $objPHPExcel->getSheet(0)->fromArray( $followersData, NULL, 'A5' ); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->setPreCalculateFormulas(false); $objWriter->save(FINAL_FOLDER . '/' . $line . '.xlsx');
Memory consumption isn't an issue. But the above is just taking too much time (2 minutes with 2700 rows)
the ->save() call takes 93 seconds. The ->fromArray() takes 53 seconds
Also is there any other wayy faster Excel library that allows loading existing xlsx and then writing to it ?