Export

  • 3 minutes to read

The Bootstrap Grid View is shipped with the ASPxGridViewExporter component that allows you to export BootstrapGridView data to a file or stream it in various formats - PDF, RTF, CSV, XLS, and XLSX.

BootstrapGrid_Export

To export grid data, assign its ID to the ASPxGridViewExporter.GridViewID property and select the export method. For example, to export data to a file in the XLS format, use the ASPxGridExporterBase.WriteXlsToResponse method. For a list of available methods, see Member Table: Built-in Export.

Use the ASPxGridViewDetailSettings.ExportMode property to specify detail rows for exporting. For instance, set this property to Expanded to export only master rows and expanded detail rows.

You can customize the appearance of exported grid elements using the ASPxGridViewExporter.Styles property.

NOTE

The ASPxGridViewExporter cannot export hidden data columns and the content of templates. The exception is the BootstrapGridView control within the GridViewTemplates.DetailRow template. ASPxGridViewExporter can identify the grid within this type of a template, and allows both master and detail data to be exported.

Note that templated elements are exported with their default representation. For instance, if you export a grid with templated cells, they are represented as default labels with text in the obtained file.

Excel Data Aware Export

When exporting data in both XLS and XLSX formats, the following grid data are maintained in the resulting excel document.

  • Data grouping - with the capability to collapse/expand groups within a worksheet.
  • Data sorting and filtering - allowing end-users to display relevant data in the desired order.
  • Totals and group summaries - with the capability to modify/change formulas.
  • Format conditions - with the capability to modify/change conditional formatting rules.
  • Data validation for combo-box columns
  • Fixed columns

To learn more, see the Knowledge Base Article: ASPxGridView / MVC GridView Extension - Excel Data Aware Export FAQ.

Export Limitations

Data Aware Mode Limitations

You can avoid the specified limitations by using the WYSIWYG (What You See Is What You Get) export mode. However in this mode, the table formatting, e.g., grouping, is lost.


gridExport.WriteXlsxToResponse(new XlsxExportOptionsEx { ExportType = ExportType.WYSIWYG });
See Also