Access cell by cell name (Alias)

Aspose.Cells Product Family
1

Sorry, I previously posted this to the wrong forum.

Is it possible to specify a cell by it's alias? I do not mean the column letter concatinated with the row letter, ie. "K3". I would like to specify the cell by the alias that has been assigned to the cell in the Name Box.

For example instead of
cells("K3").PutValue(150)

I would like to use
cells("GreenHigh1").PutValue(150)

"GreenHigh1" is the alias that I assigned to the cell "K3" by typing in the Excel Name Box.

Thanks

2

I did some experimenting and with a hint from another post discovered how to access the cell using it's alias.

vb.net:

Dim ThisRange As Range = wrkbook.Worksheets.GetRangeByName("GreenHigh1")
ThisRange(0, 0).PutValue(150)

3

Hi,

Please create a range of single cell and give it a name whatever you like. Then access it using this code.

workbook.Worksheets.GetRangeByName()