Click here to Skip to main content
15,920,383 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I need to export 3 gridviews data into one excel with multiple worksheets. please help on this ASAP.

GRIDVIEW1 to sheet1
GRIDVIEW2 to sheet2
GRIDVIEW3 to sheet3

1 solution

Take a look at the below article. It may help you
Export DataSet to Multiple Excel Sheets[^]

You can also refer Export data to multiple sheets in excel from multiple grid views[^]
Share this answer
visnumca123 7-Sep-12 8:45am    
Hi thanks for the link i already have this but i need grid to excel not dataset to excel
visnumca123 7-Sep-12 10:06am    
The error which was showing while buiding for loop in grid with object please help me on this

foreach statement cannot operate on variables of type 'object' because 'object' does not contain a public definition for 'GetEnumerator'
__TR__ 7-Sep-12 11:56am    
Its not easy to identify what's causing the error without looking at the code. So i would recommend you to post the code you have wrote and the error message you are getting as a new question, so others can also take a look.

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