This is a migrated thread and some comments may be shown as answers.

upload file to grid

3 Answers 213 Views
Upload
This is a migrated thread and some comments may be shown as answers.
George
Top achievements
Rank 1
George asked on 07 Jan 2020, 06:25 PM
Is it possible to upload a file and have the content of the file be shown in the grid? The file will have 3 columns and will never change, I want to upload this file and have the columns in the file to be shown in the grid to the user.

3 Answers, 1 is accepted

Sort by
0
Petar
Telerik team
answered on 09 Jan 2020, 01:14 PM

Hi George,

Here is a demo that demonstrates how we can select and image for upload and generate its thumbnail before uploading it. The demonstrated approach could be used as a basis for implementing the functionality you want to achieve - you have to extract the needed data from the selected file, add it to a Datasource that could be read by the Grid and load this datasource to display the extracted data.  

Regards,
Petar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
George
Top achievements
Rank 1
answered on 09 Jan 2020, 01:21 PM
That's not really what I'm looking for. I want to upload a file (csv or xls) and show the content in the grid, allow the user to make changes to the data in the grid, then do a bulk update to my database table. 
0
Petar
Telerik team
answered on 13 Jan 2020, 01:09 PM

Hi George,

The described scenario can be achieved using the Spreadsheet component of the Kendo UI suite. Here is an example that demonstrates similar scenario to the one described in your last reply. The example demonstrates how we can upload a CSV/Excel file. The file is sent to the server and then opened in the Spreadsheet component.

This Spreadsheet / DataSource binding demo demonstrates how we can load file from the server, edit it and save the changes. 

You can combine the above two demos and achieve the desired scenario. Depending on the backend used in the application, you can read the uploaded and edited file and save its data in a database. 

Regards,
Petar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Upload
Asked by
George
Top achievements
Rank 1
Answers by
Petar
Telerik team
George
Top achievements
Rank 1
Share this question
or