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

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

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

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

• 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