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.

Copy Code    ng add @progress/kendo-angular-excel-export

Manual Setup

1. Download and install the package.

   Copy Codenpm install --save @progress/kendo-angular-excel-export @progress/kendo-angular-l10n @progress/kendo-angular-common @progress/kendo-licensing

2. Once installed, import the ExcelExportModule in your application root or feature module.

   Copy Codeimport { 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 {
   }

3. 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.

Suggested Links

• API Reference of the Excel Export Component