/// <summary> /// Add a new sheet to the collection. Replace if already exists. /// </summary> /// <param name="sheets"></param> /// <param name="name"></param> /// <returns></returns> public static ExcelWorksheet AddOrReplace(this ExcelWorksheets sheets, string name) { if (sheets.Any(x => StringComparer.OrdinalIgnoreCase.Equals(x.Name, name))) { sheets.Delete(name); } return(sheets.Add(name)); }
public IResult ValidateExcelPages(ExcelWorksheets excelWorksheets) { IResult result = new Result() { Success = false }; if (!excelWorksheets.Any()) { result.Message = MessageHolder.GetErrorMessage (MessageType.DocumentIsEmpty); return(result); } result.Success = true; return(result); }