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.

Example
View Source
Edit In Stackblitz  
Change Theme:

Installation

Either use the quick setup (Angular CLI v6 or later) or manually add the package (Angular CLI v5 or earlier).

Quick Setup with Angular CLI v6 or Later

Angular CLI v6 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

  1. Download and install the package.

    npm install --save @progress/kendo-angular-excel-export @progress/kendo-angular-l10n @progress/kendo-angular-common
  2. 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 {
    }

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

The following dependencies will be installed automatically:

  • @progress/kendo-ooxml

Functionality and Features

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.