.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotLayout.InsertBlankRows() Method

Inserts a blank row after each outer row field item in a pivot table.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll

Declaration

void InsertBlankRows()
Sub InsertBlankRows

Remarks

To insert a blank line after each item of a particular outer row field, set the field's PivotFieldLayout.InsertBlankRowAfterEachItem property to true.

To remove the inserted blank rows, use the PivotLayout.RemoveBlankRows method.

Examples

Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Insert a blank row after each group of items.
pivotTable.Layout.InsertBlankRows()
See Also