openpyxl
jidawanghao
这个作者很懒,什么都没留下…
展开
-
continue
""" 用python批量获取某路径文件夹及子文件夹下的指定类型文件excel,并按指定路径进行存储 """ import os import os import win32com.client as win32 import shutil filelist_trans = [] path_trans = os.getcwd() #转换前程序所在文件目录 pathlist_trans = os.listdir(path_trans) filelist_same = [] pa.原创 2021-01-13 16:27:54 · 81 阅读 · 0 评论 -
python excel跨目录操作时,需要用到转义符
import os import win32com.client as win32 import easygui as eg import openpyxl fn_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 · 115 阅读 · 0 评论 -
python openpyxl跨目录访问excel
import os import win32com.client as win32 import easygui as eg import openpyxl fn_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 · 178 阅读 · 0 评论 -
有个疑问,带目录的load_workbook
带目录的workbook如何锁定呢?原创 2021-01-12 16:37:29 · 309 阅读 · 0 评论