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.

Share:
13,280
qwaz
Author by

qwaz

Updated on June 04, 2022

Comments

  • qwaz
    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.