Is it possible to export Gridview data to existing excel sheet with keeping headers intact & overwrite existing data?
if anyone know about this pls help me to solve the issue.thanks in advance.
3 Answers, 1 is accepted
0
Stefan
Telerik team
answered on 26 Aug 2013, 01:15 PM
Hi Ajit,
Thank you for writing.
Such a functionality is not supported by the RadGridView export mechanism and it makes no difference whether the grid will export one row more or less (the header row). Would you please share with us why would you need such a functionality, and if you have just one sheet, why don't you just replace it?
In addition, I would like to let you know that there is a feature request for exporting grid to a separate sheet in excel which is somewhat close to your case and if you consider it useful, feel free to add your vote for it here: http://www.telerik.com/support/pits.aspx#/details/Issue=9426.
Regards,
Stefan
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely. Sign up for Free application insights >>
Hi Stefan. Thanks for replying
I have one template excel file populated with data in first sheet & In Second Sheet i have Pivot table & pivot chart generated from the data in the first sheet.And i want to use that template excel file to populate with data from radgridview. in that case I have to use the existing template for exporting data.
0
Stefan
Telerik team
answered on 28 Aug 2013, 08:41 AM
Hello Ajit,
Thank you for the introduced clarification. We will consider such a feature in future if there is demand for it.
For the time being, the only thing I can suggest is to export the grid to excel, and then write merge the existing template file with the exported one by working with the xml from the files. However, this is not connected to our controls and you will have to implement such a merge on your own.
I hope that you find this information useful.
Regards,
Stefan
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely. Sign up for Free application insights >>