asimlqt / php-google-spreadsheet-client

A PHP library for accessing and manipulating Google Spreadsheets
Other
543 stars 154 forks source link

Want To Retrive Sheet By Sheet Id #189

Open arpitmca1992 opened 6 years ago

arpitmca1992 commented 6 years ago

Having Below Code For Writing A Newly Created Sheet. Please Guide me for Writing Data Into Sheet. And Getting Error After $spreadsheet = $spreadsheetService->getSpreadsheetById($response->spreadsheetId). Please Suggest Me. Thank You

require_once __DIR__ . '/vendor/autoload.php';
$client = new Google_Client();
$client->setAuthConfig( __DIR__ .'/client_secret.json');
$client->setScopes(['https://www.googleapis.com/auth/spreadsheets','https://www.googleapis.com/auth/drive']);
   $client->authenticate($_GET['code']);
   $access_token = $client->getAccessToken();
   $_SESSION['Token']  = $access_token;
   $service = new Google_Service_Sheets($client);
$requestBody = new Google_Service_Sheets_Spreadsheet($access_token['access_token']);
$response = $service->spreadsheets->create($requestBody);
use Google\Spreadsheet\DefaultServiceRequest;
use Google\Spreadsheet\ServiceRequestFactory;
$serviceRequest = new DefaultServiceRequest($access_token['access_token']);
ServiceRequestFactory::setInstance($serviceRequest);
$serviceRequest->setSslVerifyPeer(false);
$spreadsheetService = new Google\Spreadsheet\SpreadsheetService();
$spreadsheetFeed = $spreadsheetService->getSpreadsheetFeed();
 _$spreadsheet = $spreadsheetService->getSpreadsheetById($response->spreadsheetId);_
    $spreadsheet->addWorksheet('AOG', 5, 5);
    $worksheet = $worksheetFeed->getByTitle('AOG');
    $cellFeed = $worksheet->getCellFeed();
   $cellFeed->editCell(1, 1, 'Hourly report ');
    $cellFeed->editCell(2, 1, 'Consultant');
    $cellFeed->editCell(3, 1, 'Customer');