Sheets, rows and cells are collections, this means after doing a ->get() you can use all default collection methods.

// E.g. group the results

Getting the first sheet or row

To get the first sheet or row, you can utilise ->first().


Note: depending on the config ‘force_sheets_collection’ it will return the first row or sheet.
Workbook and sheet title

It’s possible to retrieve the workbook and sheet title with ->getTitle().

// Get workbook title
 $workbookTitle = $reader->getTitle();

foreach($reader as $sheet)
 // get sheet title
 $sheetTitle = $sheet->getTitle();

Limiting the results
 Taking rows

When you only want to return the first x rows of a sheet, you can use ->take() or ->limit().

// You can either use ->take()

// Or ->limit()

Skipping rows

When you want to skip a certain amount of rows you can use ->skip() or ->limit(false, 10)

// Skip 10 results

// Skip 10 results with limit, but return all other rows
 $reader->limit(false, 10);

// Skip and take

// Limit with skip and take
 $reader->($skip, $take);

Result mutators

When you want to get an array instead of an object, you can use ->toArray().


When you want an object, you can alternativly (instead of get() or all()) use ->toObject().


Displaying results

You can dump the results to a readable output by using ->dump() or ->dd().

// Dump the results

// Dump results and die