Free Support Forum - aspose.com

worksheet.GetFocusedCell

I am using Aspose.Cells.GridDesktop, and I am trying to get the “name” of the selected cell. I have named the cell using “name a range” in excel.

Is it possible to get the “name” of the selected cell w/ the <span style=“font-size: 10pt; font-family: “Courier New”;”>GetFocusedCell method?

<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>Dim<span style=“font-size: 10pt; font-family: “Courier New”;”> worksheet As
GridDesktop.Worksheet = _GridDesktop.GetActiveWorksheet()<o:p></o:p>

Dim cl As GridDesktop.CellLocation = worksheet.GetFocusedCell.Location


Hi,

Well, I am afraid, retrieving named range (created in MS Excel file) is not supported by Aspose.Cells.GridDesktop control. We have logged it into our issue tracking system with an issue id: CELLSNET-15062.

Currently, you may get the focused cell name as “A1”, “B1” etc.


Dim cell As GridCell = worksheet.GetFocusedCell

Dim cname as String = cell.Name



Thank you.