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