quick reference to triage

#! Python3#blankrowinserter.pyImportOpenpyxl,osos.chdir ('c:\\users\\administrator\\python35-32') n=int (Input ('RowNum')) M=int (Input ('Insertrownum')) name=('updatedproducesales2.xlsx') WB=Openpyxl.load_workbook (name) wbnew=OPENPYXL. Workbook () sheet=wb.get_active_sheet () sheetnew=Wbnew.get_active_sheet () forRowNuminchRange (1, sheet.max_row+1): ifRowNum > N-1: forColnuminchRange (1,sheet.max_column+1): Producename= Sheet.cell (Row=rownum, column=colnum). Value Sheetnew.cell (Row=row

ImportOs,pypdf2os.chdir ('d:\\my Documents') forFolderName, subfolders, filenamesinchOs.walk ('d:\\my Documents'): forFileinchFilenames:ifFile.endswith ('. pdf'): Pdffile= Open (file,'RB') Pdfreader=Pypdf2.pdffilereader (pdffile) PDFWriter=Pypdf2.pdffilewriter () forPagenuminchRange (pdfreader.numpages): Pdfwriter.addpage (Pdfreader.getpage (pagenum)) Pdfwriter.encrypt ('123456') Resultpdf= Open (file +'encrypted.pdf','WB') Pdfwriter.write (resultpdf) resultpdf.close ()Python Programming

Most beginners who have a basic development experience on other platforms are eager to see xcode. After seeing the interface builder, they are eager to get started with the objective-C syntax, the first thought becomes daunting. Okay, I'm talking about myself. If you are like me, you are interested in apple-related development: Mac OS X or iPhone, but the first time you see objective-C, it will cause headaches and fever, the quick treatment method wit

Simple C ++ boost Chinese manual directory Quick Reference This isn't intended to be a full, detailed reference; nor is it intended to be of any use to readers who aren't already familiar with spirit. it's just a brief reminder of the syntax and behaviour of each component, with links to the full documentation.T

Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux 1. re-build the Oracle user group of the host and standardize uid gid to ensure the permission specification for shared storage mounting or other requirements Userdel-r oracleGroupadd-g 500 oinstallGroupadd-g 501 dbaUser add-g oinstall-G dba-u 500 oracle # Id oracleUid = 500 (oracle) gid = 500 (oinstall)

table_name2On Table_name1.column_name=table_name2.column_name Left JOIN SELECT column_name (s)From table_name1Left JOIN table_name2On Table_name1.column_name=table_name2.column_name Right JOIN SELECT column_name (s)From table_name1Right JOIN table_name2On Table_name1.column_name=table_name2.column_name Full JOIN SELECT column_name (s)From table_name1Full JOIN table_name2On Table_name1.column_name=table_name2.column_name Like

Article Title: SED single-line script Quick Reference (Unix stream editor ). Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source. Text interval:--------# Add an empty row after each rowSed G# Delete all original empty rows and add an empty row after each row.# In this way, ea

Git distributed version control system Quick Reference 1. install and configure GitGit is an open-source distributed source code version control system. It is mainly used on Linux/Unix systems and has been transplanted to Windows systems for use.In Windows, Git is msysgit. tortoisegit can be used in a graphical environment. Generally, msysgit can be installed first and then tortoisegit can be installed.Git:

MySQL Getting Started Guide-quick reference (2) II. MySQL User Guide 1. use MySQL to create a new database Run in shell: $> Mysqladmin create database01 Database "database01" created. 2. start MySQL Run in shell: $> Mysql Welcome to the MySQL monitor. Commands end with; or g. Your MySQL connection id is 22 to server version: 3.21. 29a-gamma-debug Type 'HELP' for help. 3. change the database Mysql> use data

#!/usr/bin/env python3.52#Coding:utf-83#4#The main purpose of this project is the processing of strings, the simple format of the output5 Tabledata = [['Apples','oranges','Cherries','Banana'], 6 ['Alice','Bob','Carol','David'], 7 ['Dogs','Cats','Moose','Goose']] 8#The required output is as follows:9#Apples Alice Dogs10#Dranges Bob Cats11#Cherries Carol Moose12#Banana David Goose13 14#no output format, output format is all right-aligned15defprinttable (data):Str_data ="'Col_len = [] 18 forRowi

Most beginners who have a basic development experience on other platforms are eager to see XCode. After seeing the Interface Builder, they are eager to get started with the Objective-C syntax, the first thought becomes daunting. If you are like me, you are interested in apple-related development: Mac OS X or iPhone, but the first time you see Objective-C, it will cause headaches and fever, the quick treatment method with better curative effect is to r

Document directory A cvs command looks like: Global options: Keyword expansion modes Keywords Commands, command options, and command arguments: CVS Quick ReferenceA CVS command looks like: cvs [ global_options ] command [ command_options ] [ command_args ]Global options: --allow-root=rootdir Specify legal CVSROOT directory (server only) (not in CVS 1.9 and older ). -a Authenticate all communication (client only) (not

The 8th chapter of the Practical project of the crazy lyricsCreate a crazy lyrics (Mad Libs) program that will read into a text file and let the user appear in the text file where Adjective,noun,verb and other words are placed, plus their own text.First, prepare a a.txt text fileThe program code is as follows:#!/usr/bin/env python3.4#Coding:utf-8#8.9.2Importref1= Open ('a.txt','R') Strf1=F1.read ()Print("the contents of the original file are:")Print(strf1) strf1_list= Strf1.split (' ') F1.close

fromSelenium.webdriver.common.byImport by fromTimeImportSleepuserid=input ('username') Passid=input ('Password') Sendtxt="Hello"#Message ContentSendto=input ('SendTo')#Open FirefoxDriver =Webdriver. Firefox () Driver.get ('http://mail.10086.cn/')#Email Address#fill in the user nameEmailelem = driver.find_element_by_id ('Txtuser') Emailelem.send_keys (userid)#User name#fill in the passwordPasswordelem = driver.find_element_by_id ('Txtpass') Passwordelem.send_keys (PASSID)#PasswordPasswordelem.su

ImportPyautogui, time, OS, Pyautoguios.chdir ('C:\\users\\administrator\\python35-32\\test\\kuaisu') Guests= Open ('SendMesTo.txt') #打开好友名单 forNinchGuests:pyautogui.click (1300, 1, button=' Left') #用的是QQ, move the mouse to the top right corner of the screen, QQ pop-up window time.sleep (1) pyautogui.typewrite (n);p yautogui.press ('Enter') #输入好友名并按Enter Time.sleep (2) ifPyautogui.locateonscreen ('Foundnone.png') ==None: #如果没有好友则会弹出搜索窗, if the search window picture is not matched, enter the Hell