Set Row Height and Column Width

You can set the height of the rows and the width of the columns in a worksheet as per your preferences by using the IRange.UseStandardHeight property and IRange.UseStandardWidth property of the IRange interface respectively.

You can use the IRange.ColumnWidth property to set custom width in characters for the individual columns of a range. In order to set custom width in pixels, you can use the IRange.ColumnWidthInPixel property of the IRange interface.

You can also set custom height of the individual rows of a range in points and in pixels by using the IRange.RowHeight property and IRange.RowHeightInPixel property of the IRange interface.

In order to specify custom total height and total width, you can use the IRange.Height (in points), IRange.HeightInPixel (in pixels), IRange.Width (in characters) and IRange.WidthInPixel (in pixels) properties of the IRange interface.

Refer to the following example code in order to customize the row height and column width in a worksheet.

//set row height for row 1:2.
worksheet.Range["1:2"].RowHeight = 50;

//set column width for column C:D.
worksheet.Range["C:D"].ColumnWidth = 20;