Mixing
update values on specific google spreadsheet with google-api-php-client (version 2- without composer)
0
For below code I am using https://github.com/googleapis/google-api-php-client library (Client Requirement - this library must be used without composer).
So now come to the requirement - my client want to update data rows from mysql to google spreadsheed (which will be any sheet eg. sheet 1 or sheet 2).
I am facing issue in posting multiple rows and cells as well.
db.php code
<?php
$servername = "localhost";
$username = "newuser";
$password = "password";
$db = "google_sheet";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM table2";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$rowData = mysqli_fetch_all($result);
} else {
echo "No records in table";
}
/* $rowData contains below array
array (size=4)
0 =>
array (size=3)
0 => string 'XXX' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
1 =>
array (size=3)
0 => string 'YYY' (length=3)
1 => string 'QA' (length=2)
2 => string 'IT' (length=2)
2 =>
array (size=3)
0 => string 'ZZZ' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
3 =>
array (size=3)
0 => string 'AAA' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2) */
Note- Here is my complete code except credentials and spreadsheet id (Changed it for security reasons).
<?php
//echo phpinfo();
ini_set('display_errors', 1);
error_reporting(E_ALL);
session_start();
include_once "examples/templates/base.php";
require_once 'autoload.php';
include 'db.php';
$client_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Client ID
$service_account_name = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Email Address
$key_file_location = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx';
echo pageHeader("Service Account Access");
if (strpos($client_id, "googleusercontent") == false || !strlen($service_account_name) || !strlen($key_file_location)) {
echo missingServiceAccountDetailsWarning();
exit;
}
$client = new Google_Client();
$client->setApplicationName("Sheets API Testing");
$service = new Google_Service_Drive($client);
if (isset($_SESSION['service_token'])) {
$client->setAccessToken($_SESSION['service_token']);
}
$key = file_get_contents($key_file_location);
$cred = new Google_Auth_AssertionCredentials(
$service_account_name, array('https://www.googleapis.com/auth/drive', 'https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive.apps.readonly'), $key
);
$client->setAssertionCredentials($cred);
if ($client->getAuth()->isAccessTokenExpired()) {
$client->getAuth()->refreshTokenWithAssertion($cred);
}
$_SESSION['service_token'] = $client->getAccessToken();
// Get access token for spreadsheets API calls
$resultArray = json_decode($_SESSION['service_token']);
$accessToken = $resultArray->access_token;
// The file ID was copied from a URL while editing the sheet in Chrome
$fileId = '1JfnVnz8TxxxxxxxxxxxxxxxxxxxxxxxxxxA'; //change for security reasons
function updateFile($service, $fileId, $newTitle, $newDescription, $newMimeType = null, $rowData, $newRevision, $currentRow) {
try {
// First retrieve the file from the API.
$file = $service->files->get($fileId);
// File's new metadata.
$file->setTitle($newTitle);
$file->setDescription($newDescription);
$file->setMimeType($newMimeType);
// File's new content.
// foreach ($rowData as $row) {
$additionalParams = array(
'newRevision' => $newRevision,
'data' => $rowData,
'mimeType' => $newMimeType,
'uploadType' => 'multipart',
'convert' => true,
);
// Send the request to the API.
$updatedFile = $service->files->update($fileId, $file, $additionalParams);
return $updatedFile;
// }
} catch (Exception $e) {
print "An error occurred: " . $e->getMessage();
}
}
$currentRow = 1;
foreach ($rowData as $row) {
$responseData = updateFile($service, $fileId, 'Update G Excel', 'Update GG Excel Desc', 'text/csv', $row, true, $currentRow);
var_dump($responseData);
$currentRow++;
die;
}
Above code is working only for A1 cell of sheet 1. I need to update multiple cells and rows. But I am not getting any helpful doc. Any help will be highly appreciated.
Current Output is - only 1 cell in first row of first sheet is updated.
Expected Output is - something like this
Name Role Department
XXX Developer IT
YYY QA IT
ZZZ Developer IT
AAA Developer IT
php mysql
google-api-php-client worksheet asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
add a comment |
0
For below code I am using https://github.com/googleapis/google-api-php-client library (Client Requirement - this library must be used without composer).
So now come to the requirement - my client want to update data rows from mysql to google spreadsheed (which will be any sheet eg. sheet 1 or sheet 2).
I am facing issue in posting multiple rows and cells as well.
db.php code
<?php
$servername = "localhost";
$username = "newuser";
$password = "password";
$db = "google_sheet";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM table2";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$rowData = mysqli_fetch_all($result);
} else {
echo "No records in table";
}
/* $rowData contains below array
array (size=4)
0 =>
array (size=3)
0 => string 'XXX' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
1 =>
array (size=3)
0 => string 'YYY' (length=3)
1 => string 'QA' (length=2)
2 => string 'IT' (length=2)
2 =>
array (size=3)
0 => string 'ZZZ' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
3 =>
array (size=3)
0 => string 'AAA' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2) */
Note- Here is my complete code except credentials and spreadsheet id (Changed it for security reasons).
<?php
//echo phpinfo();
ini_set('display_errors', 1);
error_reporting(E_ALL);
session_start();
include_once "examples/templates/base.php";
require_once 'autoload.php';
include 'db.php';
$client_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Client ID
$service_account_name = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Email Address
$key_file_location = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx';
echo pageHeader("Service Account Access");
if (strpos($client_id, "googleusercontent") == false || !strlen($service_account_name) || !strlen($key_file_location)) {
echo missingServiceAccountDetailsWarning();
exit;
}
$client = new Google_Client();
$client->setApplicationName("Sheets API Testing");
$service = new Google_Service_Drive($client);
if (isset($_SESSION['service_token'])) {
$client->setAccessToken($_SESSION['service_token']);
}
$key = file_get_contents($key_file_location);
$cred = new Google_Auth_AssertionCredentials(
$service_account_name, array('https://www.googleapis.com/auth/drive', 'https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive.apps.readonly'), $key
);
$client->setAssertionCredentials($cred);
if ($client->getAuth()->isAccessTokenExpired()) {
$client->getAuth()->refreshTokenWithAssertion($cred);
}
$_SESSION['service_token'] = $client->getAccessToken();
// Get access token for spreadsheets API calls
$resultArray = json_decode($_SESSION['service_token']);
$accessToken = $resultArray->access_token;
// The file ID was copied from a URL while editing the sheet in Chrome
$fileId = '1JfnVnz8TxxxxxxxxxxxxxxxxxxxxxxxxxxA'; //change for security reasons
function updateFile($service, $fileId, $newTitle, $newDescription, $newMimeType = null, $rowData, $newRevision, $currentRow) {
try {
// First retrieve the file from the API.
$file = $service->files->get($fileId);
// File's new metadata.
$file->setTitle($newTitle);
$file->setDescription($newDescription);
$file->setMimeType($newMimeType);
// File's new content.
// foreach ($rowData as $row) {
$additionalParams = array(
'newRevision' => $newRevision,
'data' => $rowData,
'mimeType' => $newMimeType,
'uploadType' => 'multipart',
'convert' => true,
);
// Send the request to the API.
$updatedFile = $service->files->update($fileId, $file, $additionalParams);
return $updatedFile;
// }
} catch (Exception $e) {
print "An error occurred: " . $e->getMessage();
}
}
$currentRow = 1;
foreach ($rowData as $row) {
$responseData = updateFile($service, $fileId, 'Update G Excel', 'Update GG Excel Desc', 'text/csv', $row, true, $currentRow);
var_dump($responseData);
$currentRow++;
die;
}
Above code is working only for A1 cell of sheet 1. I need to update multiple cells and rows. But I am not getting any helpful doc. Any help will be highly appreciated.
Current Output is - only 1 cell in first row of first sheet is updated.
Expected Output is - something like this
Name Role Department
XXX Developer IT
YYY QA IT
ZZZ Developer IT
AAA Developer IT
php mysql
google-api-php-client worksheet asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
Where does $rowData come from, and what does it contain? I'm not seeing where you're specifying any sort of coordinate.
– Ro Achterberg
Nov 19 '18 at 20:39
And how is this an Excel question? Please don't use irrelevant tags.
– Tim Williams
Nov 19 '18 at 20:49
@Ro - $rowData is multidimensional array, which is return from MySQL query.
– Pooja Choudhary
Nov 20 '18 at 2:36
Can you update your question to show how you obtain $rowData, and show us what it contains?
– Ro Achterberg
Nov 20 '18 at 9:56
@RoAchterberg I have added db.php file and $rowData's output in question.
– Pooja Choudhary
Nov 20 '18 at 10:15
add a comment |
0
0
0
For below code I am using https://github.com/googleapis/google-api-php-client library (Client Requirement - this library must be used without composer).
So now come to the requirement - my client want to update data rows from mysql to google spreadsheed (which will be any sheet eg. sheet 1 or sheet 2).
I am facing issue in posting multiple rows and cells as well.
db.php code
<?php
$servername = "localhost";
$username = "newuser";
$password = "password";
$db = "google_sheet";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM table2";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$rowData = mysqli_fetch_all($result);
} else {
echo "No records in table";
}
/* $rowData contains below array
array (size=4)
0 =>
array (size=3)
0 => string 'XXX' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
1 =>
array (size=3)
0 => string 'YYY' (length=3)
1 => string 'QA' (length=2)
2 => string 'IT' (length=2)
2 =>
array (size=3)
0 => string 'ZZZ' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
3 =>
array (size=3)
0 => string 'AAA' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2) */
Note- Here is my complete code except credentials and spreadsheet id (Changed it for security reasons).
<?php
//echo phpinfo();
ini_set('display_errors', 1);
error_reporting(E_ALL);
session_start();
include_once "examples/templates/base.php";
require_once 'autoload.php';
include 'db.php';
$client_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Client ID
$service_account_name = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Email Address
$key_file_location = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx';
echo pageHeader("Service Account Access");
if (strpos($client_id, "googleusercontent") == false || !strlen($service_account_name) || !strlen($key_file_location)) {
echo missingServiceAccountDetailsWarning();
exit;
}
$client = new Google_Client();
$client->setApplicationName("Sheets API Testing");
$service = new Google_Service_Drive($client);
if (isset($_SESSION['service_token'])) {
$client->setAccessToken($_SESSION['service_token']);
}
$key = file_get_contents($key_file_location);
$cred = new Google_Auth_AssertionCredentials(
$service_account_name, array('https://www.googleapis.com/auth/drive', 'https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive.apps.readonly'), $key
);
$client->setAssertionCredentials($cred);
if ($client->getAuth()->isAccessTokenExpired()) {
$client->getAuth()->refreshTokenWithAssertion($cred);
}
$_SESSION['service_token'] = $client->getAccessToken();
// Get access token for spreadsheets API calls
$resultArray = json_decode($_SESSION['service_token']);
$accessToken = $resultArray->access_token;
// The file ID was copied from a URL while editing the sheet in Chrome
$fileId = '1JfnVnz8TxxxxxxxxxxxxxxxxxxxxxxxxxxA'; //change for security reasons
function updateFile($service, $fileId, $newTitle, $newDescription, $newMimeType = null, $rowData, $newRevision, $currentRow) {
try {
// First retrieve the file from the API.
$file = $service->files->get($fileId);
// File's new metadata.
$file->setTitle($newTitle);
$file->setDescription($newDescription);
$file->setMimeType($newMimeType);
// File's new content.
// foreach ($rowData as $row) {
$additionalParams = array(
'newRevision' => $newRevision,
'data' => $rowData,
'mimeType' => $newMimeType,
'uploadType' => 'multipart',
'convert' => true,
);
// Send the request to the API.
$updatedFile = $service->files->update($fileId, $file, $additionalParams);
return $updatedFile;
// }
} catch (Exception $e) {
print "An error occurred: " . $e->getMessage();
}
}
$currentRow = 1;
foreach ($rowData as $row) {
$responseData = updateFile($service, $fileId, 'Update G Excel', 'Update GG Excel Desc', 'text/csv', $row, true, $currentRow);
var_dump($responseData);
$currentRow++;
die;
}
Above code is working only for A1 cell of sheet 1. I need to update multiple cells and rows. But I am not getting any helpful doc. Any help will be highly appreciated.
Current Output is - only 1 cell in first row of first sheet is updated.
Expected Output is - something like this
Name Role Department
XXX Developer IT
YYY QA IT
ZZZ Developer IT
AAA Developer IT
php mysql
google-api-php-client worksheet asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
For below code I am using https://github.com/googleapis/google-api-php-client library (Client Requirement - this library must be used without composer).
So now come to the requirement - my client want to update data rows from mysql to google spreadsheed (which will be any sheet eg. sheet 1 or sheet 2).
I am facing issue in posting multiple rows and cells as well.
db.php code
<?php
$servername = "localhost";
$username = "newuser";
$password = "password";
$db = "google_sheet";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM table2";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$rowData = mysqli_fetch_all($result);
} else {
echo "No records in table";
}
/* $rowData contains below array
array (size=4)
0 =>
array (size=3)
0 => string 'XXX' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
1 =>
array (size=3)
0 => string 'YYY' (length=3)
1 => string 'QA' (length=2)
2 => string 'IT' (length=2)
2 =>
array (size=3)
0 => string 'ZZZ' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2)
3 =>
array (size=3)
0 => string 'AAA' (length=3)
1 => string 'Developer' (length=9)
2 => string 'IT' (length=2) */
Note- Here is my complete code except credentials and spreadsheet id (Changed it for security reasons).
<?php
//echo phpinfo();
ini_set('display_errors', 1);
error_reporting(E_ALL);
session_start();
include_once "examples/templates/base.php";
require_once 'autoload.php';
include 'db.php';
$client_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Client ID
$service_account_name = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'; //Email Address
$key_file_location = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx';
echo pageHeader("Service Account Access");
if (strpos($client_id, "googleusercontent") == false || !strlen($service_account_name) || !strlen($key_file_location)) {
echo missingServiceAccountDetailsWarning();
exit;
}
$client = new Google_Client();
$client->setApplicationName("Sheets API Testing");
$service = new Google_Service_Drive($client);
if (isset($_SESSION['service_token'])) {
$client->setAccessToken($_SESSION['service_token']);
}
$key = file_get_contents($key_file_location);
$cred = new Google_Auth_AssertionCredentials(
$service_account_name, array('https://www.googleapis.com/auth/drive', 'https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive.apps.readonly'), $key
);
$client->setAssertionCredentials($cred);
if ($client->getAuth()->isAccessTokenExpired()) {
$client->getAuth()->refreshTokenWithAssertion($cred);
}
$_SESSION['service_token'] = $client->getAccessToken();
// Get access token for spreadsheets API calls
$resultArray = json_decode($_SESSION['service_token']);
$accessToken = $resultArray->access_token;
// The file ID was copied from a URL while editing the sheet in Chrome
$fileId = '1JfnVnz8TxxxxxxxxxxxxxxxxxxxxxxxxxxA'; //change for security reasons
function updateFile($service, $fileId, $newTitle, $newDescription, $newMimeType = null, $rowData, $newRevision, $currentRow) {
try {
// First retrieve the file from the API.
$file = $service->files->get($fileId);
// File's new metadata.
$file->setTitle($newTitle);
$file->setDescription($newDescription);
$file->setMimeType($newMimeType);
// File's new content.
// foreach ($rowData as $row) {
$additionalParams = array(
'newRevision' => $newRevision,
'data' => $rowData,
'mimeType' => $newMimeType,
'uploadType' => 'multipart',
'convert' => true,
);
// Send the request to the API.
$updatedFile = $service->files->update($fileId, $file, $additionalParams);
return $updatedFile;
// }
} catch (Exception $e) {
print "An error occurred: " . $e->getMessage();
}
}
$currentRow = 1;
foreach ($rowData as $row) {
$responseData = updateFile($service, $fileId, 'Update G Excel', 'Update GG Excel Desc', 'text/csv', $row, true, $currentRow);
var_dump($responseData);
$currentRow++;
die;
}
Above code is working only for A1 cell of sheet 1. I need to update multiple cells and rows. But I am not getting any helpful doc. Any help will be highly appreciated.
Current Output is - only 1 cell in first row of first sheet is updated.
Expected Output is - something like this
Name Role Department
XXX Developer IT
YYY QA IT
ZZZ Developer IT
AAA Developer IT
php mysql
google-api-php-client worksheet php mysql
google-api-php-client worksheet asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
edited Nov 20 '18 at 10:14
Pooja Choudhary
asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
asked Nov 19 '18 at 20:24
Pooja ChoudharyPooja Choudhary
1016
1016
Where does $rowData come from, and what does it contain? I'm not seeing where you're specifying any sort of coordinate.
– Ro Achterberg
Nov 19 '18 at 20:39
And how is this an Excel question? Please don't use irrelevant tags.
– Tim Williams
Nov 19 '18 at 20:49
@Ro - $rowData is multidimensional array, which is return from MySQL query.
– Pooja Choudhary
Nov 20 '18 at 2:36
Can you update your question to show how you obtain $rowData, and show us what it contains?
– Ro Achterberg
Nov 20 '18 at 9:56
@RoAchterberg I have added db.php file and $rowData's output in question.
– Pooja Choudhary
Nov 20 '18 at 10:15
add a comment |
Where does $rowData come from, and what does it contain? I'm not seeing where you're specifying any sort of coordinate.
– Ro Achterberg
Nov 19 '18 at 20:39
And how is this an Excel question? Please don't use irrelevant tags.
– Tim Williams
Nov 19 '18 at 20:49
@Ro - $rowData is multidimensional array, which is return from MySQL query.
– Pooja Choudhary
Nov 20 '18 at 2:36
Can you update your question to show how you obtain $rowData, and show us what it contains?
– Ro Achterberg
Nov 20 '18 at 9:56
@RoAchterberg I have added db.php file and $rowData's output in question.
– Pooja Choudhary
Nov 20 '18 at 10:15
Where does $rowData come from, and what does it contain? I'm not seeing where you're specifying any sort of coordinate.
– Ro Achterberg
Nov 19 '18 at 20:39
Where does $rowData come from, and what does it contain? I'm not seeing where you're specifying any sort of coordinate.
– Ro Achterberg
Nov 19 '18 at 20:39
And how is this an Excel question? Please don't use irrelevant tags.
– Tim Williams
Nov 19 '18 at 20:49
And how is this an Excel question? Please don't use irrelevant tags.
– Tim Williams
Nov 19 '18 at 20:49
@Ro - $rowData is multidimensional array, which is return from MySQL query.
– Pooja Choudhary
Nov 20 '18 at 2:36
@Ro - $rowData is multidimensional array, which is return from MySQL query.
– Pooja Choudhary
Nov 20 '18 at 2:36
Can you update your question to show how you obtain $rowData, and show us what it contains?
– Ro Achterberg
Nov 20 '18 at 9:56
Can you update your question to show how you obtain $rowData, and show us what it contains?
– Ro Achterberg
Nov 20 '18 at 9:56
@RoAchterberg I have added db.php file and $rowData's output in question.
– Pooja Choudhary
Nov 20 '18 at 10:15
@RoAchterberg I have added db.php file and $rowData's output in question.
– Pooja Choudhary
Nov 20 '18 at 10:15
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53382107%2fupdate-values-on-specific-google-spreadsheet-with-google-api-php-client-version%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53382107%2fupdate-values-on-specific-google-spreadsheet-with-google-api-php-client-version%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Where does $rowData come from, and what does it contain? I'm not seeing where you're specifying any sort of coordinate.
– Ro Achterberg
Nov 19 '18 at 20:39
And how is this an Excel question? Please don't use irrelevant tags.
– Tim Williams
Nov 19 '18 at 20:49
@Ro - $rowData is multidimensional array, which is return from MySQL query.
– Pooja Choudhary
Nov 20 '18 at 2:36
Can you update your question to show how you obtain $rowData, and show us what it contains?
– Ro Achterberg
Nov 20 '18 at 9:56
@RoAchterberg I have added db.php file and $rowData's output in question.
– Pooja Choudhary
Nov 20 '18 at 10:15