All Components

This website hosts Kendo UI wrappers of Kendo UI for jQuery widgets intended to be used in the React ecosystem.

Go to the native Kendo UI implementations for React

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