reverse/g-sheets

PHP client for Google Sheets.
This library provides a set of class and methods to work with Google Api Client for PHP google/apiclient.

Requirements

• php >= 5.6

Installation

composer require reverse/g-sheets:"dev-master"

Using GSheets

To work with Google Sheets have to init Client and Spreadsheets classes.

$googleClient = new \Google_Client($config);
$client = new Client($googleClient);
spreadsheets = new Spreadsheets($client, 'sheetid'); 

Operations

Append

$value = new Value('a', 'b', 'c');
$spreadsheets->append($value, 'Sheet1');

Update

$value = new Value('a', 'b', 'c');
$spreadsheets->update($value, 'Sheet1');

Clear

$spreadsheets->clear('Sheet1!1:2');

Get

// This get return Sheet1's first column
$spreadsheets->get('Sheet1!1:1');

Delete

// This call delete first row of sheets specified
// sheetId is gid not sheet's name
$delete->execute(Delete::DIMENSION_ROWS, '12675hakas', 0, 1);