PHP code example of reandimo / google-sheets-helper

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

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

    

reandimo / google-sheets-helper example snippets

use reandimo\GoogleSheetsApi\Helper;

// Set credentials via environment (recommended)
putenv('credentialFilePath=path/to/credentials.json');
putenv('tokenPath=path/to/token.json');

// Create instance and configure
$sheet = new Helper();
$sheet->setSpreadsheetId('your-spreadsheet-id');
$sheet->setWorksheetName('Sheet1');

// Read data
$sheet->setSpreadsheetRange('A1:D10');
$data = $sheet->get();

// Write data
$sheet->appendSingleRow(['Name', 'Email', 'Role']);

// Update a cell
$sheet->updateSingleCell('B2', '[email protected]');

> $sheet = new Helper('path/to/credentials.json', 'path/to/token.json');
> 

$sheet->setSpreadsheetRange('A1:C10');
$data = $sheet->get();

$value = $sheet->getSingleCellValue('B2');
echo "Value: $value\n";

$sheet->setSpreadsheetRange('A1:Z100');
$result = $sheet->findCellByValue('searchValue');

if ($result) {
    echo "Found at {$result['cell']} (row {$result['row']}, col {$result['column']})\n";
}

$sheet->setSpreadsheetRange('A1:C1');
$inserted = $sheet->appendSingleRow(['John', '[email protected]', 'Admin']);

if ($inserted >= 1) {
    echo 'Row inserted.';
}

$sheet->setSpreadsheetRange('A1:C1');
$sheet->append([
    ['Alice', '[email protected]', 'Editor'],
    ['Bob',   '[email protected]',   'Viewer'],
    ['Carol', '[email protected]', 'Admin'],
]);

$update = $sheet->updateSingleCell('B5', 'Updated value');

if ($update->getUpdatedCells() >= 1) {
    echo 'Cell updated.';
}

$sheet->setSpreadsheetRange('A1:C3');
$update = $sheet->update([
    ['val1', 'val2', 'val3'],
    ['val4', 'val5', 'val6'],
    ['val7', 'val8', 'val9'],
]);

if ($update->getUpdatedCells() >= 1) {
    echo 'Range updated.';
}

$worksheets = $sheet->getSpreadsheetWorksheets();

foreach ($worksheets as $ws) {
    echo "ID: {$ws['id']}, Title: {$ws['title']}\n";
}

$newSheetId = $sheet->addWorksheet('NewSheet', 100, 10);
echo "Created worksheet ID: $newSheetId\n";

$sheet->setWorksheetName('Sheet1');
$sheetId = $sheet->duplicateWorksheet('Sheet1 - Copy');

if ($sheetId) {
    echo 'Worksheet duplicated.';
}

$sheet->renameWorksheet('OldName', 'NewName');

$deleted = $sheet->deleteWorksheet('SheetToDelete');

if ($deleted) {
    echo 'Worksheet deleted.';
}

$sheet->setSpreadsheetRange('A1:Z10');
$sheet->colorRange([142, 68, 173]); // Purple background

$sheet->setSpreadsheetRange('A1:Z100');
$sheet->clearRange();

$newId = $sheet->create('My New Spreadsheet');
echo "Spreadsheet ID: $newId\n";

Helper::getColumnLettersIndex('AZ'); // Returns 52

> $sheet->appendSingleRow([
>     'John Doe',
>     '[email protected]',
>     Google_Model::NULL_VALUE, // skip this cell
>     'Sagittarius',
> ]);
> 

> $orders = new Helper();
> $orders->setSpreadsheetId('spreadsheet-a');
> $orders->setWorksheetName('Orders');
>
> $inventory = new Helper();
> $inventory->setSpreadsheetId('spreadsheet-b');
> $inventory->setWorksheetName('Stock');
> 

bash
php ./vendor/reandimo/google-sheets-helper/firstauth