I want to appended in google sheet. i write a code and it successfully worked in JavaScript.
function appendMajor() {
var responseJson ='{values : [["3/2/2017 13:38:32","3/2/2017","12:33:00 PM","ABC","xyz","pqr","bca"]] }';
gapi.client.sheets.spreadsheets.values.append({
spreadsheetId: 'spreadSheetId',
range: 'A1:B',
resource: responseJson,
valueInputOption: 'USER_ENTERED',
}).then(function (response) {
appendPre(response);
}, function (response) {
appendPre('Error: ' + response.result.error.message);
});
}
I want to change background color of appended row. First three cell will be in blue color and another four cell will be in grey color.
I try to do it with BatchUpdate also but it overwriting the row of the given range, not appending in sheet file. if anyone know how to append row using BatchUpdate then please answer me.