Discuss "export gridview to excel add multiple sheets" in the .Net Development forum.

Hey everyone its peeb hope all is well with everyone at developerbarn forums. I need a little help, 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.

Peeb

See if this is of any help: Export data to multiple sheets of Excel doc by Mahesh Chand

__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

Join our Folding team: DeveloperBarn Folding

Hey thanks jmurrayhead, I saw that article; I haven't had a chance to mess with it. I'll probably mess with it this week, If I can't get it to work the way I want to do it, i'll probably just use reporting services.

I really don't like reporting services thats why I wanted to do this way using a repeater. But I'll let you know how it turns out.

You'll hear from me again, anyway thanks for the reply.

Hey Jmurrayhead, i started messing with the multiple exce sheet link, but i'm having trouble to add reference to Excel.dll using Add Reference. I've been researching on line and I've been trying to add it to my bin folder as a reference, but Microsoft.Office.Interop.Excel.dll is not an option to add.

Any ideas on how to add the excel.dll as a reference?


Thanks.

I've found something online to add Imports Microsoft.Office.Interop.excel from the COM tab from the add reference box. and now I can reference Microsoft.Office.Interop.Excel.Workbooks.

Which is different from Dim xlBooks As Excel.Workbooks from the link. I"m still working with it.