示例#1
0
        /// <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);
        }