Tutorial by Examples

int DVRowLimit = (Int16.MaxValue); CellRangeAddressList cellRangeFieldsType1 = new CellRangeAddressList(1, DVRowLimit, targetFirstCol, targetLastCol); XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateDateConstraint(OperatorType.BET...

dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateTimeConstraint(OperatorType.BETWEEN, "=TIME(0,0,0)", "=TIME(23,59,59)");

dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateExplicitListConstraint(new string[] { "MON", "TUE" , "WED", "THU", "FRI"});

//try same approach for currency types with format like "$#,###.00"and date "m/d/yy h:mm" XSSFFont defaultFont = (XSSFFont)workbook.CreateFont(); defaultFont.FontHeightInPoints = (short)10; defaultFont.FontName = "Arial"; XSSFCellStyle phoneCellStyle = (XSSFCellStyl...

string emailValidationFormula = GetEmailValidationFormula(targetFirstCol); CellRangeAddressList cellRangeFieldsType5 = new CellRangeAddressList(1, DVRowLimit, targetFirstCol, targetLastCol); dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateCustomConstraint(emailValidation...