I create reports sometimes with a gridview and export the data to excel. Lets say I have like multiple gridviews and I wanted to export each gridview to excel under its own spreadsheet.

So gridview1, gridview2, gridview3 are exported to excel under $heet1, $heet2, $heet3.

I know how to export multiple gridviews to 1 excel sheet but I don't know how to export them separately under their own spreadsheet.

I've been researching online, and i'm continously searching, but does anyone know how to do what i'm trying to do with the gridview and excel or is this not possible?

I appreciate any help or ideas, thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.