10
2021
04

Generate Coating component from Running color

function getCoatingComponent() {                                  &nbs
04
2021
04

RSI get Cosmetic component from FC1 report

function RSI() {    var str =  SpreadsheetApp.getUi().prompt("Please enter FC1 tested component").getResponseText()         &
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
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(
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
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
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
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
10
2021
01

Auto.js Automate your cellphone

Wechat send message ~app.startActivity({                action: "VIEW",        packageName:"com.tencent.mm",        className: "com.tencent.
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  /