SpreadsheetGear The Performance Spreadsheet Component Company 
AutoFit Method
See Also  Example
SpreadsheetGear Namespace > IRange Interface : AutoFit Method
Automatically sets the width of the specified columns or the height of the specified rows.

Syntax

C# 
virtual void AutoFit()

Example

C#Copy Code
// Automatically set the width on columns B and C. 
worksheet.Cells["B:C"].Columns.AutoFit(); 
  
// Set the row height to automatic on rows 7 through 9. 
worksheet.Cells["7:9"].Rows.AutoFit(); 
    
Visual BasicCopy Code
' Automatically set the width on columns B and C.
worksheet.Cells("B:C").Columns.AutoFit()

' Set the row height to automatic on rows 7 through 9.
worksheet.Cells("7:9").Rows.AutoFit()

Remarks

Whan IRange.AutoFit is used on columns, the width of the columns is set to the appropriate width immediately. However, for rows, the height is set to the default height and a flag is set indicating that the row height is automatic, and Excel will actually set the height when the row is displayed.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also