Auto Adjust Rows & Columns Size

VB C#

using IronXL;

// Load existing spreadsheet
WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Apply auto resize on row 2
workSheet.AutoSizeRow(1);

// Apply auto resize on column A
workSheet.AutoSizeColumn(0);

// Apply auto resize on column D
workSheet.AutoSizeColumn(3, true);

workBook.SaveAs("autoResize.xlsx");

Imports IronXL

' Load existing spreadsheet
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Apply auto resize on row 2
workSheet.AutoSizeRow(1)

' Apply auto resize on column A
workSheet.AutoSizeColumn(0)

' Apply auto resize on column D
workSheet.AutoSizeColumn(3, True)

workBook.SaveAs("autoResize.xlsx")

Install-Package IronXL.Excel

Auto Adjust Rows & Columns Size

Resizing rows and columns in spreadsheet can save a lot of space and making it more readable. IronXL C# library have the functionality to auto resize rows and columns. Since it is done in C#, the resize methods can be called upon all the existing rows and columns. Hence, automating the manual task in spreadsheet.

Auto Resize Rows

The AutoSizeRow method automatically resize the height of specified row based on its value length. Another overload of AutoSizeRow takes the second parameter as Boolean value. If true, the height of merged cells will be considered.

Auto Resize Columns

Use AutoSizeColumn method resize the width of column(s) based on its value length. Similar to AutoSizeRow, it is also possible to make the resizing of column consider the width of merged cell.

Please note that all the row and column position mentioned above follows zero-based indexing.