Syntax
| Visual Basic (Declaration) | |
|---|---|
Sub AutoFit() | |
| C# | |
|---|---|
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 Basic | 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() | |
Remarks
When 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
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family