public void Run()
{
AllValuesAreOfSameType();
//// set headers
//Sheet.Row(Row).Style.Font.Bold = true;
foreach (var _object in Objects)
{
var mergeDef = ExcelSerializer.GetRange(Row, Column, Row + 1, Column);
Sheet.Cells[mergeDef].Merge = true;
Sheet.Cells[Row, Column].Value = _object.Key;
Sheet.Cells[Row, Column].Style.Font.Bold = true;
Sheet.Cells[Row, Column].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
var dvw = new DirectValueWriter(_object.Value.Value as Dictionary <string, ObjectWrapper>, Sheet, Row, Column + 1);
dvw.Run();
Row += 2;
UpdatedColumns.Add(Column);
}
foreach (var updatedColumnIndex in UpdatedColumns)
{
Sheet.Column(updatedColumnIndex).AutoFit();
}
}
public void Run()
{
AllValuesAreOfSameType();
foreach (var _object in ObjectLists)
{
var objectList = _object.Value.Value as List <object>;
if (!objectList.Any())
{
continue;
}
var mergeDef = ExcelSerializer.GetRange(Row, Column, Row + objectList.Count, Column);
Console.WriteLine(mergeDef);
Sheet.Cells[mergeDef].Merge = true;
Sheet.Cells[Row, Column].Value = _object.Key;
Sheet.Cells[Row, Column].Style.Font.Bold = true;
Sheet.Cells[Row, Column].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
foreach (var item in objectList)
{
var dvw = new DirectValueWriter(as Dictionary <string, ObjectWrapper>, Sheet, Row, Column + 1, false);
dvw.Run();
}
Row += objectList.Count;
Row += 1;
UpdatedColumns.Add(Column);
}
foreach (var updatedColumnIndex in UpdatedColumns)
{
Sheet.Column(updatedColumnIndex).AutoFit();
}
}
public void Run()
{
AllValuesAreDirectValues();
// set headers
Sheet.Row(Row).Style.Font.Bold = true;
foreach (var directValue in DirectValues)
{
if (WriteHeader)
{
Sheet.Cells[Row, Column].Value = directValue.Key;
}
Sheet.Cells[Row + 1, Column].Value = directValue.Value.Value;
UpdatedColumns.Add(Column++);
}
foreach (var updatedColumnIndex in UpdatedColumns)
{
Sheet.Column(updatedColumnIndex).AutoFit();
}
}
