Menu
What's the better way to insert cell comments in excel 2007 files programmatically using c# and .net 3.5?
686
Right-click the cell and then click Insert Comment (or press Shift+F2). If you're using Excel for Office 365, right-click the cell and choose New Note. Type your annotation text. Click outside the cell.
Right-click the cell and select New Note. Enter your note and click outside the cell.
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:
https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel.range.addcomment
Also see this too
69
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
