Answer the question
In order to leave comments, you need to log in
How to correctly insert an array into a table row?
How to correctly insert an array into a string?
Wrote this code
function AppendRow() {
let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data')[0];
var array = [
'Петя',
44444,
'Петя',
44444,
'Петя',
44444,
44444,
44444,
44444,
'Петя',
'Петя',
44444,
'Петя',
'Петя',
];
sheet.appendRow(array);
sheet.appendRow(['Frodo', 'Baggins', 'Hobbit', 'The Shire', 33]);
}
TypeError: Cannot read property 'appendRow' of undefined
Answer the question
In order to leave comments, you need to log in
Must be
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data");
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question