Search code examples
excelgroupingepplus

EPPlus - group row


EPPlus 4.0.4.0 how to set the line grouping? I have to get as attached photo. Thank you!

Settings:


Solution

  • I do not know Italian but assuming you mean the option for "Summary Rows Below Details" here is how you turn it on for a Worksheet:

    using (var package = new ExcelPackage(fileinfo))
    {
        var workbook = package.Workbook;
        var worksheet = workbook.Worksheets.First();
        worksheet.OutLineSummaryBelow = true;
    }