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
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  /
30
2020
12

Python selenium + JS

selenium.webdriver.support.ui WebDriverWait selenium.webdriver.support expected_conditions EC selenium webdriver time driver = webdriver.Chrome() driver.maximize_window() driver.get() time.sleep()
02
2020
12

selenium aoto-fill self declaration form

#!/usr/bin/python3#!/usr/bin/env python3from pyvirtualdisplay import Displayfrom selenium import webdriverimport timedisplay = Display(visible=0, size=(800, 600))display.start()m=str(time.strftime("%m", time.localtime()))d=str(time.strftime
18
2020
11

Gdrive img download

import osfrom google.colab import drivefrom google.colab import filesfrom google.colab import authauth.authenticate_user()from oauth2client.client import GoogleCredentialsimport requestsimport lxmlfrom bs4 import BeautifulSoupdrive.mount('/conten