AutoFit Method (ColumnRange)

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

Syntax

Visual Basic
C#

'Declaration

 

Public Overrides 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 ColumnRange

Dim minimumWidth As Double

Dim maximumWidth As Double

Dim startRowId As Integer

Dim endRowId As Integer

 

instance.AutoFit(minimumWidth, maximumWidth, startRowId, endRowId)

public override 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 specified column. The default value is 1048575 (the last row Id in a column).

Example

using( var workbook = Workbook.Load( "test.xlsx" ) )

  {

    // Get the first worksheet. A workbook contains at least 1 worksheet.

    var worksheet = workbook.Worksheets[ 0 ];



        

    // AutoFit the columns "I" to "P", from 6th and going down, and making sure the column's widths are between 0 and 255.

    worksheet.Columns[ "I","P" ].AutoFit( 0, 255, 5);



    // Save workbook to disk.

    workbook.SaveAs( CellSample.CellSampleOutputDirectory + @"SetFormulas.xlsx" );

  }

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

ColumnRange Class
ColumnRange Members
Base Implementation in AutoFit