• Getting Started
  • Components
    • Barcodes
    • Buttons
    • Chartsupdated
    • Conversational UIupdated
    • Data Query
    • Date Inputsupdated
    • Date Math
    • Dialogs
    • Drawing
    • Dropdownsupdated
    • Editor
    • Excel Export
    • File Saver
    • Filter
    • Gantt
    • Gauges
    • Gridupdated
    • Icons
    • Indicators
    • Inputsupdated
    • Labels
    • Layout
    • ListBox
    • ListView
    • Map
    • Menus
    • Navigation
    • Notification
    • Pager
    • PDF Export
    • PDFViewer
    • PivotGridupdated
    • Popup
    • ProgressBars
    • Ripple
    • Schedulerupdated
    • ScrollView
    • Sortable
    • Spreadsheetupdated
    • ToolBar
    • Tooltips
    • TreeList
    • TreeView
    • Typography
    • Uploads
    • Utilities
  • Styling & Themes
  • Common Features
  • Project Setup
  • Knowledge Base
  • Sample Applications
  • FAQ
  • Troubleshooting
  • Updates
  • Changelogs

Getting Started with the Kendo UI for Angular Excel Export

This guide provides the information you need to start using the Kendo UI for Angular Excel Export—it includes instructions about the available installation approaches, the required dependencies, the code for running the project, and links to additional resources.

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

After the completion of this guide, you will be able to achieve an end result as demonstrated in the following example.

Example
View Source
Change Theme:

Setting Up Your Angular Project

Before you start with the installation of any Kendo UI for Angular control, ensure that you have a running Angular project. The prerequisites to accomplish the installation of the components are always the same regardless of the Kendo UI for Angular package you want to use, and are fully described in the section on setting up your Angular project.

Installing the Component

You can choose to use either of the following two approaches for installing the Kendo UI for Angular package and the styles you want to apply:

Quick Setup with Angular CLI

The quick setup presents an automatic approach for adding packages with Angular CLI through the ng-add command. It is suitable for saving time and efforts as ng-add executes in a single step a set of otherwise individually needed commands.

To add the Kendo UI for Angular Excel Export package, run the following command:

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

As a result, the ng-add command will perform the following actions:

  • Add the @progress/kendo-angular-excel-export package as a dependency to the package.json file.
  • Import the ExcelExportModule in the current application's main module (only if the application uses NgModules).

    If your application uses standalone components, you must import the ExcelExportModule manually.

  • Register the Kendo UI Default theme in the angular.json file.
  • Add all required peer dependencies to the package.json file.
  • Trigger npm install to install the theme and all peer packages that are added.

Manual Setup

The manual setup provides greater visibility and better control over the files and references installed in your Angular application. You can install the required packages and theme by running separate commands for each step and import the desired component modules in your NgModule.

  1. Install the Excel Export package together with its dependencies by running the following command:

    npm install --save @progress/kendo-angular-excel-export @progress/kendo-angular-l10n @progress/kendo-angular-common @progress/kendo-licensing
  2. To add the Excel Export component, import the ExcelExportModule either in your NgModule or standalone components.

    • Using Modules

      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({
        imports:      [ BrowserModule, ExcelExportModule ],
        declarations: [ AppComponent ],
        bootstrap:    [ AppComponent ]
      })
      
      export class AppModule { }
    • Using Standalone Components

      import { Component } from '@angular/core';
      import { ExcelExportModule } from '@progress/kendo-angular-excel-export';
      
      @Component({
          standalone: true,
          selector: 'my-app',
          imports: [ExcelExportModule],
          template: `
              <kendo-excelexport></kendo-excelexport>
          `.
      })
  3. The next step is to style the component by installing one of the available Kendo UI themes—Kendo UI Default, Kendo UI Material, or Kendo UI Bootstrap.

    3.1 To start using a theme, install its package through NPM.

    • Default theme

      npm install --save @progress/kendo-theme-default
    • Bootstrap theme

      npm install --save @progress/kendo-theme-bootstrap
    • Material theme

      npm install --save @progress/kendo-theme-material

    3.2 After the theme package is installed, reference it in your project. You can include kendo-themes in your project in one of the following ways:

Using the Component

  1. After successfully installing the Excel Export package, initialize the Excel Export with a data set and columns in the app.component.html file:

    <kendo-excelexport [data]="data" fileName="Products.xlsx" #excelexport>
        <kendo-excelexport-column field="ProductID" title="Product ID">
        </kendo-excelexport-column>
        <kendo-excelexport-column field="ProductName" title="Product Name">
        </kendo-excelexport-column>
    </kendo-excelexport>
  2. On the click of a button trigger the export of the file:

    <button kendoButton type="button" (click)="excelexport.save()">Export To Excel</button>
  3. Build and serve the application by running the following command in the root folder.

    ng serve
  4. Point your browser to http://localhost:4200 to see the Kendo UI for Angular Excel Export component on the page.

Activating Your License Key

As of December 2020, using any of the UI components from the Kendo UI for Angular library requires either a commercial license key or an active trial license key. If your application does not contain a Kendo UI license file, activate your license key.

Next Steps

Dependencies

The following table lists the specific functionalities that are provided by each of the Buttons dependencies as per package:

Package NameKendo UI for Angular Excel Export
@angular/commonProvides the commonly-needed services, pipes, and directives provided by the Angular team. For more information, refer to the official Angular documentation.
@angular/coreContains critical runtime parts of the Angular framework that are needed by every application. For more information, refer to the official Angular documentation.
@progress/kendo-angular-commonContains common utilities that are needed by every Kendo UI for Angular component.
@progress/kendo-licensingContains the kendo-ui-license CLI utility for license management and the internal infrastructure related to licensing.
@progress/kendo-angular-l10nProvides the globalization features of Kendo UI for Angular.
rxjsProvides the RxJS library for reactive programming which uses Observables for an easier composition of asynchronous or callback-based code.

Learning Resources