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)
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)