Richard Korts

asked on

# Need value of formula in PHP Office / PHP Spreadsheet

Using PHP Office / PHP spreadsheet.

Some cells in the sheet being read have formulas in them.

How can I get the value produced by the formula?

When I do this:

$net_each = $prl->getCellByColumnAndRow(10, $row)->getValue();

I get the formula. How can I get "Value of" the formula?

Thanks.

Some cells in the sheet being read have formulas in them.

How can I get the value produced by the formula?

When I do this:

$net_each = $prl->getCellByColumnAndRo

I get the formula. How can I get "Value of" the formula?

Thanks.

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Chris, please if you can look at this:

https://www.experts-exchange.com/questions/29179738/Please-show-example-of-CREATE-POPULATE-new-spreadsheet.html

I am stunned there are no examples of this.

Thank you.

Richard

https://www.experts-exchange.com/questions/29179738/Please-show-example-of-CREATE-POPULATE-new-spreadsheet.html

I am stunned there are no examples of this.

Thank you.

Richard

ASKER