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

    $credentialFilePath = 'path/to/credentials.json';
  $tokenPath = 'path/to/token.json';
  $sheet1 = new \reandimo\GoogleSheetsApi\Helper($credentialFilePath, $tokenPath);

    putenv('credentialFilePath=path/to/credentials.json');
  putenv('tokenPath=path/to/token.json');
  $sheet1 = new \reandimo\GoogleSheetsApi\Helper();

  use reandimo\GoogleSheetsApi\Helper;

  putenv('credentialFilePath=path/to/credentials.json');
  putenv('tokenPath=path/to/token.json');

  $sheet1 = new Helper();
  $sheet1->setSpreadsheetId('somespreadsheetid');
  $sheet1->setWorksheetName('Sheet1');
  $sheet1->setSpreadsheetRange('A1:A20');

  $sheet2 = new Helper();
  $sheet2->setSpreadsheetId('somespreadsheetid');
  $sheet2->setWorksheetName('Sheet2');
  $sheet2->setSpreadsheetRange('B1:B20');

  $sheet1->setSpreadsheetRange('A1:A3');
  $insert = $sheet1->get();

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$sheet1->setWorksheetName('Sheet1');
$value = $sheet1->getSingleCellValue('B2');
echo "Value in B2: $value\n";

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$sheet1->setWorksheetName('Sheet1');
$sheet1->setSpreadsheetRange('A1:Z100');
$result = $sheet1->findCellByValue('searchValue');
if ($result) {
    echo "Found at cell: {$result['cell']} (row {$result['row']}, column {$result['column']})\n";
} else {
    echo 'Value not found.';
}

  $sheet1->setSpreadsheetRange('A1:A3');
  $insert = $sheet1->appendSingleRow([
    'some',
    'useful',
    'data',
  ]);

  if($insert >= 1){
    echo 'Insert done Hackerman.';
  }

  $sheet1 = new Helper();
  $sheet1->setSpreadsheetId('somespreadsheetid');
  $sheet1->setWorksheetName('Sheet1');
  $sheet1->setSpreadsheetRange('A1:A');
  $i = $sheet1->append([
      ['test4', 'this4', 'shit4'],
      ['test2', 'this2', 'shit2'],
      ['test3', 'this3', 'shit3'],
  ]);

  $sheet1 = new Helper();
  $sheet1->setSpreadsheetId('somespreadsheetid');
  $sheet1->setWorksheetName('Sheet1');
  $update = $sheet1->updateSingleCell('B5', "Hi i'm a test!");
  if($update->getUpdatedCells() >= 1){
    echo 'Cell updated.';
  }

  $sheet1 = new Helper();
  $sheet1->setSpreadsheetId('somesheetid');
  $sheet1->setWorksheetName('Sheet1');
  $sheet1->setSpreadsheetRange('A1:F5');
  $update = $sheet1->update([
      ['val1', 'test2', 'int3', 'four', '5', 'six6'],
      ['val1', 'test2', 'int3', 'four', '5', 'six6'],
      ['val1', 'test2', 'int3', 'four', '5', 'six6'],
      ['val1', 'test2', 'int3', 'four', '5', 'six6'],
      ['val1', 'test2', 'int3', 'four', '5', 'six6'],
  ]);

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

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$worksheets = $sheet1->getSpreadsheetWorksheets();
foreach ($worksheets as $ws) {
    echo "Sheet ID: {$ws['id']}, Title: {$ws['title']}\n";
}

  $sheet1 = new Helper();
  $sheet1->setSpreadsheetId('somesheetid');
  $sheet1->setWorksheetName('Sheet1'); // select the Worksheet you want to duplicate
  $newWorksheetName = 'New Duplicated Sheet'; // The name of the new sheet
  $sheet_id = $sheets->duplicateWorksheet($newWorksheetName);
  
  // Get updated cells
  if($sheet_id){
    echo 'The sheet was duplicated B)';
  }

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$deleted = $sheet1->deleteWorksheet('SheetToDelete');
if ($deleted) {
    echo 'Worksheet deleted.';
}

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$renamed = $sheet1->renameWorksheet('OldSheetName', 'NewSheetName');
if ($renamed) {
    echo 'Worksheet renamed.';
}

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$newSheetId = $sheet1->addWorksheet('NewSheet', 100, 10);
echo "New worksheet ID: $newSheetId\n";

  $sheet1 = new Helper();
  $sheet1->setSpreadsheetId('somespreadsheetid');
  $sheet1->setWorksheetName('Sheet1');
  $sheet1->setSpreadsheetRange('A1:Z10');
  $sheet1->colorRange([142, 68, 173]);

$sheet1 = new Helper();
$sheet1->setSpreadsheetId('somespreadsheetid');
$sheet1->setWorksheetName('Sheet1');
$sheet1->setSpreadsheetRange('A1:Z100');
$cleared = $sheet1->clearRange();
if ($cleared) {
    echo 'Range cleared.';
}

$sheet1 = new Helper();
$newSpreadsheetId = $sheet1->create('My New Spreadsheet');
echo "Created spreadsheet with ID: $newSpreadsheetId\n";

 
  Helper::getColumnLettersIndex('AZ'); // this will return 52

 
    $sheet1->appendSingleRow([
      'John Doe',
      '[email protected]',
      Google_Model::NULL_VALUE,
      'Sagittarius',
    ]);