gonzakpo/google-spreadsheet-bundle

Dreamlex Google spreadsheet bundle

维护者

详细信息

github.com/gonzaloalonsod/GoogleSpreadsheetBundle

源代码

安装: 13

依赖者: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

类型:symfony-bundle

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

Requires

Requires (Dev)

MIT d9dea570a1c53734cc938ab966cd09d54f1453a3

  • Oleksii Polivaniy <alexndlm.woop@gmail.com>
  • ellementA <ellementacc.woop@gmail.com>
  • Ivan Borysenko <ivan.binzz.borysenko.woop@gmail.com>

spreadsheetgooglegoogle sheet

This package is auto-updated.

Last update: 2024-09-10 12:11:14 UTC

README

Build Status

安装

访问https://developers.google.com/sheets/quickstart/php

按照第一步操作。

将你的client_secret.json文件放入/app/config/目录。

执行命令

app/console google-spreadsheet:set-credentials

用法

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

函数

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