PhpOffice\PhpSpreadsheet not selecting values, and showing: Top Sheet! E102 -> Top Sheet! E15 -> Table7 cannot be located for structured reference

Question

I am using phpoffice\Phpspreadsheet and when I upload Excel it shows me error Top Sheet!E102 -> Top Sheet!E15 -> Table Table7 for Structured Reference cannot be located

My code is:

$file = $request->file;

$readerExtension = ucfirst($file->getClientOriginalExtension());
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($readerExtension);
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($request->file('file'));
$allSheetsArray = $spreadsheet->getSheetNames();

$import = $spreadsheet->getSheetByName('Top Sheet');
$cell = $import->getCell('E102');
$cellDataType = $cell->getDataType();
//$colValue = $import->getCell('E102')->getCalculatedValue();
dd($cell);

But when we dump data it shows the result in calculated value. Can anyone please help me with this issue? I have tried many methods to solve this problem but no luck.

Excel file

Answer 1

when we use

$colValue = $import->getCell('E102')->getOldCalculatedValue();

its working fine.