ASP.NET produce output to excel (.xls) with multiple worksheets

[dafodil]

Hi I have a problem with exporting my produced datas to excel. I already tried using the xml.. where I create a html document and allow the user to download my excel file. The report created was basicaly simple which suits my website need. But I cannot produce multiple work sheets. I'm using Microsoft office 2000. Any ideas on how can I produce multiple worksheets using asp.net particularly on Microsoft Excel 2000?

[dorandoran]

So many good article came up when I did a search on google.

http://www.google.com/search?q=asp.net+excel+with+multiple+sheet&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1

[dafodil]

So many good article came up when I did a search on google.

http://www.google.com/search?q=asp.n...x=&startPage=1

Actually, I already tried those codes.
After series of trying I ended up doing only one worksheet on Excel 2000. The problem with most of the samples is that it is for Excel 2003 and beyond. Excel 2000 does not fully support xml that's why it cannot create multiple work sheets via xml. There is one way to this if I try to install the excel on the server and use the Microsoft Excel com object. But that will not suit my application and will only cause my app to become slower.

My solution back to xml with only one worksheet.