Business Owner / Chief Developer

Richard Korts

<div>
Thanks, I actually got it from the docs 5 minutes after I posted that. Just forgot to close the question.
</div>


<div>
Chris, please if you can look at this:<br />
<br />
<a href="https://www.experts-exchange.com/questions/29179738/Please-show-example-of-CREATE-POPULATE-new-spreadsheet.html" rel="ugc">https://www.experts-exchange.com/questions/29179738/Please-show-example-of-CREATE-POPULATE-new-spreadsheet.html</a><br />
<br />
I am stunned there are no examples of this.<br />
<br />
Thank you.<br />
<br />
Richard
</div>


<div>
<div class="content wysiwyg-content">
Using PHP Office / PHP spreadsheet.<br />
<br />
Some cells in the sheet being read have formulas in them.<br />
<br />
How can I get the value produced by the formula?<br />
<br />
When I do this:<br />
<br />
$net_each = $prl-&gt;getCellByColumnAndRo<wbr />w(10, $row)-&gt;getValue();<br />
<br />
I get the formula. How can I get &quot;Value of&quot; the formula?<br />
<br />
Thanks.
</div>
</div>


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.

Thanks, I actually got it from the docs 5 minutes after I posted that. Just forgot to close the question.

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

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-&gt;getCellByColumnAndRow(10, $row)-&gt;getValue();

I get the formula. How can I get &quot;Value of&quot; the formula?

Thanks.

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.