To match one row height to another, make their Row.Height property values equal.

Set the Default Row Height

To set the default height for worksheet rows, use the Worksheet.DefaultRowHeight property. This property does not affect rows with an explicitly specified height.

Set the Height for All Rows on a Worksheet

To change the height of all rows on a worksheet, use the Range.RowHeight property of the Column object corresponding to any column on a worksheet. This sets the height of all rows to the same value, overriding all previously applied row height settings.

// Set the height of the 3rd row to 50 points
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.Rows[2].Height = 50;
// Set the height of the row that contains the "C5" cell to 2 inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch;
worksheet.Cells["C5"].RowHeight = 2;
// Set the height of the 7th row to the height of the 3rd row.
worksheet.Rows["7"].Height = worksheet.Rows["3"].Height;
// Set the default row height to 30 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.DefaultRowHeight = 30;

RowAndColumnActions.vb

' Set the height of the 3rd row to 50 points
workbook.Unit = DevExpress.Office.DocumentUnit.Point
worksheet.Rows(2).Height = 50
' Set the height of the row that contains the "C5" cell to 2 inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch
worksheet.Cells("C5").RowHeight = 2
' Set the height of the 7th row to the height of the 3rd row.
worksheet.Rows("7").Height = worksheet.Rows("3").Height
' Set the default row height to 30 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point
worksheet.DefaultRowHeight = 30

Column

This example demonstrates how to control the column width on a worksheet.

To set a column width in other measurement units, first set the IWorkbook.Unit property to the DocumentUnit enumeration member that corresponds to the desired units, then use the column's Column.Width property, or the Range.ColumnWidth property of the cell or cell range object.

To change the width of all columns on a worksheet, use the Range.ColumnWidthInCharacters or Range.ColumnWidth property of the Row object corresponding to any row on a worksheet. This sets the width of all columns to the same value, overriding all previously applied column width settings.