private IEnumerable <AristotleExcelStyle> SetNewAssetsDetailColumnFormatProperties() { var _list = new List <AristotleExcelStyle>(); var _columnStyle = new AristotleExcelStyle() { ColumnNumber = 4, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 5, Format = "YYYY-mm-dd", ColumnWidth = 18, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 13, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 14, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 15, Format = "#0.000000", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 16, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); return(_list); }
private IEnumerable <AristotleExcelStyle> SetOngoingSummaryColumnFormatProperties() { var _list = new List <AristotleExcelStyle>(); var _columnStyle = new AristotleExcelStyle() { ColumnNumber = 2, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 3, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 4, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 5, Format = "#0.000000", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 6, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); return(_list); }
private IEnumerable <AristotleExcelStyle> SetOngoingDetailColumnFormatProperties() { var _list = new List <AristotleExcelStyle>(); var _columnStyle = new AristotleExcelStyle() { ColumnNumber = 8, Format = "YYYY-MM-DD", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 9, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 10, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 11, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 12, Format = "#0.000000", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 13, Format = "#0.000000", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); _columnStyle = new AristotleExcelStyle() { ColumnNumber = 14, Format = "#,##0.00", ColumnWidth = 25, FontColor = Color.Black }; _list.Add(_columnStyle); return(_list); }