from openpyxl import load_workbook, Workbook
import glob path = 'F:\桌面\測驗\測驗1'
wb = Workbook()
ws = wb.active flag = 0 for file in glob.glob(path + '/*.xls'): wb = load_workbook(file) sheet = wb.active a = sheet['C'] row_lst = [] for cell in a: if a in "基礎": print(cell.row) row_lst.append(cell.row) if not flag: header = sheet[1] header_lst = [] for cell in header: header_lst.append(cell.value) new_sheet.append(header_lst) flag = 1 for row in row_lst: data_lst = [] for cell in sheet[row]: data_lst.append(cell.value) new_sheet.append(data_lst) wb.save(path + '/' + '符合篩選條件的新表.xlsx')
代碼不知道哪里出錯了，請問有大神幫忙看看嗎？
uj5u.com熱心網友回復：
是不是路徑path的斜杠方向不對，最好貼一下報錯資訊轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/244420.html
上一篇：STM32
下一篇：學習帖