Getting Started with the KendoReact Spreadsheet
Premium

This guide provides essential information about using the KendoReact Spreadsheet package. You will learn how to install the Spreadsheet package, add a Spreadsheet component to your project, style the component, and activate your license.

ninja-iconThe Spreadsheet is part of KendoReact premium, an enterprise-grade UI library with 120+ free and premium components for building polished, performant apps. Test-drive all features with a free 30-day trial.Start Free Trial

After completing this guide, you will be able to reproduce the following example.

Change Theme
Theme
Loading ...

Before You Begin

sh
npm create vite@latest my-app -- --template react

This guide requires that you have basic knowledge of React and TypeScript, and that you have already created a blank React project.

You can speed up the development of your KendoReact application with the Kendo UI Template Wizard for Visual Studio Code.

Install the Component

sh
npm i @progress/kendo-react-spreadsheet

Importing the Component

After installing the package, import the Spreadsheet component in the React App.

In the src/App.js file of your React project, import the Spreadsheet component from the Spreadsheet package.

jsx
// ES2015 module syntax
import { Spreadsheet } from '@progress/kendo-react-spreadsheet';
jsx
// CommonJS format
const { Spreadsheet } = require('@progress/kendo-react-spreadsheet');

Using the Component

  1. After installing the Spreadsheet package and importing the components, add the Spreadsheet tag to the App component file of your React project (for example, src/App.js).

  2. Load the JSON sheets data in the defaultProps of the Spreadsheet in order to display initial Excel document in the component.

    jsx
     function SpreadsheetContainer() {
       return (
          <Spreadsheet
             style={{
                width: '100%',
                height: 700
             }}
             defaultProps={{
                sheets: data
             }}
          />
       );
     }
    
     ReactDOM.render(<SpreadsheetContainer />, document.getElementById('app'));
  3. To style the Spreadsheet, install and import the Default theme, which is one of the three beautiful themes for KendoReact.

    3.1. Install the Default theme package.

    sh
    npm i @progress/kendo-theme-default

    3.2. Import the CSS file from the package in src/App.js. Add this import before your existing App.css import.

    jsx
    import '@progress/kendo-theme-default/dist/all.css';
  4. Build and run the application by typing the following command in the root folder of your project:

    sh
    npm start
  5. Navigate to http://localhost:3000 to see the KendoReact Spreadsheet component on the page.

Activating Your License Key

Using any of the UI components in the KendoReact library requires either a commercial license key or an active trial license key.

Follow the instructions on the KendoReact My License page to activate your trial or commercial license. You can skip this step if your application already contains a KendoReact license file.

Dependencies

The Spreadsheet package requires you to install the following peer dependencies in your application:

Package NameDescription
react 16.8.2*Contains the functionality necessary to define React components.
react-domContains the React renderer for the web.
@progress/kendo-drawingContains the Drawing library, which provides interactive vector graphics.
@progress/kendo-licensingContains the internal infrastructure related to licensing.
@progress/kendo-react-animationEnables the animations in the KendoReact components.
@progress/kendo-react-buttonsContains the KendoReact Buttons components.
@progress/kendo-react-dropdownsContains the KendoReact Dropdowns, which allows users to choose from a predefined list of options.
@progress/kendo-react-formContains the KendoReact Form components.
@progress/kendo-react-inputsContains the KendoReact Inputs components.
@progress/kendo-react-intlContains the KendoReact Internationalization package that applies the desired cultures by providing services and pipes for the parsing and formatting of dates and numbers.
@progress/kendo-react-layoutContains the KendoReact Layout components.
@progress/kendo-react-popupContains the KendoReact Popup component.
@progress/kendo-react-progressbarsContains the KendoReact ProgressBar component.
@progress/kendo-react-sortableContains the KendoReact Sortable component.
@progress/kendo-react-spreadsheetContains the KendoReact Spreadsheet component.
@progress/kendo-react-treeviewContains the KendoReact Treeview components.
@progress/kendo-react-uploadContains the KendoReact Upload components.
@progress/kendo-svg-iconsContains the KendoReact SVG icons.

Learning Resources