Rapid Excel Export

The Rapid Excel Export option provides a built-in capability for both the Data Table and Analysis Grid, running off the datalayer. This feature is available for Consumer and Self-Service users who export tabular data in Excel format for further analysis outside of the context of the Info application. The Rapid Export option greatly improves the performance of exporting large data, as compared to the Native Excel export option. The Rapid Export feature honors basic formatting (bold, font, italics, etc), but it does not apply custom styling or group aggregation. To review a detailed list of the differences between the native Excel and rapid Excel export, see Export To Native Excel.

To export your data using the Rapid Excel Export, access your Data Table in the Analysis Grid and select the Export icon.

Then, select Excel from the drop-down list:

Your download will appear in the bottom of the web browser, or may open automatically, depending on your machine's configuration.

The Data Table displays in Excel:

The availability of different types of exports is under developer control. In Info Studio, you can set the new attribute on the Target .NativeExcel element called "ExportDataPreference" (Formatted, Empty {default}, or Rapid ).. This preference can be set on a global application level by setting a restricted constant "rdExportDataPreference" to Rapid, like below:

For more information about how to configure your Info application for Rapid CSV Export, Excel - Exporting a Report Manually.