CalculateAutoFitWidth(Int32,Int32) Method

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

Syntax

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: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+