search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

Working slow #1288

Open vovandanh opened 6 years ago

vovandanh commented 6 years ago

$file_template = "$this->templateFolder/consignment.xlsx"; // EXCEL FILE PREPARATION $this->mPHPExcel = PHPExcel_IOFactory::createReader('Excel2007'); $this->mPHPExcel = $this->mPHPExcel->load($file_template); // Load sheet ==> this code take up to 30sec to run

PHPExcel_ReferenceHelper insertNewBefore ==> It take >1sec to create new row

How can I make it faster?

gbutiri commented 6 years ago

right after you create the object, add this:

$objWriter->setPreCalculateFormulas(false);