I am attaching test file. In this file I have range with name “t1_lock”.
When i am trying to get data from this name then Aspose return NULL.
It did not find this range.
Range[] ranges = workbook.Worksheets.GetNamedRanges(); //test
string rTemp = string.Empty;
foreach (var rr in ranges)
{
rTemp = rr.Name;
}
//or by name
Range rangelocked = workbook.Worksheets.GetRangeByName(“t1_lock”);
Please use the Workbook.Worksheets.Names property for your needs. Please see the following screenshot that shows your mentioned named range for your reference.
Good to know that your issue is sorted out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.