Export to Excel

[kalyan gupta]

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

[Veselin Vasilev]

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

[kalyan gupta]

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

[Veselin Vasilev]

Hello kalyan gupta,

Please find it attached.

Kind regards,
Veselin Vasilev
the Telerik team

[Kjell]

Is it possible to add the copy option to a context menu?  What would the code behind look like for that command?

[Veselin Vasilev]

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