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.
---
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/.
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).