Worksheet specific named ranges

Aspose.Cells Product Family
1

I see in http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/named-ranges.html 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

2

Hi,

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");
workbook.Save("c:\\Ranges.xls");

Thank You & Best Regards,