.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Worksheet.DefaultColumnWidthInPixels Property

Gets or sets the default column width in pixels.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll


int DefaultColumnWidthInPixels { get; set; }
Property DefaultColumnWidthInPixels As Integer

Property Value

Type Description

An integer value that is a column width in pixels.


Use the DefaultColumnWidthInPixels, Worksheet.DefaultColumnWidthInCharacters or Worksheet.DefaultColumnWidth property to set the width of worksheet columns whose width is not specified explicitly. If you need to set the width of all columns on the worksheet to the same value and override all previously applied column width settings, use the CellRange.ColumnWidth property of the Row object corresponding to any row on a worksheet.

For information on how to change the height of worksheet rows, see the How to: Specify Row Height or Column Width example.


This example demonstrates how to control the column width on a worksheet.

// Set the "B" column width to 30 characters of the default font that is specified by the Normal style.
worksheet.Columns["B"].WidthInCharacters = 30;

// Set the "C" column width to 15 millimeters.
workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;
worksheet.Columns["C"].Width = 15;

// Set the width of the column that contains the "E15" cell to 100 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.Cells["E15"].ColumnWidth = 100;

// Set the width of all columns that contain the "F4:H7" cell range (the "F", "G" and "H" columns) to 70 points.
worksheet.Range["F4:H7"].ColumnWidth = 70;

// Set the "J" column width to the "B" column width value.
worksheet.Columns["J"].Width = worksheet.Columns["B"].Width;

// Copy the "C" column width value and assign it to the "K" column width.
worksheet.Columns["K"].CopyFrom(worksheet.Columns["C"], PasteSpecial.ColumnWidths);

// Set the default column width to 40 pixels.
worksheet.DefaultColumnWidthInPixels = 40;
See Also