摘要:
1 import pymysql 2 3 #格式 :pymysql.connect("","用户名","密码","数据库",charset= "utf8") 4 database = pymysql.connect("127.0.0.1","test","test","db",charset= "utf8") 5 #初始化指针 6 cursor = database.cursor(... 阅读全文
摘要:
1 import xlrd 2 import xlwt 3 from xlutils.copy import copy 4 5 objWb = xlrd.open_workbook(r'C:\Users\IBM\Desktop\新建文件夹\S1-3\7月下旬入库表.xlsx') 6 objSht = objWb.sheet_by_index(0) 7 # 定义列表,存储读取的内容... 阅读全文
摘要:
1 import xlrd 2 import xlwt 3 from xlutils.copy import copy 4 5 # 读取工作簿 6 objWB = xlrd.open_workbook(r'C:\Users\IBM\Desktop\新建文件夹\S1-2\日统计.xls', formatting_info=True) 7 # 对象变量赋值 8 objSht = o... 阅读全文
摘要:
1 import xlrd 2 # \U 开始的字符被编译器认为是八进制 解决方法 r 3 objWB = xlrd.open_workbook(r'C:\Users\IBM\Desktop\S1\7月下旬入库表.xlsx') 4 # 索引号 objTable =objWB.sheet_by_index(0) 5 objTable = objWB.sheet_by_name('7月下旬入库表')... 阅读全文
摘要:
1 Option Explicit 2 3 Sub Mian() 4 Application.ScreenUpdating = False 5 Application.DisplayAlerts = False 6 Application.EnableEvents = False 7 Application.StatusBar = True 8 Dim Path$, File$... 阅读全文
摘要:
1 Function SheetIsExist(shtName) As Boolean 2 Dim ws As Worksheet 3 On Error Resume Next 4 Set ws = Worksheets("" & shtName) 5 SheetIsExist = (Err = 0) 6 Err.Clear: On Error GoTo ... 阅读全文
摘要:
Sheet1: Template: 阅读全文