Hello,
One of the requirement of our client is Excel export and Import data to radgrid. I am using RADGrid in BatchEdit mode,the data from the grid will be exported as excel. This has been done already using openxml. The data in the exported excel will be edited by the user. He may add new data. Once done the changes in the excel, the user wants to import the excel in Radgrid batchedit and save the changes in database.
In summary, the client wants to work offline with exported excel and then import the modified excel to the application.
How to do this import part in batch edit mode. Can you please share a sample project?
One of the requirement of our client is Excel export and Import data to radgrid. I am using RADGrid in BatchEdit mode,the data from the grid will be exported as excel. This has been done already using openxml. The data in the exported excel will be edited by the user. He may add new data. Once done the changes in the excel, the user wants to import the excel in Radgrid batchedit and save the changes in database.
In summary, the client wants to work offline with exported excel and then import the modified excel to the application.
How to do this import part in batch edit mode. Can you please share a sample project?
1 Answer, 1 is accepted
0
Hi,
Basically the described scenario has to be accessed by our development team as it is not supported out of the box. Therefore I should forward you request to be further researched and considered.
Meanwhile could you go through the following links:
- Importing an Excel Spreadsheet Using ...
- Import data from Excel
Let me know whether they are useful.
Regards,
Deyan Enchev
Telerik
Basically the described scenario has to be accessed by our development team as it is not supported out of the box. Therefore I should forward you request to be further researched and considered.
Meanwhile could you go through the following links:
- Importing an Excel Spreadsheet Using ...
- Import data from Excel
Let me know whether they are useful.
Regards,
Deyan Enchev
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
Nethaji
commented on 21 Oct 2022, 04:23 PM
Top achievements
Rank 1
Rank 1
Looking solution for this scenario.. Could you please frwd it .
Doncho
commented on 26 Oct 2022, 11:17 AM
Telerik team
Hi Nethaji,
The Telerik Document Processing Libraries (DPL) and specifically the RadSpreadProcessing can be used for converting an Excel file to a DataTable object which then can be bound to the RadGrid.
I would suggest you review the following resources on this matter:
- Workbook to DataTable
- Export Worksheet to DataTable via DataTableFormatProvider
- Bind RadGrid to DataTable object
Note that the Document Processing Libraries depend on their own assemblies that are included in the Telerik AJAX installation folder, see DPL Assemblies.
I hope this will help.