Named Range Address

Aspose.Cells Product Family
1

Is there a way to get an excel address from a named Range. When i break on my named range object in Visual Studio i can see in the Non Public Members that there is a property with the string value of A4:D8. But i cannot seem to find a way to get it.


A round about way i currently have is to get the first cell and then the last cell and get the name from each cell and concatenate them into a string for my use. There should be a much easier way to get to this address as a property from the Range object.

Thanks,
Mark
2

Hi,

You can find all the named ranges using the following code.

C#


Range[] allRanges=workbook.Worksheets.GetNamedRanges();

3

Sorry that’s not what I’m looking for I can get the named range just fine. But is there and easy way from the named range to gets its excel address like this “A2:B8”.


Example code c#
Range range = MyWorkBook.Worksheets.GetRangeByName(myNamedRange);


string excelAddress = range.Address();
-----------------------------------------------
With the value of excelAddress being “A2:B8”.
4

Hi,

Please use this code to get the address of the given range.

C#


string startCell = CellsHelper.CellIndexToName(range.FirstRow, range.FirstColumn);

string endCell = CellsHelper.CellIndexToName(range.FirstRow + range.RowCount - 1, range.FirstColumn + range.ColumnCount - 1);


string address = startCell + “:” + endCell;

5

Hi,


Moreover, you may also try to perform your desired task,
e.g
Sample code:

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(“e:\test\Test.xls”);
//Browse All the Named RangeCollection in the workbook
foreach (Range range in workbook.Worksheets.GetNamedRanges())
{
string name = range.Name;
string address = workbook.Worksheets.Names[name].RefersTo;
}
6

workbook.Worksheets.Names[name].RefersTo;


Now this might be the thing im looking for. I will test this out!

Thanks very much i knew there had to be a way to get just the string address without getting start and end cells. I was already doing that as a work around so the previous post was of no use.