How to have multiple sheets in Excel ActiveReports 7?

  • oehaddouchi 9 months, 2 weeks ago

    I can generate one sheet, but I can’t find a way to generate multiple sheets in one Excel file.

    I tried to use GrapeCity.SpreadBuilder.Workbook but I haven’t found a way to make it work.

    Thanks in advance.

  • 195p
    AbdiasM195p 9 months, 2 weeks ago

    You can add multiple sheets to the SpreadBuilder Workbook using the AddNew method.

    GrapeCity.SpreadBuilder.Workbook sb = new GrapeCity.SpreadBuilder.Workbook();
    sb.Sheets.AddNew();

    You can also use the XlsExport class with its MultiSheet property set to true to export a SectionReport. With the MultiSheet set to true, each page is exported to a separate sheet.

    http://arhelp.grapecity.com/webhelp/Legacy/AR7Help/OnlineEN/GrapeCity.ActiveReports.Export.Excel.v7~GrapeCity.ActiveReports.Export.Excel.Section.XlsExport~MultiSheet.html

    In the latest version i.e v10, the MultiSheet property is available for ExcelRenderingExtension as well for exporting Page/Rdl Reports.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.