Fork me on GitHub
11 2020 档案
Python实现excel的查找与替换(转EXE后可直接运行)
摘要:#如果看不懂联系Q:18081530 #如需转载请联系,或注明出处,否则追究法律责任。#excel openpyxl库 和os 库的使用。import openpyxlimport osexcle = os.getcwd() #获取当前目录路径file = os.listdir(excle) # 打 阅读全文
posted @ 2020-11-16 09:39 HOWX 阅读(1042) 评论(0) 推荐(0)
Python遍历excle
摘要:#遍历sheet1中所有行rownum_rows = worksheet1.nrowsfor curr_row in range(num_rows):row = worksheet1.row_values(curr_row)print('row%s is %s' %(curr_row,row)) # 阅读全文
posted @ 2020-11-09 09:26 HOWX 阅读(655) 评论(0) 推荐(0)