How to set column width and row height?

1 min read

Column width and row height of spreadsheet can be modified using XlsIO. Here is the code snippet.

// Changing the Column Width
sheet.Range["A1"].ColumnWidth = 20;
// Changing the Row Height
sheet.Range["A2"].RowHeight = 20;

' Changing the Column Width
sheet.Range("A1").ColumnWidth = 20
' Changing the Row Height
sheet.Range("A2").RowHeight = 20

Here is the sample for your reference:

Did you find this information helpful?

Yes

Comments