DevExtreme v24.2 is now available.

Explore our newest features/capabilities and share your thoughts with us.

Your search did not match any results.

React Pivot Grid - Overview

Our PivotGrid allows you to easily and accurately export its contents to Microsoft Excel. To enable export operations, you must reference or import ExcelJS and FileSaver libraries. You must also set export.enabled to true.

Once you've referenced/imported both files and set export.enabled to true, use the exportPivotGrid(options) method to export PivotGrid content to an Excel workbook.

Please review the onExporting handler and its data export code to learn more. In this example, PivotGrid content is exported as is to a single worksheet.

To give you the ability to edit code on the fly, the demo uses SystemJS. For this reason, launching the demo takes some time. We strongly recommend that you do not use this approach in real projects.
Backend API

You can export PivotGrid to CSV. Call the exportPivotGrid(options) method as shown in the following ticket: Export PivotGrid into CSV file.