internal override ICellStyle SetCell(ICellStyle cellStyle) { IDataFormat format = Workbook.CreateDataFormat(); cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("¥#,##0"); return(cellStyle); }
internal override ICellStyle SetCell(ICellStyle cellStyle) { IDataFormat format = Workbook.CreateDataFormat(); cellStyle.DataFormat = format.GetFormat("yyyy/mm/dd"); return(cellStyle); }
private CellStyle GetCellStyleForFormat(Workbook workbook, string dataFormat) { if (!this.cellStyleCache.ContainsKey(dataFormat)) { var style = workbook.CreateCellStyle(); // check if this is a built-in format var builtinFormatId = HSSFDataFormat.GetBuiltinFormat(dataFormat); if (builtinFormatId != -1) { style.DataFormat = builtinFormatId; } else { // not a built-in format, so create a new one var newDataFormat = workbook.CreateDataFormat(); style.DataFormat = newDataFormat.GetFormat(dataFormat); } this.cellStyleCache[dataFormat] = style; } return(this.cellStyleCache[dataFormat]); }
protected CellStyle GetDateTimeStyle() { if (Parent != null) { var style = Parent.GetDateTimeStyle(); if (style != null) { return(style); } } if (_dateTimeStyle != null) { return(_dateTimeStyle); } _dateTimeStyle = Workbook.CreateCellStyle(); var format = Workbook.CreateDataFormat(); _dateTimeStyle.DataFormat = format.GetFormat("DD.MM.YYYY"); GetRootParent()._dateTimeStyle = _dateTimeStyle; return(_dateTimeStyle); }
private ICellStyle GetColumnStyle(int index, string format) { if (ColumnStyles.ContainsKey(index)) { return(ColumnStyles[index]); } var cellStyle = Workbook.CreateCellStyle(); if (string.IsNullOrEmpty(format)) { ColumnStyles.Add(index, cellStyle); return(cellStyle); } var cellFormat = Workbook.CreateDataFormat(); cellStyle.DataFormat = cellFormat.GetFormat(format); ColumnStyles.Add(index, cellStyle); return(cellStyle); }
public Cell AddCell(Object value, int columnIndex, Row row, TextStyle textStyle, short backgroundColor, CellBorderType borderStyle, short borderColor) { Cell cell = row.GetCell(columnIndex) ?? row.CreateCell(columnIndex); CellStyle cellStyle = Styles[textStyle]; if (value == null) { cell.SetCellValue(""); } else if (value.GetType() == typeof(DateTime)) { cell.SetCellValue((DateTime)value); cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("m/d/yy"); } else if (value.GetType() == typeof(double) || value.GetType() == typeof(float)) { cell.SetCellValue((double)value); DataFormat format = Workbook.CreateDataFormat(); cellStyle.DataFormat = format.GetFormat("# ### ### ##0.00"); } else if (value.GetType() == typeof(decimal)) { var d = (decimal)value; cell.SetCellValue((double)d); DataFormat format = Workbook.CreateDataFormat(); cellStyle.DataFormat = format.GetFormat("# ### ### ##0.00"); } else if (value.GetType() == typeof(Int16) || value.GetType() == typeof(Int32) || value.GetType() == typeof(Int64) || value.GetType() == typeof(UInt16) || value.GetType() == typeof(UInt32) || value.GetType() == typeof(UInt64) || value.GetType() == typeof(Byte) || value.GetType() == typeof(SByte)) { cell.SetCellValue((int)value); cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("0"); } else if (value.GetType() == typeof(bool)) { cell.SetCellValue((bool)value); } else { cell.SetCellValue(value.ToString()); } if (backgroundColor != short.MinValue) { cellStyle.FillForegroundColor = backgroundColor; cellStyle.FillPattern = FillPatternType.SOLID_FOREGROUND; } if (borderColor != short.MinValue) { cellStyle.BorderBottom = borderStyle; cellStyle.BorderLeft = borderStyle; cellStyle.BorderRight = borderStyle; cellStyle.BorderTop = borderStyle; cellStyle.BottomBorderColor = borderColor; cellStyle.LeftBorderColor = borderColor; cellStyle.RightBorderColor = borderColor; cellStyle.TopBorderColor = borderColor; } cell.CellStyle = cellStyle; return(cell); }