/// <summary> /// Returns a validation type by <see cref="eDataValidationType"/> /// </summary> /// <param name="type"></param> /// <returns></returns> internal static ExcelDataValidationType GetByValidationType(eDataValidationType type) { switch (type) { case eDataValidationType.Any: return(ExcelDataValidationType.Any); case eDataValidationType.Whole: return(ExcelDataValidationType.Whole); case eDataValidationType.List: return(ExcelDataValidationType.List); case eDataValidationType.Decimal: return(ExcelDataValidationType.Decimal); case eDataValidationType.TextLength: return(ExcelDataValidationType.TextLength); case eDataValidationType.DateTime: return(ExcelDataValidationType.DateTime); case eDataValidationType.Time: return(ExcelDataValidationType.Time); case eDataValidationType.Custom: return(ExcelDataValidationType.Custom); default: throw new InvalidOperationException("Non supported Validationtype : " + type.ToString()); } }
private ExcelDataValidationType(eDataValidationType validationType, bool allowOperator, string schemaName) { Type = validationType; AllowOperator = allowOperator; SchemaName = schemaName; }
/// <summary> /// Returns a validation type by <see cref="eDataValidationType"/> /// </summary> /// <param name="type"></param> /// <returns></returns> internal static ExcelDataValidationType GetByValidationType(eDataValidationType type) { switch (type) { case eDataValidationType.Whole: return ExcelDataValidationType.Whole; case eDataValidationType.List: return ExcelDataValidationType.List; case eDataValidationType.Decimal: return ExcelDataValidationType.Decimal; case eDataValidationType.TextLength: return ExcelDataValidationType.TextLength; case eDataValidationType.DateTime: return ExcelDataValidationType.DateTime; case eDataValidationType.Time: return ExcelDataValidationType.Time; case eDataValidationType.Custom: return ExcelDataValidationType.Custom; default: throw new InvalidOperationException("Non supported Validationtype : " + type.ToString()); } }
// XlsxDataValidation.ValidationType.None has no corresponding representation in EPPlus public static void ValidationType(XlsxDataValidation.ValidationType validationType, eDataValidationType expected) { using (var stream = new MemoryStream()) { using (var xlsxWriter = new XlsxWriter(stream)) xlsxWriter.BeginWorksheet("Sheet 1").BeginRow().AddDataValidation(new XlsxDataValidation(validationType: validationType)); using (var package = new ExcelPackage(stream)) package.Workbook.Worksheets[0].DataValidations[0].ValidationType.Type.Should().Be(expected); } }