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 void ClearNamedRange(this Excel.Worksheet worksheet, string name)
{
if (worksheet.RangeExists(name))
{
try
{
worksheet.Range[name].Clear();
}
catch (Exception ex)
{
worksheet.DeleteNamedRange(name);
}
}
}
public static Excel.Range CreateNamedRange(this Excel.Worksheet worksheet, string name, string range)
{
Excel.Range namedRange = null;
if (worksheet.RangeExists(name))
{
try
{
namedRange = worksheet.Range[name];
}
catch (Exception ex)
{
worksheet.DeleteNamedRange(name);
}
}
else
{
namedRange = worksheet.Range[range];
namedRange.Name = name;
}
return(namedRange);
}
