＆＃x27;工作表＆＃x27;对象没有属性＆＃x27; cell＆＃x27;

发布于 2025-02-06 23:58:39 字数 409 浏览 6 评论 0原文

我需要打开一个XLSX文档并为其着色。但是我不明白为什么它会显示细胞错误。我的算法工作如下：

打开xlsx，writer = pd.excelwriter（path，eNgire ='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

错误： - 'worksheet'对象没有属性'cell'

原文

I need to open an xlsx document and color it. But I don't understand why it shows cell error it. My algorithm works like this:

Open 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

Error:- 'Worksheet' object has no attribute 'cell'

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

述情 2025-02-13 23:58:39

您将需要使用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')

you will need to use Openpyxl's loadworkbook instead of ExcelWriter to achieve what you are looking for. Updated code here. Note that I have only changed the initial open file and sheet using the new code and required libraries and not changed rest of your code.

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')

回复收藏 0 原文

~没有更多了~