AutoFit Method (ColumnCollection)

Adjusts the columns’ width based on the cell with the widest content within the ColumnRange.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub AutoFit( _
   Optional ByVal minimumWidth As Double, _
   Optional ByVal maximumWidth As Double, _
   Optional ByVal startRowId As Integer, _
   Optional ByVal endRowId As Integer _
)

'Usage
 
Dim instance As ColumnCollection
Dim minimumWidth As Double
Dim maximumWidth As Double
Dim startRowId As Integer
Dim endRowId As Integer
 
instance.AutoFit(minimumWidth, maximumWidth, startRowId, endRowId)

public void AutoFit( 
   double minimumWidth,
   double maximumWidth,
   int startRowId,
   int endRowId
)

Parameters

minimumWidth: The minimum desired width when autoFitting a column. The default value is 0.
maximumWidth: The maximum desired width when autofitting a column. The default value is 255.
startRowId: The Id for the row from where to start calculating the cells content width in the specified column. The default value is 0 (the first row Id in a column).
endRowId: The Id for the row from where to end calculating the cells content width in the column. The default value is 1048575 (the last row Id in a column).

Example

using( var workbook = Workbook.Create( "test.xlsx" ) )
  {
    // Get the first worksheet. A workbook contains at least 1 worksheet.
    var worksheet = workbook.Worksheets[ 0 ];

    worksheet.Cells[ "D6" ].Value = "This column has an autoFit.";
    worksheet.Columns[ "D" ].AutoFit();

    // Save workbook to disk.
    workbook.Save();
  }

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

ColumnCollection Class
ColumnCollection Members