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);
}