public void DeleteWorkbookRangeContents(Excel.Workbook workbook, string range, ReferenceEnum referenceType = ReferenceEnum.ByName) { if (referenceType == ReferenceEnum.ByName) { workbook.DeleteRangeContents(range); } else if (referenceType == ReferenceEnum.ByIndex) { workbook.DeleteRangeContents(range, false); } }