internal CellRead TryReadColumnInfo(int index) { var cell = ActiveWorksheet.Cell(CurrentRowIndex, index); return(new CellRead() { Type = cell.DataType, Value = cell.Value ?? null }); }
private void WriteHeaders() { foreach (var column in Columns) { var cell = ActiveWorksheet.Cell(CurrentRowIndex, column.Index); cell.DataType = XLDataType.Text; cell.Value = column.Label; SetCellBackgroundColor(column.Index, column.HeaderBackgroundColor); } CurrentRowIndex++; }
private void WriteContentLines() { foreach (var rowData in DataToExport) { foreach (var column in Columns) { rowData.TryGetValue(column.Label, out var value); var cell = ActiveWorksheet.Cell(CurrentRowIndex, column.Index); cell.Value = value.Value; } CurrentRowIndex++; } foreach (var column in Columns) { ActiveWorksheet.Column(column.Index).AdjustToContents(); } }
private void SetCellBackgroundColor(int columnIndex, Color color) { var cell = ActiveWorksheet.Cell(CurrentRowIndex, columnIndex); cell.Style.Fill.BackgroundColor = XLColor.FromColor(color); }