/// <summary> /// Adds a column with the specified fixed width. /// </summary> /// <param name="sheetData">The sheet data.</param> /// <param name="width">The width.</param> /// <returns> /// The new column. /// </returns> public static Column AddColumn(this SheetData sheetData, double width) { var worksheet = (Worksheet)sheetData.Parent; var columns = worksheet.GetFirstChild <Columns>(); if (columns == null) { columns = new Columns(); worksheet.InsertBefore <Columns>(columns, sheetData); } uint columnIndex = (uint)sheetData.GetColumnCount() + 1; var column = new Column { CustomWidth = new BooleanValue(true), Max = columnIndex, Min = columnIndex, Width = new DoubleValue(width), }; columns.Append(column); return(column); }