在新工作表的每一行上写一个元素 [英] Writing an element on each row of a new sheet
问题描述
我有一个数据数组.我想将数组的每个元素写到新表中的一行上.另外,我希望元素内的每个元素都位于下一个单元格中.我不确定如何去做.
I have a data array. I would like to write each element of the array onto a row in a new sheet. In addition, I would like each element within an element to be in the next cell along. I'm not sure about how I go about doing this.
我认为嵌套的for循环可能是解决方案,这是我在下面尝试过的.它设法将每个元素打印到Logger上.现在,我只需要一种将其成行写入电子表格的方法.
I think that a nested for loop might be solution which is what I have tried below. It manages to print each element onto the Logger; now I just need a way to write it to a spreadsheet in rows.
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var data = [['Mr. Gerald', 'Monday', '2:10'], ['Mr. Holmes', 'Tuesday', '3:00']]
var dataSheet = ss.getActiveSheet()
var startRange = dataSheet.getRange(1,1)
for (var i = 0; i < data.length;i++) {
for (var a = 0; a<data[i].length; a++) {
Logger.log(data[i][a])
}}
}
任何帮助将不胜感激,谢谢!
Any help will be appreciated, thank you!
推荐答案
您的data
采用工作表中要求的实际格式:
Your data
is in the actual format that's required in the sheet:
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var data = [['Mr. Gerald', 'Monday', '2:10'],
['Mr. Holmes', 'Tuesday', '3:00']];
var dataSheet = ss.getActiveSheet();
dataSheet.getRange(1,1,data.length,data[0].length).setValues(data); //or use Advanced Google Services
}
如果data
不是方形/矩形,请使用高级Google服务:
If data
is not of square/rectangular shape, Use Advanced Google services:
var request = {
range: dataSheet.getName() + '!A1',
majorDimension: 'ROWS',
values: data,
};
//API must be enabled before use.
//https://developers.google.com/apps-script/advanced/sheets
Sheets.Spreadsheets.Values.update(request, ss.getId(), request.range, {
valueInputOption: 'USER_ENTERED',
});
这篇关于在新工作表的每一行上写一个元素的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!