Click here to Skip to main content
15,938,218 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all i would like to export the data from the dataset to excel sheet. My dataset consists of 2 Tables so how can i write the multiple dataset values in a single excel sheet

You would need the .Net office automation libraries, and each table would be created in its own sheet withint the excel file. At that point, you would Response.WriteFile to download the file to the user.

For details, I refer you to the search engine known as "google".
Share this answer
demouser743 21-Jul-11 7:59am    
It's not the question to download the file i would like to know how to export multiple dataset values to be added to a single excel file
Hi, there are few article on CP.
You can try this....
Export Data to Excel Much Faster[^]

You can easily export second data table to same sheet by incrementing row counter.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900