ColumnCollection.AutoFit(String, String) Method

Adjusts column widths to fit the cell content.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void AutoFit(
    string firstColumnHeading,
    string lastColumnHeading
)

VB.NET

Sub AutoFit(
    firstColumnHeading As String,
    lastColumnHeading As String
)

Parameters

Name	Type	Description
firstColumnHeading	String	The heading of the first column to resize.
lastColumnHeading	String	The heading of the last column to resize.

Remarks

The method’s firstColumnHeading and lastColumnHeading parameters require column headings in the A1 reference style.

C#

worksheet.Columns.AutoFit("B", "D");

VB.NET

worksheet.Columns.AutoFit("B", "D")

Use the Column.AutoFit method to change a single column’s width to fit its content.

See how to specify the row height and column width.