Converting Multiple Gridviews to Excel in separate sheets.

See more:

C#

ASP.NET

MS-Excel

Gridview

, +

Hi All,

I have multiple Gridviews in my project. I have to export my all gridviews into excel workbook but the condition is that each gridview should be exported to single sheet of the same workbook.
Just like below:

GridView1 = Sheet1
GridView2 = Sheet2
GridView(n) = Sheet(n)

and so on.

Only one gridview is visible and the others are dynamically created on different scenarios.

I have googled everything and found the conclusion of exporting DataSet which contains all my datatables.. But, the text formatting I need in excel should be same as GridView formatting and if I export datatables, the data has no formatting in the excel. (Transposing Rows into Columns of some gridviews which should be exported as same as format is) that is why exporting DataTables or DataSet to Excel was unsuccessful for my project.

Please help me in this matter.

Thanks,
AR.