任务是在特定范围(变量“ range”)中找到单词“ Request”,从与“ Request”匹配的行的最近列中复制信息,然后将其粘贴到另一个范围。
无法弄清楚如何在多个单元格中插入变量“ offsetval1”的值。似乎它返回9个值,但是如果我使用Logger.log(offsetval1.length);进行检查,它返回1.0。但是,有9行具有不同的值(请查看屏幕截图)。
如何输入这9行范围内的“ offsetval1”值?
function DocReq() {
var ui = SpreadsheetApp.getUi();
var result = ui.prompt("Please, enter Line Count"); // Prompt Input
var line_count = result.getResponseText(); // Prompt Result (Number) as VAR
var int_line_count = (+line_count); // Number as Integer
var range_bottom = int_line_count-1; // Integer - 1 (Total Amount of Rows)
var spreadsheet = SpreadsheetApp.getActive();
var currect_cell = spreadsheet.getActiveCell().getRow(); // Row of Active Cell
var int_current_cell = (+currect_cell); // Row as Integer (Top First Row)
var main_range_bottom = int_current_cell+range_bottom; // Bottom Last Row
var range = spreadsheet.getRange('L' + int_current_cell + ':' + 'L'+ main_range_bottom); // Get Range All !Requested!
var find_rqst = range.createTextFinder('Requested').findAll(); // Creating Text Finder !Requested!
for (var i = 0; i < find_rqst.length; i++) { // Finding Exceptionally !Requested!
var arrayofreq = find_rqst[i];
var offsetval1 = arrayofreq.offset(0, -4).getValues(); // Getting Values of !H! Column of All !Requested!
Logger.log(offsetval1);
}
Logger.log(offsetval1.length);
Logger.log(find_rqst.length);
spreadsheet.getRange('K131:K139').setValues(offsetval1);
}
代码的问题是offsetval1
在for
循环内迭代定义,因此它始终包含一个值,这就是为什么长度为的原因1
。您实际上是用新内容覆盖了先前的内容。
set
。function DocReq() {
var ui = SpreadsheetApp.getUi();
var result = ui.prompt("Please, enter Line Count"); // Prompt Input
var line_count = result.getResponseText(); // Prompt Result (Number) as VAR
var int_line_count = (+line_count); // Number as Integer
var range_bottom = int_line_count-1; // Integer - 1 (Total Amount of Rows)
var spreadsheet = SpreadsheetApp.getActive();
var currect_cell = spreadsheet.getActiveCell().getRow(); // Row of Active Cell
var int_current_cell = (+currect_cell); // Row as Integer (Top First Row)
var main_range_bottom = int_current_cell+range_bottom; // Bottom Last Row
var range = spreadsheet.getRange('L' + int_current_cell + ':' + 'L'+ main_range_bottom); // Get Range All !Requested!
var find_rqst = range.createTextFinder('Requested').findAll(); // Creating Text Finder !Requested!
var offsetval1 = []; // Modified code
for (var i = 0; i < find_rqst.length; i++) { // Finding Exceptionally !Requested!
var arrayofreq = find_rqst[i];
offsetval1.push([arrayofreq.offset(0, -4).getValue()]); // Modified code
}
spreadsheet.getRange('K131:K139').setValues(offsetval1);
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句