gonzakpo/google-spreadsheet-bundle

Dreamlex Google spreadsheet bundle

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

This package is auto-updated.

Last update: 2022-06-10 07:11:48 UTC


README

Build Status

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)