private void AddCellFormats(Stylesheet stylesheet) { var cellWriters = BaseExcelCellWriter.GetAllCellWriters().ToList(); var cellWritersCount = cellWriters.Count; var cellFormatsCount = cellWritersCount + 1; var cellFormats = new CellFormats() { Count = (UInt32)cellFormatsCount }; cellFormats.Append(new CellFormat()); for (int index = 1; index <= cellWritersCount; index++) { var excelCellFormat = (ExcelCellFormat)index; var excelCellFormatAttribute = BaseExcelCellWriter.GetExcelFormatMemberAttribute(excelCellFormat); var numberFormat = excelCellFormatAttribute.NumberFormat; var applyNumberFormat = excelCellFormatAttribute.ApplyNumberFormat; var templateCellFormat = excelCellFormat == ExcelCellFormat.Header ? _tplHeaderCellFormat : _tplValueCellFormat; var cellFormat = GetCellFormat(templateCellFormat, excelCellFormatAttribute); cellFormats.Append(cellFormat); } stylesheet.Append(cellFormats); }
/// <summary> /// Adds custom formats to <paramref name="stylesheet"/>. /// </summary> /// <param name="stylesheet">Constructing stylesheet.</param> protected virtual void AddCustomFormats(Stylesheet stylesheet) { stylesheet.NumberingFormats = new NumberingFormats { Count = 0 }; var dateTimeNumberFormat = BaseExcelCellWriter.GetExcelFormatMemberAttribute(ExcelCellFormat.DateTime).NumberFormat; AppendFormat(stylesheet, dateTimeNumberFormat, GetDateTimeFormatCode()); var dateNumberFormat = BaseExcelCellWriter.GetExcelFormatMemberAttribute(ExcelCellFormat.Date).NumberFormat; AppendFormat(stylesheet, dateNumberFormat, StringValue.FromString(DateTimeFormat.ShortDatePattern)); }