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

Export Multiple Gridview into one excel file?

2 Answers 83 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Woramin
Top achievements
Rank 1
Woramin asked on 12 Sep 2011, 03:06 AM
Hi there

Please help me on this question
I have 2 RadGridviews filled with the data from database. My form allows user to export data from RadGridView into different file formats.

Question: Is it currently possible to export data from 2 or more RadGridViews into only one file (such as export 2 radgridviews' table into only one excel file)? In my opinion, I don't think it is possible to do that due to using export function of RadGridView itself. But just want to ask for sure whether it is possible?

Thanks

2 Answers, 1 is accepted

Sort by
0
Ivan Ivanov
Telerik team
answered on 15 Sep 2011, 01:10 PM
Hello Woramin,

I have prepared an example project for you. Please, refer to it and let us know whether this solution meets your requirements.

Kind regards,
Ivan Ivanov
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
0
Woramin
Top achievements
Rank 1
answered on 16 Sep 2011, 02:22 AM
That's surely help me a lot

By the way, I still have some questions regarding your solution.

1. Is it possible to create big header for the table. I mean I just want to put another header in the row above the column header of the table in the excel file.
2. Is it possible to put some images into excel file at this time?
(For the question 2, I tried to use elementExported event with the stream writer writing some HTML tag. However I cannot put the embedded image by using the <img> tag with the image source as data URI scheme (e.g. src='
data:image/png;base64,iVBORw0KGgoAAAANSUhEUg~~~'). It shows that image is not linked to the source in the excel file )


However, at this time, thanks for the solution. I give me an idea to try something
Tags
GridView
Asked by
Woramin
Top achievements
Rank 1
Answers by
Ivan Ivanov
Telerik team
Woramin
Top achievements
Rank 1
Share this question
or