Summary rows are group header rows displaying the group names with complete information about an existing group. Corresponding to each group, a summary row is automatically created when a user executes the grouping operation in a spreadsheet.

With DsExcel Java, you can modify and customize the summary row based on your requirements by using the setSummaryRow method of the IOutline interface.

In order to set summary row, refer to the following example code.

// Summary
worksheet.getOutline().setSummaryRow(SummaryRow.Above);

// Summary row will be row 4.
worksheet.getRange("5:20").group();
// Summary row will be row 14.
worksheet.getRange("15:20").group();