Auto-Resize Excel Rows and Columns in C#

VBC#

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
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
Dim 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")

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

Auto-Resize Excel Rows and Columns in C#

Resizing rows and columns in a spreadsheet can save a lot of space and make it more readable. The IronXL C# library has 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, thereby automating the manual tasks in spreadsheets.

Auto Resize Rows

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

Auto Resize Columns

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

Please note that all the row and column positions mentioned above follow zero-based indexing.

Learn How to Auto-Size Excel Rows & Columns with C#

View on GitHub