03
2021
12

Python selenium 瀏覽器自動化

update for colab chrome!apt-get update!apt install chromium-chromedriver!cp /usr/lib/chromium-browser/chromedriver /usr/bin!pip install seleniumfrom selenium import webdriverfrom selenium.webdriver.common.by import Byoptions = webdriver.ChromeOptions
17
2021
10

revised tkinter

from tkinter import *from tkinter import ttkfrom tkinter import messageboximport sqlite3from tkinter import colorchooserroot = Tk()root.title('MyDB')#root.iconbitmap('c:/gui/my.ico')root.geometry("1050x600")def query_databas
13
2021
10

Python tkinter GUI

from tkinter import *from tkinter import ttkimport sqlite3#建立主要frame -> rootroot = Tk()root.title('Treeview')#root.iconbitmap('c:/gui/xxxx.ico')root.geometry("1000x500")# Add Data'''data = [["Mary",
22
2021
09

BV list pdf to excel

!pip install tabula-pyimport tabulaimport pandas as pdfrom google.colab import drivefrom google.colab import filesfrom google.colab import authauth.authenticate_user()from oauth2client.client import GoogleCredentialsimport refrom google.col
16
2021
09

image to text ++++++++ pdf table format to Excel table

#######################image to text for colab only!sudo apt install tesseract-ocr!pip install pytesseractimport pytesseractimport shutilimport osimport randomfrom google.colab import drivef
28
2021
08

Python SQLITE3 Database

#!/usr/bin/pythonimport osfrom google.colab import drivefrom google.colab import filesfrom google.colab import authauth.authenticate_user()from oauth2client.client import GoogleCredenti
28
2021
08

Colab prevent sleep

setInterval(function() {  document.querySelector("#top-toolbar > colab-connect-button").shadowRoot.querySelector("#connect-icon").shadowRoot.querySelector("paper-button > iron-icon&quo
25
2021
08

Colab delete files and upload files to your destination folder

import osfrom google.colab import drivefrom google.colab import filesfrom google.colab import authauth.authenticate_user()from oauth2client.client import GoogleCredentialsdrive.mount(

17
2021
08

Python download photo with multithreads

import osfrom google.colab import drivefrom google.colab import filesfrom google.colab import authauth.authenticate_user()from oauth2client.client import GoogleCredentialsimport re

16
2021
08

AutoJs download photo with multithreads

//url = "https://imgbin.com/free-png/re-zero/"url = "https://imgbin.com/free-png/order-a-rabbit/1"var folder = "點兔/"//var folder = "Rezero/"var threadsTotal = 8 toast("圖片下載中"); var pagesTota