Computer (84) 썸네일형 리스트형 Excel macro send key Application.SendKeys("{UP}") Application.SendKeys("{DOWN}") Application.SendKeys("{LEFT}") Application.SendKeys("{RIGHT}") Application.SendKeys("{ENTER}") BACKSPACE/{BACKSPACE} or {BS} BREAK/{BREAK} CAPS LOCK/{CAPSLOCK} CLEAR/{CLEAR} DELETE or DEL/{DELETE} or {DEL} DOWN ARROW/{DOWN} END/{END} ENTER (numeric keypad)/{ENTER} ENTER/~ (tilde) ESC/{ESCAPE} or {ESC} HELP/{HELP} HOME/{HOME} INS/{INSERT.. Excel macro - Visual Basic loop To loop, insert following 'First of the code For I = 0 To 999 ' End of the code Next I SSL 무료로 설치 렛츠인크립트 Let's Encrypt sudo apt install python-certbot-apache #도메인 등록 이전에 호스트 ip 가 서버 ip로 변경이 되어있어야함 sudo certbot --apache -d domain.com #메일주소 입력 #사용약관 동의 y #이메일주소메일링리스트 등록 n # http 접속시 https로 리다이렉트 - 1 안한다(선택), 2 한다 # virtual host 80번포트에서 https로 redirect 후 ssl 적용 # 도메인파일 생성여부 확인 ls /etc/letsencrypt/live/ sudo a2enmod ssl sudo a2enmod cgid #default-ssl.conf 파일 설정 443 포트로 접속시 폴더이동 Python CGI를 활성화키 위해 아래 문구 삽입 nano /etc.. Windows cd-key finder by VBS 1. copy and paste following codes into text editor, 2. save it with extionsion '.vbs' 3. run the vbs file, 4. you will see windows cd-key in popup Set WshShell = CreateObject("WScript.Shell") winkey = ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DigitalProductId")) CreateObject("WScript.Shell").Run _ "mshta.exe javascript:eval(""document.parentWindow.clipboard.. MiTemp2 Read and write to SQL This post is for reading MiTemperature2 data via bluetooth and writing the data into SQL. Download reading temp. source from Github https://github.com/JsBergbau/MiTemperature2 Modify LYWSD03MMC.py file as below. parser=argparse.ArgumentParser(allow_abbrev=False) parser.add_argument("--device","-d", help="Set the device MAC-Address in format AA:BB:CC:DD:EE:FF",default='AA:BB:CC:DD:EE:FF',metavar=.. Core Temp This app can show CPU temperature on tray bar as below Download link https://www.alcpu.com/CoreTemp/ HIDE taskbar button when start-up in settings SQLite3 import sqlite3 dbpath = "test.db" conn = sqlite3.connect(dbpath) #File creation part try: cur = conn.cursor() cur.execute("CREATE TABLE info (name1 TEXT, name2 INTEGER)") conn.commit() except: print('File is Existing') #Input part cur = conn.cursor() cur.execute("INSERT INTO info (name1, name2) VALUES ('Hello', 57)") conn.commit() cur = conn.cursor() cur.execute("SELECT * FROM info") result = cu.. flask 플라스크 sudo pip3 install Flask sudo apt-get install apache2 sudo apt-get install libapache2-mod-wsgi-py3 sudo apt-get install php sudo nano /var/www/heeseop/run.wsgi import sys sys.path.append("/var/www/heeseop") from heeseop import app as application * from heeseop is 이전 1 2 3 4 5 ··· 11 다음
