Add Comments in Excel Worksheet using Python

readme.md

Read the complete article on adding comments in Excel using Python

add-comment-in-worksheet.py

# Instantiating a Workbook object
workbook = Workbook("workbook.xlsx")

# Obtaining the reference of the first worksheet by passing its sheet index
worksheet = workbook.getWorksheets().get(0)

# Adding a comment to "F5" cell
commentIndex = worksheet.getComments().add("F5")

# Accessing the newly added comment
comment = worksheet.getComments().get(commentIndex)

# Setting the comment note
comment.setNote("Hello Aspose!")

# Saving the Excel file
workbook.save("output.xlsx")

format-comment-in-worksheet.py

# Instantiating a Workbook object
workbook = Workbook("workbook.xlsx")

# Obtaining the reference of the first worksheet by passing its sheet index
worksheet = workbook.getWorksheets().get(0)

# Adding a comment to "F5" cell
commentIndex = worksheet.getComments().add("F5")

# Accessing the newly added comment
comment = worksheet.getComments().get(commentIndex)

# Setting the comment note
comment.setNote("Hello Aspose!")

# Setting the font size of a comment to 14
comment.getFont().setSize(14)

# Setting the font of a comment to bold
comment.getFont().setBold(True)

# Setting the height of the font to 10
comment.setHeightCM(10)

# Setting the width of the font to 2
comment.setWidthCM(2)

# Saving the Excel file
workbook.save("output.xlsx")  

this is a note not commnet.
How to add comment ? the new excel threaded comments ?

@rohitvishwakarma-sf
Please read our complete blog post that explains how to read, add, edit, and delete threaded comments in Excel using Python.
You can find the code here: https://gist.github.com/aspose-com-gists/1ca33b35d960d5e37753cdf314425c13