private static void WriteToXLSX(DataCell[][] cells, string filename)
{
if (File.Exists(filename))
{
File.Delete(filename);
}
var package = new ExcelPackage(new FileInfo(filename));
var sheet = package.Workbook.Worksheets.Add("Content");
foreach (var cell in new ExcelCellEnumerator(cells.GetLength(0), cells.Max(x => x.Length)))
{
var dataRow = cells[cell.Row - 1];
if (cell.Column >= dataRow.Length) continue;
var data = dataRow[cell.Column];
var excelCell = sheet.Cells[cell.Value];
excelCell.Value = data.Content;
switch (data.Type)
{
case DataCellType.HeadingBig:
excelCell.Style.Font.Bold = true;
excelCell.Style.Font.Size = 18;
sheet.Row(cell.Row).Merged = true;
break;
case DataCellType.Heading:
excelCell.Style.Font.Bold = true;
excelCell.Style.Font.Size = 12;
break;
case DataCellType.ResultGood:
XLSXDataSerializer.SetResultCell(excelCell, Color.FromArgb(0xBC, 0xED, 0x91));
break;
case DataCellType.ResultNeutral:
XLSXDataSerializer.SetResultCell(excelCell, Color.FromArgb(0xFF, 0xEC, 0xB3));
break;
case DataCellType.ResultBad:
XLSXDataSerializer.SetResultCell(excelCell, Color.FromArgb(0xFF, 0x8A, 0x65));
break;
case DataCellType.Number:
excelCell.Value = double.Parse(excelCell.Value.ToString().Replace(",", "."),
CultureInfo.InvariantCulture);
break;
}
if (data.Outline.HasFlag(DataCellOutline.Top))
{
excelCell.Style.Border.Top.Style = ExcelBorderStyle.Medium;
excelCell.Style.Border.Top.Color.SetColor(Color.Black);
}
if (data.Outline.HasFlag(DataCellOutline.Bottom))
{
excelCell.Style.Border.Bottom.Style = ExcelBorderStyle.Medium;
excelCell.Style.Border.Bottom.Color.SetColor(Color.Black);
}
if (data.Outline.HasFlag(DataCellOutline.Left))
{
excelCell.Style.Border.Left.Style = ExcelBorderStyle.Medium;
excelCell.Style.Border.Left.Color.SetColor(Color.Black);
}
if (data.Outline.HasFlag(DataCellOutline.Right))
{
excelCell.Style.Border.Right.Style = ExcelBorderStyle.Medium;
excelCell.Style.Border.Right.Color.SetColor(Color.Black);
}
}
for (var i = 1; i < cells.Max(x => x.Length); i++)
{
sheet.Cells[2, i, sheet.Dimension.Rows, i].AutoFitColumns(10.71);
// 10.71 represents the default excel cell width, we do not want to go below that
}
package.Save();
package.Dispose();
}
