“‘Worksheet”对象没有属性“cell”

Question

我需要打开一个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

错误：-‘工作表’对象没有属性'cell'

Answer 1

您需要使用Openpyxl的loadworkbook而不是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')