PHP code example of lozemc / simple-google-sheets

    
        
<?php
require_once('vendor/autoload.php');

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

    

lozemc / simple-google-sheets example snippets

use Lozemc\GoogleSheet;

// Replace 'your_table_id' and 'path/to/your/credentials-config.json' with actual values

$table_id = 'your_table_id';
$credentials = 'path/to/your/credentials-config.json';

$table = new GoogleSheet($table_id, $credentials);

$table->set_sheet('YourSheetName');

// Get all rows
$rows = $table->get_rows();

print_r($rows);

// [
//    [ 'A1 value', 'B1 value', 'C1 value' ],
//    [ 'A2 value', 'B2 value', 'C2 value' ],
//    [ 'A3 value', 'B3 value', 'C3 value' ]
// ]


// Get rows from a specific range
$range = 'B2:C3';
$rows = $table->get_rows($range);

print_r($rows);

// [
//    [ 'B2 value', 'C2 value' ],
//    [ 'B3 value', 'C3 value' ]
// ]

$table->update([['A1 value', 'B1 value']]);

// 

$range = 'A4';
$table->update([['A4 value', 'B4 value']], $range);

// 

$table->update([
    ['A1 value', 'B1 value'],
    ['A2 value', 'B2 value', 'C3 value'],
    ['A3 value', 'B3 value', '', 'D4 value'],
]);

$table->append([['Value 1', 'Value 2']]);

//

$table->append([['Value 1', 'Value 2']], 'A10');

use Lozemc\GoogleSheet;

$table_id = '1gncMRlsonFj2YzYw79QnfVA4Go5UcYkmfgG1T7Vb5Q';
$credentials = __DIR__ . '/credentials-config.json'; 

$table = new GoogleSheet($table_id, $credentials);


// Set the sheet name if not provided during initialization
$table->set_sheet('Sheet1');


// Append new rows
$table->append([
    ['Lisa', 'Anderson'],
    ['Jane', 'Jones'],
]);


// Get all rows
$rows = $table->get_rows();

// Display the retrieved rows
print_r($rows);


// Get rows from a specific range in another sheet
$rows = $table->set_sheet('Sheet2')->get_rows('B10:C20');

print_r($rows);


// Update data in a specific range
$table->update([['New value']], 'B10');
$row = $table->get_rows('B10');

print_r($row);