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

Export to Excel

5 Answers 103 Views
GridView
This is a migrated thread and some comments may be shown as answers.
kalyan gupta
Top achievements
Rank 1
kalyan gupta asked on 18 Aug 2010, 12:14 PM
Hi ,
 I am using Telerik rad grid view , i am also implementing the Export to excel feature.When i click on the export to excel , an excel is generated.

Now comes the main requirement : If the user edits the exported excel and after done with the editing the  modified data should be updated in the radgrid as well.

Please let us know your response.

Regards
Abid

5 Answers, 1 is accepted

Sort by
0
Veselin Vasilev
Telerik team
answered on 18 Aug 2010, 12:25 PM
Hello kalyan gupta,

When you export the data to excel - it creates a new file in the file system. After that, the file have no idea of where the data came from. It does not have a link to the data source.
So, it is not possible to automatically transfer the data from Excel to RadGridView.

What you can do is use our new clipboard capabilities - copy/paste from/to Excel.
Please check the online demo and the online help.

Hope that this will get you started.

Kind regards,
Veselin Vasilev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
kalyan gupta
Top achievements
Rank 1
answered on 20 Aug 2010, 08:27 AM
H Veselin,

I tried out the Copy/paste feature and is really exciting.I would really appreciate if you could send a working sample for the same.

Regards
Abid
0
Veselin Vasilev
Telerik team
answered on 20 Aug 2010, 09:42 AM
Hello kalyan gupta,

Please find it attached.

Kind regards,
Veselin Vasilev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Kjell
Top achievements
Rank 1
answered on 27 Aug 2010, 02:53 AM
Is it possible to add the copy option to a context menu?  What would the code behind look like for that command?
0
Veselin Vasilev
Telerik team
answered on 30 Aug 2010, 04:10 PM
Hello Kjell,

Please find attached a sample project. You can select multiple cells and use the context menu to copy their value to the clipboard.

Hope this helps.

All the best,
Veselin Vasilev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
GridView
Asked by
kalyan gupta
Top achievements
Rank 1
Answers by
Veselin Vasilev
Telerik team
kalyan gupta
Top achievements
Rank 1
Kjell
Top achievements
Rank 1
Share this question
or