CODEWITHSUNDEEP
phpformulaphpexcel
Mirko
Mirko

Reputation: 23

PHPExcel copy Worksheet without fx

I'm working on a PHPExcel based application and i need to copy a entire Worksheet from a Workbook to another, without copying the FX but only Values.

Some ideas?

Upvotes: 1

Views: 698

Answers (1)

Veve
Veve

Reputation: 6758

You can retrieve only the data :

$objReader = new PHPExcel_Reader_Excel2007();
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load("myworkbook.xlsx");

Or you can get the calculated values of cells :

$objPHPExcel->getActiveSheet()->getCell("A2")->getCalculatedValue();

Upvotes: 2

Related Questions