Import/paste data in Kendo Grid

[Farzana]

Kendo Grid currently provides the export to excel feature out of the box. I need to be able to import data as well and also copy/paste data into the grid with validation. Can you provide me with an example as to how I can achieve these two: 1) Import from file and 2)copy/paste. I am using the angular implementation.

[Dimiter Madjarov]

Hello Farzana,

The Kendo UI Grid does not support the mentioned functionalities out of the box. Along the export to Excel functionality there is also a copy to Excel support.

I would suggest to check the Spreadsheet widget, which I assume would be more suitable for the scenario you are referring to.

Regards,
Dimiter Madjarov
Telerik

 

 

[Farzana]

Can you please provide an overview of the difference in features/capabilities between a grid and a spreadsheet so as to make it easier for me to determine why I would use one vs the other?

Thanks for your help.

[Dimiter Madjarov]

Hello Farzana,

You could find a complete overview of the Spreadsheet widget on the following documentation page

http://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/overview

In the current case I recommended it instead of the Grid, because of it's import/export and copy/paste capabilities.

Regards,
Dimiter Madjarov
Telerik