Insert cell comments in excel programmaticaly

calendar_today Asked Oct 21, 2008

thumb_up 6 upvotes

history Updated April 16, 2026

Question posted 2008 · +5 upvotes

What’s the better way to insert cell comments in excel 2007 files programmaticaly using c# and .net 3.5?

Accepted answer +6 upvotes

I just did exactly that but with MS Word (using Microsoft.Office.Interop.Word

range.Comments.Add ( range, ref _categoryMessage );

So, I would suggest using Microsoft.Office.Interop.Excel and the similar method. Consider this from MSDN:

http://msdn.microsoft.com/es-es/library/microsoft.office.interop.excel.range.addcomment.aspx

Also see this too

External references cited (2)

msdn.microsoft.com — http://msdn.microsoft.com/es-es/library/microsoft.office.interop.excel.range.addcomment.aspx
stackoverflow.com — this

Excel VBA objects referenced (5)

Interop.Excel — Using events with Excel objects
Interop.Excel — Using Excel worksheet functions in Visual Basic
Interop.Word — Exporting a Range to a Table in a Word Document
Interop.Word — Using events with the Application object (Word)
Microsoft.Office — Controlling One Microsoft Office Application from Another

Top `excel` Q&A (6)

Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
Convert xlsx to csv in linux command line +96 (2012)
How to create a link inside a cell using EPPlus +50 (2011)
IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
T-SQL: Export to new Excel file +44 (2012)

+6 upvotes ranks this answer #141 out of 167 excel solutions on this site .