private void WriteText(double value, CellIndex startCellIndex, int cellCount, Alignment alignment)
{
var cultureInfo = CultureInfo.GetCultureInfo("en-US");
var text = value.ToString("F2", cultureInfo);
WriteText(text, startCellIndex, cellCount, alignment);
}
private void WriteToCell(double value, CellIndex cellIndex)
{
var cultureInfo = CultureInfo.GetCultureInfo("en-US");
var text = value.ToString(cultureInfo);
WriteToCell(text, cellIndex);
}
private void WriteText(string text, CellIndex startCellIndex, int cellCount, Alignment alignment)
{
var spaceCount = Math.Max(cellCount - text.Length, 0);
var spaces = Enumerable.Repeat(' ', spaceCount);
var textChars = text.ToCharArray();
var chars = alignment == Alignment.Left
? Enumerable.Concat(textChars, spaces)
.ToList()
: Enumerable.Concat(spaces, textChars)
.ToList();
for (int i = 0; i < chars.Count; i++)
{
var symbol = chars[i];
int rowIndex = startCellIndex.Row;
int columnIndex = startCellIndex.Column + i;
_workSheet.Cells[rowIndex, columnIndex] = symbol.ToString();
}
}
private void WriteText(int value, CellIndex startCellIndex, int cellCount, Alignment alignment)
{
WriteText(value.ToString(), startCellIndex, cellCount, alignment);
}
private void WriteToCell(string text, CellIndex cellIndex)
{
_workSheet.Cells[cellIndex.Row, cellIndex.Column] = text;
}
