Regarding removing the Range in Worksheet scope

Aspose.Cells Product Family
1

Hi Team,

How to remove the Range in worksheet scope. If one range is dependent on other range then which range as to remove.

While removing range whether dependent range check is there in 8.3.4 version?

Please suggest me


Thanks & Regards,
Saravanan Mani

2

Hi,


Well, you may use NameCollection.remove() or NameCollection.removeAt() method to remove a named range. For the first method, you will provide complete name (e.g “Sheet1!MyRange”) with respect to its sheet name (if you are removing local named range).

Also while removing a range in an Excel file, there is no check whether the range is used in other range(s), this behavior is same as per Ms Excel, you may confirm this by deleting the ranges in Ms Excel manually.

Thank you.
3

Hi Team,

For one particular Range

When i use NameCollection.remove(I am passing the Sheetname and range name).

After doing above step then name of the range remain same and referTo became null.

Please suggest me

Thanks & Regards,
Saravanan Mani

4

Hi Saravanan,


Please share the spreadsheet in question along with the worksheet & range names that you are trying to remove. By the way, have you tested the case against the latest version of Aspose.Cells for Java 8.6.0.7? If not, please give a try to the latest version first on your end.