Getting Started with the Kendo UI for Angular Excel Export

The Excel Export component allows you to export data to Excel file.

The Excel Export Package is part of Kendo UI for Angular, a professional grade UI library with 100+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.

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) 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

  1. Download and install the package.

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

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

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.