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