officefileapi-devexpress-dot-spreadsheet-dot-column-e912a68b.md
Gets or sets the column width in characters of the default font specified by the built-in Normal style.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
double WidthInCharacters { get; set; }
Property WidthInCharacters As Double
| Type | Description |
|---|---|
| Double |
A Double value that is the number of characters that can be accommodated into the column width when the column is formatted with the built-in Normal style.
|
To automatically fit the column width to the content, call the Column.AutoFit method.
This example demonstrates how to control the column width in a worksheet.
To specify the column width in characters of the default font specified by the built-in Normal style, use the Column.WidthInCharacters or CellRange.ColumnWidthInCharacters property.
To specify the column width in pixels, use the column’s Column.WidthInPixels property.
To set the column width in other measurement units, set the Workbook.Unit property to the required DocumentUnit enumeration member and specify the Column.Width or CellRange.ColumnWidth property.
Note
If the column width is set to 0, the column is hidden. You can also use the Column.Visible property to hide a column or display the hidden column again.
To automatically change the column width to fit the contents, use the columns’s Column.AutoFit method. To quickly autofit several columns in a worksheet, call the ColumnCollection.AutoFit method.
To match one column width to another, you can use the Column.Width property or the CellRange.CopyFrom method of the column object.
To set the default width for worksheet columns, use the Worksheet.DefaultColumnWidthInCharacters, Worksheet.DefaultColumnWidthInPixels or Worksheet.DefaultColumnWidth property. These properties do not affect columns with an explicitly specified width.
To change the width of all columns in a worksheet, use the CellRange.ColumnWidthInCharacters or CellRange.ColumnWidth property of the Row object corresponding to any row in a worksheet. This sets the width of all columns to the same value, overriding all previously applied column width settings.
// 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;
' 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
The following code snippets (auto-collected from DevExpress Examples) contain references to the WidthInCharacters property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Columns[0].WidthInCharacters = 2;
worksheet["E6"].Value = "Mike Hamilton";
winforms-spreadsheetcontrol-api-part1/CS/SpreadsheetControl/SpreadsheetActions/CellActions.cs#L112
worksheet.Cells["A10"].Value = "Fill a range of cells:";
worksheet.Columns["A"].WidthInCharacters = 20;
worksheet.Columns["B"].WidthInCharacters = 20;
workbook.Worksheets.ActiveWorksheet = worksheet;
worksheet.Columns["A"].WidthInCharacters = 40;
worksheet.Cells["A10"].Value = "Fill a range of cells:";
worksheet.Columns["A"].WidthInCharacters = 20;
worksheet.Columns["B"].WidthInCharacters = 20;
winforms-spreadsheet-how-to-edit-rich-text/CS/SpreadsheetRichText/Form1.cs#L24
worksheet["B5"].Alignment.WrapText = true;
worksheet.Columns[1].WidthInCharacters = 50;
}
Dim worksheet As Worksheet = workbook.Worksheets(0)
worksheet.Columns(0).WidthInCharacters = 2
worksheet("E6").Value = "Mike Hamilton"
winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/CellActions.vb#L106
worksheet.Cells("A10").Value = "Fill a range of cells:"
worksheet.Columns("A").WidthInCharacters = 20
worksheet.Columns("B").WidthInCharacters = 20
workbook.Worksheets.ActiveWorksheet = worksheet
worksheet.Columns("A").WidthInCharacters = 40
worksheet.Cells("A10").Value = "Fill a range of cells:"
worksheet.Columns("A").WidthInCharacters = 20
worksheet.Columns("B").WidthInCharacters = 20
winforms-spreadsheet-how-to-edit-rich-text/VB/SpreadsheetRichText/Form1.vb#L18
worksheet("B5").Alignment.WrapText = True
worksheet.Columns(1).WidthInCharacters = 50
End Sub
See Also
How to: Specify Row Height or Column Width