Autofit Rows and Columns in Excel using C#. For further details: https://kb.aspose.com/cells/net/autofit-rows-and-columns-in-excel-using-csharp/

Autofit Rows and Columns in Excel using C#.cs

using System;
using Aspose.Cells;

class Program
{
    static void Main(string[] args) // Autofit Excel file using C#
    {
        new License().SetLicense("License.lic");

        // Load the Excel file
        Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook("autofit.xlsx");

        // Get reference of desired worksheet
        Aspose.Cells.Worksheet worksheet = workbook.Worksheets[0];

        // Auto fit the columns and rows
        worksheet.AutoFitRows(); worksheet.AutoFitColumns();

        // Save workbook
        workbook.Save("autofit-excel.xlsx");

        Console.WriteLine("Done");
    }
}