Downloads
Stars
Version
Originally forked from mach3/google-spreadsheet.php to work with Laravel 5.x (and correct namespacing)
Google Spreadsheet Client for Laravel/PHP.
composer require mitni/laravel-google-spreadsheet
This requires "google/apiclient" package, but that should be included by default.
use Mitni\Google\GoogleSpreadsheet;
$client = GoogleSpreadsheet::getClient("the/path/to/credential.json");
// Get the file by file ID
$file = $client->file("XXXxxxXXXXxxxXXXX");
// Get the sheet by title
$sheet = $file->sheet("Sheet1");
// Flush all rows in the sheet
var_dump($sheet->items);
// Array
$items = $sheet->select(array("id" => "1"));
// Closure
$items = $sheet->select(function($row){
return (int) $row["age"] < 30;
});
$sheet->insert(array(
"name" => "John",
"age" => 23,
"email" => "[email protected]"
));
$sheet->update(
8, // row number
"name", // field's name (or column number as Integer)
"Tom"
);
$items = $sheet->fetch(true)->items;
$client->config(array(
"cache" => true,
"cache_dir" => "cache",
"cache_expires" => 3600
));