Add comment to excel using python win32

Question

I am trying to add new comment to excel with python, using win32.

import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(r'C:\...\.xlsx')
ws = wb.Worksheets('sheet1')
ws.Cells(1,1).AddComment = "comment"

--> object has no attribute 'AddComment'

Do you know how to add new comment to excel using win32? Thank you!

What's the reason, that you are using win32 over openpyxl or xlsxwriter ? — Maurice Meyer
– Maurice Meyer, Commented Nov 10, 2017 at 12:09
Because I should save exciting xlsx file format (charts, images..) — Aleks
– Aleks, Commented Nov 10, 2017 at 12:21

xMRi · Accepted Answer · 2017-11-10 12:17:36Z

5

Add comment is a method not a property.

ws = wb.Worksheets('sheet1')
ws.Cells(1,1).AddComment("comment")

Just read the the documentation in the MSDN.

edited Nov 10, 2017 at 12:17

answered Nov 10, 2017 at 12:09

xMRi

15.5k3 gold badges33 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Aleks Over a year ago

Thank you very much for answer and documentation!

xMRi Over a year ago

As you are new to stackoverflow. Mark it also as an answer if it solves the problem!

Aleks Over a year ago

Do you know how delete exciting comment? I tryed ws.Cells(1,1).ClearComments, but it don't work.

Aleks Over a year ago

ws.Cells(1,1).Comment.Delete() - works! msdn.microsoft.com/en-us/vba/excel-vba/articles/…

xMRi Over a year ago

Use a new question for such cases. Stackoverflow is not a discussion platform.

Collectives™ on Stack Overflow

Add comment to excel using python win32

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related