Hi Lukas,
Thank
you for considering Aspose.
Well, you can use
Name.GetRanges() API to get all the ranges in a non-sequenced named range. Please
check the following sample code and see if it fits your requirement.
Sample Code:
Workbook workbook = new Workbook();
int index =
workbook.Worksheets.Names.Add("NonSequencedRange");
Name name =
workbook.Worksheets.Names[index];
name.RefersTo
= "=Sheet1!$A$1:$B$3,Sheet1!$D$5:$E$6";
name = workbook.Worksheets.Names["NonSequencedRange"];
Range[]
ranges = name.GetRanges();
if (ranges != null)
{
for (int i = 0; i < ranges.Length; i++)
{
MessageBox.Show(ranges[i].FirstRow
+ ":" + ranges[i].FirstColumn);
}
}
Thank You &
Best Regards,