PHP code example of reverse / g-sheets

1. Go to this page and download the library: Download reverse/g-sheets library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

reverse / g-sheets example snippets


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


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


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


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


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


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