
openpyxl
jidawanghao
这个作者很懒,什么都没留下…
展开
-
continue
"""用python批量获取某路径文件夹及子文件夹下的指定类型文件excel,并按指定路径进行存储"""import osimport osimport win32com.client as win32import shutilfilelist_trans = []path_trans = os.getcwd() #转换前程序所在文件目录pathlist_trans = os.listdir(path_trans)filelist_same = []pa.原创 2021-01-13 16:27:54 · 102 阅读 · 0 评论 -
python excel跨目录操作时,需要用到转义符
import osimport win32com.client as win32import easygui as egimport openpyxlfn_fuzhaibiao = r'C:\Users\laiwu\PycharmProjects\pythonProject1\1.xlsx'wb_fuzhaibiao = openpyxl.load_workbook(fn_fuzhaibiao)fuzhaibiao_allSheets = wb_fuzhaibiao.get_sheet_.原创 2021-01-13 13:52:26 · 151 阅读 · 0 评论 -
python openpyxl跨目录访问excel
import osimport win32com.client as win32import easygui as egimport openpyxlfn_fuzhaibiao = 'C:/Users/laiwu/PycharmProjects/pythonProject1/1.xlsx'wb_fuzhaibiao = openpyxl.load_workbook(fn_fuzhaibiao)fuzhaibiao_allSheets = wb_fuzhaibiao.get_sheet_n.原创 2021-01-13 13:43:35 · 217 阅读 · 0 评论 -
有个疑问,带目录的load_workbook
带目录的workbook如何锁定呢?原创 2021-01-12 16:37:29 · 338 阅读 · 0 评论