Getting Started with the Kendo UI for Angular Excel Export
The Excel Export component allows you to export data to Excel file.
Basic Usage
The following example demonstrates the Excel Export component in action.
Installation
Either use the quick setup (Angular CLI) or manually add the package.
Quick Setup with Angular CLI
Angular CLI supports the addition of packages through the ng add
command which executes in one step the set of otherwise individually needed commands.
ng add @progress/kendo-angular-excel-export
Manual Setup
Download and install the package.
npm install --save @progress/kendo-angular-excel-export @progress/kendo-angular-l10n @progress/kendo-angular-common @progress/kendo-licensing
Once installed, import the ExcelExportModule in your application root or feature module.
import { NgModule } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { ExcelExportModule } from '@progress/kendo-angular-excel-export'; import { AppComponent } from './app.component'; @NgModule({ bootstrap: [AppComponent], declarations: [AppComponent], imports: [BrowserModule, ExcelExportModule] }) export class AppModule { }
Follow the instructions on the Kendo UI for Angular My License page to activate your license. You can skip this step if your application already contains a Kendo UI license file.
Dependencies
The Excel Export package requires the following peer dependencies that have to be installed by your application:
- @angular/common
- @angular/core
- rxjs
- @progress/kendo-angular-l10n
- @progress/kendo-angular-common
- @progress/kendo-licensing
The following dependencies will be installed automatically:
- @progress/kendo-ooxml
Functionality and Features
- Configuration of exported columns
- Customization of exported cells
- Customization of the workbook
- Filtering
- Saving files on the server
- Globalization
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.