Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Collapse]ASP.NET Bootstrap Controls
 [Expand]Getting Started
 [Collapse]Grid View
  [Expand]Binding to Data
  [Expand]Data Representation Basics
  [Expand]Data Summaries
  [Expand]Filtering
  [Expand]Grouping
   Sorting
  [Expand]Focus and Navigation
  [Expand]Data Editing
  [Expand]Master-Detail Relationship
   Adaptivity
  [Expand]Templates
   Export Overview
   Data-Toggle Attribute
 [Expand]Card View
 [Expand]Charts
 [Expand]Data Editors
 [Expand]Site Navigation
 [Expand]Site Layout
 [Expand]Redistribution and Deployment
 [Expand]API Reference
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Export Overview

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.

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: 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.

Expanded 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.

Expanded 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.

Expanded See Also

How would you rate this topic?​​​​​​​