Read comment value from Excel Ranorex.Cell

Technology specific object identification, supported applications, web technologies, and 3rd party controls.
srdjan.bogojevic
Posts: 4
Joined: Mon Apr 02, 2012 10:43 am

Read comment value from Excel Ranorex.Cell

Post by srdjan.bogojevic » Mon Apr 02, 2012 11:23 am

Hi All,

Does anybody know, how to read excell cell comment valu from ranorex cell.
I can read comment value directly from excel as: cell.Comment.Shape.AlternativeText.

Or can I get this by the ranorex spy tool.

Thanks,
Srdjan

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

Re: Read comment value from Excel Ranorex.Cell

Post by Support Team » Mon Apr 02, 2012 1:02 pm

Hi,

by using the ExcelRange adapter instead of the Cell adapter you can use ExcelRangeObject of you cell:
ExcelRange my_cell = "<RanoreXPath of your cell>";
Report.Info(my_cell.GetExcelRangeObject().Comment.Shape.AlternativeText.ToString());
Regards,
Tobias
Ranorex Team

srdjan.bogojevic
Posts: 4
Joined: Mon Apr 02, 2012 10:43 am

Re: Read comment value from Excel Ranorex.Cell

Post by srdjan.bogojevic » Mon Apr 02, 2012 2:00 pm

Perfect,
Thanks