C1XLBook1.Load("..\..\InputFile.xlsx")
ForEach nr As XLNamedRange In C1XLBook1.NamedRanges
If nr.Name.StartsWith("Print_Area") Then
System.Diagnostics.Debug.WriteLine(nr.Name + nr.CellRanges.ToString())
EndIfNext
C1XLBook1.Load("..\\..\\InputFile.xlsx");
foreach (XLNamedRange nr in C1XLBook1.NamedRanges)
{
if (nr.Name.StartsWith("Print_Area"))
{
System.Diagnostics.Debug.WriteLine(nr.Name + nr.CellRanges.ToString());
}
}