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 | 浏览:42 | 评论: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 | 浏览:37 | 评论: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 | 浏览:54 | 评论: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 | 浏览:39 | 评论:0
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()
作者:kerek | 分类:Programme | 浏览:28 | 评论:0
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
作者:kerek | 分类:Programme | 浏览:55 | 评论:0
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
作者:kerek | 分类:Programme | 浏览:52 | 评论:0