我需要根據該行的第 2 列中的內容列印谷歌表中的某些行。我知道如何使用 for 回圈找到行，但其余的卻讓我望而卻步。也許我的谷歌搜索技能已經生疏了。
這就是我所擁有的。
var app = SpreadsheetApp;
var rows = app.getActive().getSheetByName("Sheet").getMaxRows().toString();
var rows = rows.replace(".0","");
function findRows(){
for (var counter = 1; counter <= rows; counter = counter 1){
if(app.getActive().getSheetByName("Sheet").getRange(counter, 2) == "example" || "example2"){
}
}
uj5u.com熱心網友回復：
找到正確的行
function findrows() {
const ss = SpreadsheetApp.getActive();
const sh = ss.getSheetByName("Sheet0");
const osh = sh.getSheetByName("Sheet1");
const vs = sh.getDataRange().getValues();
let s = vs.map(r => {
if(r[1] == "Example" || r[1] == "example2") {
return r;
}
}).filter(e => e);
Logger.log(JSON.stringify(s));
//you can output to a sheet with something like
//sheet.getRange(1,1,s.length,s[0].length).setValues(s);
osh.getRange(1,1,s.length,s[0].length).setValues(s);//put on another sheet
}
Execution log
4:56:34 PM Notice Execution started
4:56:35 PM Info [[2,"Example",4,5],[5,"Example",7,8],[9,"Example",11,12],[12,"Example",14,15]]
4:56:35 PM Notice Execution completed
資料：
| COL1 | COL2 | COL3 | COL4 |
|---|---|---|---|
| 1 | 2 | 3 | 4 |
| 2 | 例子 | 4 | 5 |
| 3 | 4 | 5 | 6 |
| 4 | 5 | 6 | 7 |
| 5 | 例子 | 7 | 8 |
| 6 | 7 | 8 | 9 |
| 7 | 8 | 9 | 10 |
| 8 | 9 | 10 | 11 |
| 9 | 例子 | 11 | 12 |
| 10 | 11 | 12 | 13 |
| 11 | 12 | 13 | 14 |
| 12 | 例子 | 14 | 15 |
| 13 | 14 | 15 | 16 |
BTW Printing is not easily done from Javascript or Google Apps Script
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/457235.html