Is there a way to add tooltip to excel cell data in c#

Question

I am generating an excel sheet from multiple databases and wanted at particular column to add "Tooltip" to show, from where the data is being fetched. All I want some property or method to set Tooltip of any excel cell. At the moment I tried :

objCopy.Cells[j + Convert.ToInt16(StartRow["StartRow"]), 4].Tooltip = "From First Table";

And

objCopy.Cells[j + Convert.ToInt16(StartRow["StartRow"]), 4].setAttribute("title","From SpreadSheet");

Do you mean a Comment instead of Tooltip? Excel does not have an object Tooltip for a Range. If so, try Range.AddComment. — Byron Wall
– Byron Wall, Commented Jul 10, 2015 at 16:15
Do you want this "tooltip" to appear on mouseover or on mouseclick? You can use comments for mouseover, and data validation message on mouseclick. What library are you using for generating Excel file? — Techie
– Techie, Commented Jul 11, 2015 at 20:39

Patrick Hofman · Accepted Answer · 2015-07-10 16:26:51Z

1

No. Excel doesn't have tooltips. The only thing that comes close are comments.

The Range.AddComment is what you need for that.

answered Jul 10, 2015 at 16:26

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

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

11 Comments

Amit Singh Over a year ago

Hi Thanks for your reply. Can you please let me know how to use that. As of now I am using objCopy.Cells[j + Convert.ToInt16(StartRow["StartRow"]), 4].Range.AddComment("From SpreadSheet"); and it's still not working

Amit Singh Over a year ago

I am getting Error while invoking Range.

Amit Singh Over a year ago

{System.Reflection.TargetParameterCountException: Error while invoking Range. at System.Dynamic.ComRuntimeHelpers.CheckThrowException(Int32 hresult, ExcepInfo& excepInfo, UInt32 argErr, String message) at CallSite.Target(Closure , CallSite , ComObject ) at System.Dynamic.UpdateDelegates.UpdateAndExecute1[T0,TRet]

Amit Singh Over a year ago

Range is correct. I am just checking for some syntax stuff related to invoking range

Patrick Hofman Over a year ago

Try to remove the Range in between.

|

Collectives™ on Stack Overflow

Is there a way to add tooltip to excel cell data in c#

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related