Unplanned
Last Updated: 28 Sep 2021 11:03 by ADMIN
Jeffrey
Created on: 30 Aug 2020 23:36
Category: Grid
Type: Feature Request
4
Paste excel table from Clipboard

 

 

Grid - Import from Clipboard (Excel) when column name matches the first row header

 

I think it would be a great feature to be able to import copied data from excel into the grid either based on the index of the column or the header row in the clipboard matches the name of the column in Blazor Grid.

---

ADMIN EDIT

You can find an example of implementing this and the caveats it brings in the following sample project: https://github.com/telerik/blazor-ui/tree/master/grid/paste-from-excel

This feature requires research on how we could provide it as a built-in feature. So, any feedback on the matter will be appreciated.

---

2 comments
ADMIN
Marin Bratanov
Posted on: 10 Dec 2020 10:58

Hello,

You can find an example of implementing this and the caveats it brings in the following sample project: https://github.com/telerik/blazor-ui/tree/master/grid/paste-from-excel

Considering that it breaks the UX of many features, while being highly specific to the data and models, this is not a feature the grid can have built-in.

Regards,
Marin Bratanov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

ADMIN
Marin Bratanov
Posted on: 31 Aug 2020 09:25

Hi Jeffrey,

Would you expect this to happen only for rows in Edit mode (InLine maybe)? Or should the grid try to update the data even when not in edit mode? What API would you expect the grid to expose for that? Should the first row go automatically in edit mode when the user tries to paste, and what should be done if there is more than one row that is pasted? Should pasting actually be considered an insert operation when the grid is in "read" mode?

On another note - Excel provides rows of data where the cell data is separated with Tab symbols (\t) and there is no guarantee there will be header information because that depends on what the end user selects in the spreadsheet. Thus, the best the grid could do is to try to put values and rows sequentially into new items.

By the way, you may also find interesting this feature request: https://feedback.telerik.com/blazor/1435743-copy-selected-row-to-the-clipboard

Regards,
Marin Bratanov
Progress Telerik

Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive , special prizes and more, for FREE?! Register now for DevReach 2.0(20).