Wallogit.com
2017 © Pedro Peláez
PHP library to CRUDify Google Spreadsheets like sheetsu.com
, (*1)
PHP library to CRUDify Google Spreadsheets like sheetsu.com., (*2)
$ composer require ttskch/pheetsu:@dev
If you have a Google Spreadsheet like this,, (*3)
, (*4)
You can CRUD the spreadsheet via pheetsu so easily like below., (*5)
$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::createOAuth(
'google_oauth2_client_id',
'google_oauth2_client_secret',
'google_oauth2_redirect_uri',
'google_oauth2_javascript_origin',
'1JQkfd3dlyxFRuxIwGPnBnrxS-l-bLVw_BbHskxT9Nj4', // spreadsheet id
'demo' // sheet name
);
// authenticate and be authorized with Google OAuth2.
$pheetsu->authenticate();
$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::createServiceAccount(
'/path/to/your/service-account-credentials.json',
'1JQkfd3dlyxFRuxIwGPnBnrxS-l-bLVw_BbHskxT9Nj4', // spreadsheet id
'demo' // sheet name
);
$rows = $pheetsu->read(); var_dump($rows); // array (size=3) // 0 => // array (size=3) // 'id' => string '1' (length=1) // 'name' => string 'Alice' (length=5) // 'age' => string '20' (length=2) // 1 => // array (size=3) // 'id' => string '2' (length=1) // 'name' => string 'Bob' (length=3) // 'age' => string '25' (length=2) // 2 => // array (size=3) // 'id' => string '3' (length=1) // 'name' => string 'Charlie' (length=7) // 'age' => string '18' (length=2)
See also demo., (*6)
PHP library to CRUDify Google Spreadsheets like sheetsu.com
MIT
api crud spreadsheets sheetsu