Hi.
How I can create named range with separated two or more ranges.
Like Excel it do
=Sheet1!$B$3:$B$10;Sheet1!$D$3:$D$10;Sheet1!L1:N5
I didn't found API for this.
com.aspose.cells.Range can present only one range.
Can you help me asap with it ?
Additionally if Excel document contains named range with splitted ranges (see attachments),
Method workbook.getWorksheets().getNamedRanges()
doesn't return this range.
Hi,
You may use Name object to create non sequential ranges (separated by two or more ranges), see the document for your reference:
(Note: the document used the .NET APIs but you may easily convert it to JAVA code using Aspose.Cells for JAVA APIs, we will add the similar document to Aspose.Cells for Java Wiki Conf. Docs soon.)
PS. We have added the similar document in Aspose.Cells for Java Wiki Conf. Docs for your reference:
Thank you.