求大神解救,哪里的陳述句不對?
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'):
... workbook = load_workbook(file)
... sheet = workbook.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') File "<stdin>", line 26 wb.save(path + '\' + '符合篩選條件的新表.xlsx') ^
SyntaxError: invalid syntax
uj5u.com熱心網友回復:
用 \\試試轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/244886.html
下一篇:TypeError: create_task() got an unexpected keyword argument 'name'
