Collections

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

// E.g. group the results
 $reader->get()->groupBy('firstname');

Getting the first sheet or row

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

$reader->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()
 $reader->take(10);

// Or ->limit()
 $reader->limit(10);

Skipping rows

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

// Skip 10 results
 $reader->skip(10);

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

// Skip and take
 $reader->skip(10)->take(10);

// 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().

$reader->toArray();

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

$reader->toObject();

Displaying results

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

// Dump the results
 $reader->dump();

// Dump results and die
 $reader->dd();