eliasrosa/google-sheets

API for Google Sheets

Maintainers

Details

github.com/eliasrosa/google-sheets

Homepage

Source

Issues

Installs: 80

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 3

Forks: 0

Open Issues: 0

dev-master 2017-03-15 22:22 UTC

Requires

Requires (Dev)

MIT 6c34e4910e848039cea6a40c405b7fcf9ac7fcf2

apigoogleeliasrosasheetsgoogle sheets api

This package is not auto-updated.

Last update: 2024-04-27 18:04:30 UTC

README

API para acessar planilhas do Google Drive

Download

php composer.phar require eliasrosa/google-sheets

Como usar

// Exemplo
// https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit

use ER\GoogleClient;
use ER\GoogleSheet;

$client = new GoogleClient();
$client->setApplicationName('Nome da Aplicação');
$client->setTokenPath(__DIR__ . '/token.json');
$client->setClientSecretPath(__DIR__ . '/client_secret.json');
$client->setToken('TOKEN de Acesso');

//
$client = $client->getClient();
$sheet = new GoogleSheet($client);

$values = $sheet
    ->spreadsheets_values
    ->get('1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms', 'Class Data!A2:E')
    ->getValues();

if(count($values)) {
    foreach ($values as $row) {
        printf( join($row, '|'). "\n");
    }
}