All Components

You are on the site of the Kendo UI Wrappers for React suite which contains wrappers for the Kendo UI for jQuery widgets. To explore the brand-new set of Kendo UI for React components which are built from the ground up, go to the Kendo UI for React suite.

Spreadsheet Overview

The Spreadsheet enables you to edit and visualize tabular data by using cell formatting options, styles, and themes.

The Spreadsheet wrapper for React is a client-side wrapper for the Kendo UI Spreadsheet widget.

Basic Usage

The following example demonstrates the Spreadsheet in action.

class SpreadsheetContainer extends React.Component {

    constructor(props) {
            super(props);
    }

    render() {
        return (
            <div>
                <Spreadsheet/>
            </div>
        );
     }
    }
ReactDOM.render(
    <SpreadsheetContainer/>,
    document.querySelector('my-app')
);

Installation

  1. Download and install the package.

    npm install --save @progress/kendo-spreadsheet-react-wrapper
  2. Once installed, import the Spreadsheet component from the package.

    import { Spreadsheet } from '@progress/kendo-spreadsheet-react-wrapper';
  3. You are required to install one of the Kendo UI themes to style your components.

Dependencies

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

  • @progress/kendo-ui

Features and Functionalities

Events

The following example demonstrates basic Spreadsheet events. You can subscribe to all Spreadsheet events by the handler name.

class SpreadsheetContainer extends React.Component {

    constructor(props) {
        super(props);
        this.onSelect = this.onSelect.bind(this);
        this.onChange = this.onChange.bind(this);
        this.onRender = this.onRender.bind(this);
    }

    onSelect = (e) => {
         console.log("event :: select");
         console.log(e);
    }

    onChange = (e) => {
         console.log("event :: change");
         console.log(e);
    }

    onRender= (e) => {
         console.log("event :: render");
         console.log(e);
    }

    render() {
        return (
            <div>
                <Spreadsheet change={this.onChange}
                    select={this.onSelect}
                    render={this.onRender}/>
            </div>
        );
    }
}
ReactDOM.render(
    <SpreadsheetContainer/>,
    document.querySelector('my-app')
);
In this article