Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / RowRange Class / AutoFit Method
Example


In This Topic
    AutoFit Method (RowRange)
    In This Topic
    Adjusts the Height based on the highest Cell in the RowRange
    Overload List
    OverloadDescription
    Identifies the start & end of the range affected by the AutoFit process by using Ids.  
    Identifies the start & end of the range affected by the AutoFit process by using string Ids.   
    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 rows "I" to "P", from 6th and going right, and make sure the row's heights are between 0 and 409.
    
        worksheet.Rows[ "I","P" ].AutoFit( 0, 255, 5);
    
        // Save workbook to disk.
        workbook.Save();
      }
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also