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);
}
