ActiveReports 18 .NET Edition
Developers / Export Reports / Export Page/RDLX Reports / Excel Export
In This Topic
    Excel Export
    In This Topic

    Microsoft Excel is one of the formats to which you can render your report using ExcelRenderingExtension. You can export Excel files in two formats, i.e. Xls and Xlsx.

    Excel Rendering Properties

    ActiveReports offers several options to control how reports render to Microsoft Excel.

    Property Description
    Author Gets or sets the name of the author of the document.
    Categories Sets the name of the categories that appears in the Categories field in the Properties of the exported Excel document.
    FileFormat Specifies the output format of the Excel document, i.e. Xls or Xlsx.
    OpenXmlStandard

    Specifies the level of Open XML document conformance on exporting in Xlsx file format. You can choose from the following values:

    • Strict: The default value.
    • Transitional: The Excel file generated by scheduled task execution using Strict (the default value of OpenXMLStandard) cannot be viewed on IOS devices.
    PageSettings Returns an ExcelRenderingExtensionPageSettings object for initializing Excel file print setting.
    Pagination Forces pagination or galley report layout mode.
    RightToLeft

    Shows direction of sheets from right to left.
    Security Returns an ExcelRenderingExtensionSecurity object for initializing document security.
    SheetMode

    Indicates how to split the report pages into the excel sheets. You can choose from the following modes:

    • PagePerSheet: Each report page is exported to a separate Excel sheet
    • SectionPerSheet: Each report section is exported to a separate Excel sheet
    • SingleSheet: Entire report is exported to a single Excel sheet
    SheetName Indicates the name of the sheet.
    Title Gets or sets the title of the document.
    UseCompression Indicates whether to use compression when exporting document to an Xlsx file.
    UseDefaultPalette Indicates whether to export the document with the default Excel palette.

    Interactivity

    Reports rendered in Excel support a number of interactive features like Bookmarks and Hyperlinks. However, in case you have any data hidden at the time of rendering (like in a drill-down report), it does not show up in the output. It is recommended that you expand all toggle items prior to rendering.

    Limitations

    Export Report using Excel Rendering Extension

    The following steps provide an example of rendering a report in Microsoft Excel format.

    1. Create a new Visual Studio project.
    2. In the New Project dialog that appears, select ActiveReports 18 Page report Application and specify a name for the project in the Name field.
    3. Click OK to create a new ActiveReports 18 Page report Application. By default, a Page report is added to the project.
    4. Add a reference to MESCIUS.ActiveReports.Export.Excel package in the project.
    5. On the Form.cs or Form.vb that opens, double-click the title bar to create the Form_Load event.
    6. Add the following code inside the Form_Load event. 
      Visual Basic.NET code. Paste INSIDE the Form Load event.
      Copy Code 
      ' Provide the Page report you want to render.

Dim rptPath As New IO.FileInfo("..\..\PageReport1.rdlx")

Dim pageReport As New GrapeCity.ActiveReports.PageReport(rptPath)

' Create an output directory.
Dim outputDirectory As New System.IO.DirectoryInfo("C:\MyExcel")
outputDirectory.Create()

' Provide settings for your rendering output.
Dim excelSetting As New GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings()
excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xls
Dim setting As GrapeCity.ActiveReports.Extensibility.Rendering.ISettings = excelSetting

' Set the rendering extension and render the report.
Dim excelRenderingExtension As New GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension()
Dim outputProvider As New GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name))

' Overwrite output file if it already exists.
outputProvider.OverwriteOutputFile = True

pageReport.Document.Render(excelRenderingExtension, outputProvider, setting.GetSettings())
      C# code. Paste INSIDE the Form Load event.
      Copy Code 
      // Provide the Page report you want to render.
System.IO.FileInfo rptPath = new System.IO.FileInfo(@"..\..\PageReport1.rdlx");

GrapeCity.ActiveReports.PageReport pageReport = new GrapeCity.ActiveReports.PageReport(rptPath);

// Create an output directory.
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"C:\MyExcel");
outputDirectory.Create();

// Provide settings for your rendering output.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings excelSetting = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings();
excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xls;
GrapeCity.ActiveReports.Extensibility.Rendering.ISettings setting = excelSetting;

// Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension excelRenderingExtension = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));

// Overwrite output file if it already exists.
outputProvider.OverwriteOutputFile = true;

pageReport.Document.Render(excelRenderingExtension, outputProvider, setting.GetSettings());