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