New to Kendo UI for AngularStart a free 30-day trial

Pasting Tab-Separated Values in the Grid from Excel

Environment

ProductProgress® Kendo UI Grid

Description

How can I paste tab-separated values from Excel in the Kendo UI for Angular Grid?

Solution

As of version v15.0.0, the Kendo UI for Angular Grid component supports a built-in clipboard functionality.

Transfer data from Microsoft Excel by using the Clipboard.

In Latest Browser Versions

  1. Access the data that is copied from Excel in the paste event.
  2. Convert the raw data to a plain text format (tab-separated values) by calling the clipboardData.getData('text') method.

The following example demonstrates how to use the paste event to receive the data and then bind the Kendo UI Grid for Angular to it.

Change Theme
Theme
Loading ...