Laravel Excel: how to get value of a cell?

php laravel phpexcel laravel-excel
qwaz picture qwaz · Jun 28, 2016 · Viewed 11.8k times · Source

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.

Answer

Demian picture Demian · Jun 28, 2016 
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.

Related questions

Laravel Excel/PHP Excel: Import, modify, download

I'm struggeling with Laravel-Excel (Laravel Package of PHPExcel). I'm not able to modify a file. My file has one workbook (called template). I want to load the document, modify it and let the user download it: Excel::selectSheets('template') -&…

Read More
PHPExcel how to set collapse and expands for groups of row?

Suppose I want to set collapse and expand for row 2 up to 4 as one group, and 8 up to 12 the second group. It means when user want to click on expand + icon of group 1, rows from 2 up to 4 should be visible, …

Read More
How Do I Get the Query Builder to Output Its Raw SQL Query as a String?

Given the following code: DB::table('users')->get(); I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users. How do I do …

Read More