Clear all named range in INameRanges at once

[sxlsgs]

Hi team,

Are there any ways to neatly clear all named ranged defined in INameRanges enumerator?

We found that in INameRanges, it contains Remove(string name) and RemoveAt(int index) to remove the named range one by one.

But we would like to remove all named range at once. And seems it's not an appropriate approach to iterate the ranges and remove then inside the iteration.

Thanks!

[Nina.Tang]

Hello,

Thanks for your contact.
Sorry there is no way to remove all named range at once, you could use the RemoveAt to remove the named range in turn, sample code is given as below:

Code: Select all

for (int i = workBook.NameRanges.Count-1; i >=0; i--)
{
      workBook.NameRanges.RemoveAt(i);
}


Sincerely,
Nina
E-iceblue support team

[sxlsgs]

Noted, thank you!