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