public static void DeleteNamedRange(this Excel.Worksheet worksheet, string name)
{
if (worksheet.RangeExists(name))
{
var namedRange = worksheet.Names().FirstOrDefault(n => n.Name == name);
if (namedRange != null)
{
namedRange.Delete();
}
}
}
public static List <string> NamedRanges(this Excel.Worksheet workSheet)
{
return(workSheet.Names().Select(n => n.Name).ToList());
}
