Hi guys,
i have a question about “ranges”.
In the propery “worksheet” i have the function “GetSelectedRanges”, to obtain the active ranges and a property “Names” for named ranges.
I’m still looking for a function “GetSelectedNames” to find the active named ranges.
In my case is only “TestNamend2” marked and I need a possibility to get out what named ranges are selected.
I have my test document attached.
Thank you for your support.
Hi,
- CELLSNET-45200 - GetSelectedNames() method needed to find the selected named ranges
}//end main
private static string GetDefinedName(Range[] ranges, Range sRange)
{
for (int i = 0; i < ranges.Length; i++)
{
Range range = ranges[i];
if (range.Worksheet == sRange.Worksheet)
{
if (range.FirstRow == sRange.FirstRow
&& range.FirstColumn == sRange.FirstColumn
&& range.ColumnCount == sRange.ColumnCount
&& range.RowCount == sRange.RowCount)
{
return range.Name;
}
}
}
return null;
}//end getdefinedname
Hi,
thanks for your solution.
It would be nice if this functionality was already included in a method “GetSelectedNamedRanges”. Just like “GetSelectedRanges”.
Thanks for the support
Have a nice day.
Hi,
i still have a problem with more named ranges when i use this solution.
I have selected two named ranges in the excel sheet, but the result is one.
Here my code:
var wbook = GetWorkBook(TestResTemplates.TemplateRanges);
var namedRanges = wbook.Worksheets.GetNamedRanges();
var selectedRanges = wbook.Worksheets[0].GetSelectedRanges();
var results = GetSelectedNamedRanges(namedRanges, selectedRanges);
private List GetSelectedNamedRanges(Range[] namedRanges, ArrayList selectedRanges)
{
var results = new List();
foreach (var range in selectedRanges)
{
var srange = range as Range;
var selectedNamedRanges = namedRanges.Where(n => n.FirstRow == srange.FirstRow && n.FirstColumn == srange.FirstColumn && n.ColumnCount == srange.ColumnCount && n.RowCount == srange.RowCount);
results.AddRange(selectedNamedRanges);
}
return results;
}
My test document is in the appendix.
Thank you for your support.
Hi,
Hi,
thank you for the information and your support.
I’m curious.