officefileapi-devexpress-dot-spreadsheet-dot-row-b2f89281.md
Gets or sets the row height.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
double Height { get; set; }
Property Height As Double
| Type | Description |
|---|---|
| Double |
The row height in measurement units defined by the Workbook.Unit property.
|
| Type | Description |
|---|---|
| ArgumentException |
Occurs if the row height exceeds 409 points.
|
This example demonstrates how to control the row height in a worksheet.
Use the Row.Height or CellRange.RowHeight property to set the row height in the workbook’s measurement units.
Note
If the row height is set to 0, the row is hidden. You can also use the Row.Visible property to hide a row or display the hidden row again.
To automatically change the row height to fit the contents, use the row’s Row.AutoFit method. To quickly autofit several rows in a worksheet, use the RowCollection.AutoFit method.
Use the SpreadsheetCellOptions.AutoFitMergedCellRowHeight property to enable the AutoFit functionality for rows that have cells merged across.
To match one row height to another, make their Row.Height property values equal.
To set the default height for worksheet rows, use the Worksheet.DefaultRowHeight property. This property does not affect rows with an explicitly specified height.
To change the height of all rows in a worksheet, use the CellRange.RowHeight property of the Column object corresponding to any column in 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;
' 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
The following code snippets (auto-collected from DevExpress Examples) contain references to the Height property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
worksheet.Cells["A2"].Value = "Row 2";
worksheet.Rows["2"].Height = 150;
worksheet.Rows["2"].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
winforms-spreadsheet-use-custom-cell-editors/CS/DevAVInvoicing/Form1.cs#L185
sheet.Rows.Insert(rowIndex);
sheet.Rows[rowIndex].Height = sheet.Rows[rowIndex + 1].Height;
CellRange range = invoiceItems.Range;
worksheet.Cells["A2"].Value = "Row 2";
worksheet.Rows["2"].Height = 50;
worksheet.Rows["2"].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
pic.Placement = Placement.MoveAndSize;
worksheet.Rows[1].Height += 20;
worksheet.Columns["D"].Width += 20;
pic.Placement = Placement.MoveAndSize;
worksheet.Rows[5].Height += 10;
worksheet.Columns["D"].Width += 10;
worksheet.Cells("A2").Value = "Row 2"
worksheet.Rows("2").Height = 150
worksheet.Rows("2").Alignment.Vertical = SpreadsheetVerticalAlignment.Center
winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L172
sheet.Rows.Insert(rowIndex)
sheet.Rows(rowIndex).Height = sheet.Rows(rowIndex + 1).Height
Dim range As CellRange = invoiceItems.Range
worksheet.Cells("A2").Value = "Row 2"
worksheet.Rows("2").Height = 50
worksheet.Rows("2").Alignment.Vertical = SpreadsheetVerticalAlignment.Center
pic.Placement = Placement.MoveAndSize
worksheet.Rows(1).Height += 20
worksheet.Columns("D").Width += 20
pic.Placement = Placement.MoveAndSize
worksheet.Rows(5).Height += 10
worksheet.Columns("D").Width += 10
See Also