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

Excel Export in existing excel file

3 Answers 197 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Ajit
Top achievements
Rank 1
Ajit asked on 26 Aug 2013, 11:58 AM
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

Sort by
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 >>
0
Ajit
Top achievements
Rank 1
answered on 26 Aug 2013, 01:35 PM
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 >>
Tags
GridView
Asked by
Ajit
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Ajit
Top achievements
Rank 1
Share this question
or