public void DeleteWorksheetRangeContents(Excel.Worksheet worksheet, string range, ReferenceEnum referenceType = ReferenceEnum.ByName) { if (referenceType == ReferenceEnum.ByName) { worksheet.DeleteRangeContents(range); } else if (referenceType == ReferenceEnum.ByIndex) { worksheet.DeleteRangeContents(range, false); } }