Worksheet specific named ranges

I see in that I can get the specified named range of a workbook but what if I want to find a sheet specific named range? is there a way to do that?

so instead of looking at all the worksheets.

//Getting the specified named range

Range range = workbook.Worksheets.GetRangeByName("TestRange");

I want to look at 1 specific worksheet as the same named range may be in several worksheets in the workbook


Thank you for considering Aspose.

Well, in case of sheet specific named ranges, you can get the range by using the same method

workbook.Worksheets.GetRangeByName(“Sheet1!TestRange”), but you have to make sure that when the

sheet specific range is created , it should also use the sheet name as prefix. Please see the following
sample code,

Sample Code:

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//Create a named range
Range range = sheet.Cells.CreateRange("B1", "E5");
//Set the name of the named range
range.Name = sheet.Name + "!" + "TestRange";
//Get the sheet specific range and assign to range 2
Range range2 = workbook.Worksheets.GetRangeByName(sheet.Name+"!" + "TestRange");

Thank You & Best Regards,