[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Pivot Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Gauges
  [Collapse]Vertical Grid
   [Expand]Product Information
   [Expand]ASPxVerticalGrid Getting Started
   [Expand]Fundamentals
   [Collapse]Concepts
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Expand]Data Shaping and Manipulation
    [Expand]Data Formatting
     Appearance Customization
     Templates
    [Collapse]Export
      Export
     Toolbars
    ASPxVerticalGrid Designer
   [Expand]Visual Elements
   [Expand]Member Tables
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Export

Note

The information in this topic applies to DevExpress ASP.NET Vertical Grid version 17.2 and later.

The ASPxVerticalGrid allows exporting its data to a file or stream in various formats - PDF, RTF, CSV, XLS, XLSX, and DOCX.

Note

Exporting using built-in toolbar commands and client-side API is disabled by default due to possible security issues. To enable such grid exporting functionality, set the ASPxGridExportSettings.EnableClientSideExportAPI property to true.

ASPxVerticalGrid data exporting can be implemented using one of the following:

  • Standard toolbar commands

    The ASPxVerticalGrid toolbar provides the most important or frequently used grid command including export commands. Using the VerticalGridToolbarItem.Command property setting, trigger one of the standard grid commands for exporting (listed below). For more information on using grid toolbars, refer to the ASPxVerticalGrid toolbars topic or the Toolbar online demo.

  • Exporting API

    Perform an appropriate server or client method to implement grid data exporting. For a list of available methods, see Member Table: Export.

    The following examples illustrates how to use client and server exporting methods:

    • Client API

    • Server API

You can customize the exported ASPxVerticalGrid elements' appearance with the ASPxVerticalGrid.StylesExport property.

Note

The ASPxVerticalGrid cannot export data records that are hidden or export templates' content.

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 is maintained in the resulting excel document:

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

Expanded Excel Format (XLS or XLSX) Export Limitations

Exporting a vertical grid to an Excel format (XLS or XLSX) has the following limitations.

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

Expanded Online Demo

To see the data export in action, please refer to the Exporting to Different Formats online demo.

Expanded Member Table

Is this topic helpful?​​​​​​​