CalculateAutoFitWidth(Int32,Int32) Method

Returns the width required for the column to display all of the contents for the specified range of rows.

Syntax

Visual Basic

'Declaration
 
Public Overloads Function CalculateAutoFitWidth( _
   ByVal startRowIndex As Integer, _
   ByVal endRowIndex As Integer _
) As Integer

C#

public int CalculateAutoFitWidth( 
   int startRowIndex,
   int endRowIndex
)

Parameters

startRowIndex

A 0-based index of the first row whose contents are to be calculated

endRowIndex

A 0-based index of the last row whose contents are to be calculated

Return Value

The width needed for the column to display the contents of the rows in the specified range. The value is the same units as used for the Width property.

Exceptions

Exception	Description
System.InvalidOperationException	The column is not associated with a Worksheet such as when the column has been deleted or the Worksheet is not associated with a Workbook such as when the Worksheet has been deleted.
System.ArgumentOutOfRangeException	The startRowIndex must be greater than or equal to 0, less than or equal to the endRowIndex and less than or equal to the Count of the Rows in the Worksheet. Similarly the endRowIndex must be greater than or equal to the startRowIndex and less than the WorksheetRowCollection.MaxCount of the Worksheet's Rows collection which depends upon the CurrentFormat

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, 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