23
2021
02
write active range
function writeActiveRange() { const ss=SpreadsheetApp.getActive(); const sh=ss.getActiveSheet(); const rg=sh.getActiveRange(); let v=rg.getValues(); console.log(v)&n
作者:kerek | 分类:Programme | 浏览:92 | 评论:0
05
2021
02
Google sheet HL function
var ss = SpreadsheetApp.getActiveSpreadsheet();var sheet = ss.getActiveSheet();var rangeData = sheet.getDataRange();var lastColumn = rangeData.getLastColumn();var lastRow = ra
作者:kerek | 分类:Programme | 浏览:120 | 评论:0