Getting Started with KendoReact Excel Export

The KendoReact Excel Export component allows you to export and save data to Excel files, to customize the output cells and columns, and to filter the data after the export.

The KendoReact Excel Export is part of the KendoReact library of React UI components. It is distributed through NPM under the kendo-react-excel-export package.

Basic Usage

The following example demonstrates the Excel Export component in action.

Functionality and Features

• Configuration of exported columns
• Customization of exported cells
• Customization of the workbook
• Filtering
• Saving files on the server
• Right-to-left support
• Add Loading

Installation

1. Download and install the package:

   Copy Code   npm install --save @progress/kendo-react-excel-export @progress/kendo-licensing

2. Once installed, import the package module.

   Copy Code// ES2015 module syntax
   import { ExcelExport } from '@progress/kendo-react-excel-export';

   Copy Code// CommonJS format
   const { ExcelExport } = require('@progress/kendo-react-excel-export');

3. Follow the instructions on the KendoReact My License page to activate your license. You can skip this step if your application already contains a KendoReact license file.

Dependencies

The Excel Export package requires the following peer dependencies that have to be installed by your application:

• react 16.8.2*
• react-dom
• @progress/kendo-licensing

The following dependencies will be installed automatically:

• @progress/kendo-ooxml
• @progress/kendo-file-saver

Known Limitations

• Older browsers, such as Internet Explorer 9 and Safari, require you to implement a server proxy. For more information, refer to the section on the proxyUrl configuration.
• The maximum size of the exported file has a system-specific limit. For large data sets, it is highly recommended that you use a server-side solution.

Suggested Links

• API Reference of the Excel Export Component