我需要打開一個 xlsx 檔案并為其著色。但我不明白為什么它會顯示單元格錯誤。我的演算法是這樣作業的：
打開xlsx， writer = pd.ExcelWriter(path, engine='xlsxwriter')
worksheet = writer.sheets['Sheet1']
col_style = Font(name = "Reem Kufi", size = 12, color = "DB3B22", italic =True)
for i in range(2,40):
worksheet.cell(row = i, column = 3).font = col_style
錯誤：- “作業表”物件沒有屬性“單元格”
uj5u.com熱心網友回復：
您將需要使用 Openpyxlloadworkbook而不是ExcelWriter來實作您正在尋找的東西。在這里更新了代碼。請注意，我只使用新代碼和所需的庫更改了初始打開的檔案和作業表，而沒有更改您的其余代碼。
from openpyxl.styles import Font
from openpyxl import load_workbook
writer = load_workbook(filename='YourFile.xlsx')
worksheet = writer['Sheet1']
col_style = Font(name = "Reem Kufi", size = 12, color = "DB3B22", italic =True)
for i in range(2,40):
worksheet.cell(row = i, column = 3).font = col_style
writer.save('YourFile.xlsx')
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/490352.html
下一篇：有沒有可能將求解器用作函式？