private void SetColumnsWidth(IXLRange range, IList <ExcelDynamicColumn> columns) { for (int i = 0; i < columns.Count; i++) { ExcelDynamicColumn column = columns[i]; if (column.Width == null && !column.AdjustToContent) { continue; } if (Type == PanelType.Vertical) { IXLColumn excelColumn = range.Cell(1, i + 1).WorksheetColumn(); if (column.Width != null) { excelColumn.Width = column.Width.Value; } if (column.AdjustToContent) { excelColumn.AdjustToContents(); } } else { IXLRow excelRow = range.Cell(i + 1, 1).WorksheetRow(); if (column.Width != null) { excelRow.Height = column.Width.Value; } if (column.AdjustToContent) { excelRow.AdjustToContents(); } } } }