We have optimized method for numbers and not for DateTime, NumberFormat in 11.4. The below code snippets illustrates on how to achieve this. Kindly try this at your end.
sheet.SetNumber(1, 1, 4);
We have optimized method for numbers and date in our upcoming release 12.1m which will be rolled out by this week.
DateTime time = DateTime.Now;
IMigrantRange range = sheet.MigrantRange;range.ResetRowColumn(1,1);
2.Styling of Rows and Columns:
We have optimized way to apply the styles for rows and columns. The below code snippets illustrates on how to achieve this. Kindly try this at your end.
IStyle rowStyle = workbook.Styles.Add("RowStyleFormatterContent");
sheet.UsedRange.CellStyle = rowStyle;
Note: No need of using SetRow height method while using AutoFitRows method.