CODEWITHSUNDEEP
phpphpexcel
hoangvu68
hoangvu68

Reputation: 865

Load cache data from excel with phpexcel

I am using phpexcel to open excel file. I am having a problem with it.

This is my excel 's file

enter image description here

We can see in it: cell H4 have function VLOOKUP, but it have link to another sheet. But at now link to C:... is wrong, and I want to get number 37512 (that is cache data because we can't recalculate that function now.). I tried to use with getCalculatedValue, but that function recalculate. How can I can get it?

Upvotes: 1

Views: 159

Answers (2)

Martin
Martin

Reputation: 1

Old post I know - the OP is asking to read Excel's cached data when a workbook link exists to a non-accessible file. PHPExcel attempts and to calculate the formula and fails.

Answer is to use the method: getOldCalculatedValue(). Example:

$objWorksheet->getCell('A1')->getOldCalculatedValue()

Upvotes: 0

Michel Vu
Michel Vu

Reputation: 26

This is answer automatic be generate. You can't load cache.

Upvotes: 1

Related Questions