Laravel Excel: how to get value of a cell?
13,280
public function get()
{
$excelFile ...
return Excel::load($excelFile, function($doc) {
$sheet = $doc->getSheetByName('data'); // sheet with name data, but you can also use sheet indexes.
$sheet->getCell('A1');
$sheet->getCellByColumnAndRow(0,0);
});
}
You're right, the documentation to read some cells is unclear. Hope this will help you.
Author by
qwaz
Updated on June 04, 2022Comments
-
qwaz almost 2 years
I've loaded
.xls
file with Laravel Excel:Excel::load('public/files/20160621.xls', function($reader) { // read a cell value });
How do I read values of cells of the loaded excel file? Documentation seems to be unclear on that part.