gonzakpo/google-spreadsheet-bundle

Dreamlex Google spreadsheet bundle

dev-master / 1.x-dev 2016-11-30 17:57 UTC

Requires

• google/apiclient: ~2.0
• symfony/symfony: ~2.8 || ~3.1

Requires (Dev)

• phpunit/phpunit: 5.4.*

MIT

• Oleksii Polivaniy
• ellementA
• Ivan Borysenko

• spreadsheet
• google
• google sheet

README

Installing

Go to https://developers.google.com/sheets/quickstart/php

Follow the first step.

Put your client_secret.json in to /app/config/

Execute command

app/console google-spreadsheet:set-credentials

Usage

$googleSpreadsheet = $this->container->get('dreamlex_google_spreadsheet');
$tableData = $googleSpreadsheet->getTable('1_ApzX0ZEpN79EL4v_rSpU1PxpgYYOCDKfet7_le0suM', 'IP!A2:B');

Functions

getTable($spreadsheetId, $range = null)
createTable($title)
addPermissionTable($spreadsheetId, $email, $type = 'user', $role = 'writer', $sendNotificationEmail = false)
addRowTable($spreadsheetId, $range, $values)
updateRowTable($spreadsheetId, $range, $values)