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
Download and install the package:
npm install --save @progress/kendo-react-excel-export @progress/kendo-licensing
Once installed, import the package module.
// ES2015 module syntax import { ExcelExport } from '@progress/kendo-react-excel-export';
// CommonJS format const { ExcelExport } = require('@progress/kendo-react-excel-export');
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.