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”);
paRangeTest.zip (5.6 KB)