Last Updated: 31 Aug 2020 09:25 by ADMIN
Created on: 30 Aug 2020 23:36
Category: Grid
Type: Feature Request
Grid - Import from Clipboard (Excel) when column name matches the first row header



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.

1 comment
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

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