10
2021
04
Generate Coating component from Running color
function getCoatingComponent() { &nbs
作者:john | 分类:Programme | 浏览:30 | 评论:0
04
2021
04
RSI get Cosmetic component from FC1 report
function RSI() { var str = SpreadsheetApp.getUi().prompt("Please enter FC1 tested component").getResponseText() &
作者:john | 分类:Programme | 浏览:35 | 评论:0
02
2021
04
CompareSheets
function referHL(){ var sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); //获取第一张Sheet1 var E_to_I_col_data1 = sheet1.getRange(2, 5, sheet1.getLastRow(),5).getValues(); //获取第一张S
作者:kerek | 分类:Programme | 浏览:41 | 评论:0
01
2021
04
2 array replicates and return their indexes
//========2 array find duplicates========var j = ['IdA', 'ket', 'IdC', 'IdD', 'chj'];var k = ['ket', 'chj', 'IdF', 'IdA'];var r = j.filter(function(val) { return k.indexOf(
作者:john | 分类:Programme | 浏览:29 | 评论:0
09
2021
03
Shiny's running color GAS script
var ss = SpreadsheetApp.getActiveSpreadsheet();var sheet = ss.getActiveSheet();var rangeData = sheet.getDataRange();var lastColumn = rangeData.getLastColumn();var lastRow = rangeData.getLastRow();var searchRange = sheet.getRange(1,1, lastRow, lastCol
作者:kerek | 分类:Programme | 浏览:36 | 评论:0
02
2021
03
shiny's amended GAS script
var ss = SpreadsheetApp.getActiveSpreadsheet();var sheet = ss.getActiveSheet();var rangeData = sheet.getDataRange();var lastColumn = rangeData.getLastColumn();var lastRow = ra
作者:kerek | 分类:Programme | 浏览:36 | 评论:0
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 | 浏览:28 | 评论: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 | 浏览:53 | 评论:0
10
2021
01
Auto.js Automate your cellphone
Wechat send message ~app.startActivity({ action: "VIEW", packageName:"com.tencent.mm", className: "com.tencent.
作者:kerek | 分类:Programme | 浏览:42 | 评论:0
01
2021
01
Python selenium Waiting for elements
https://huilansame.github.io/huilansame.github.io/archivers/sleep-implicitlywait-waithttps://cuiqingcai.com/2599.htmlinput class -------> is-invalid-input form_input__inputRel XPath
//input[@type='number']Abs XPath /
作者:kerek | 分类:Programme | 浏览:38 | 评论:0