Export to multiple sheets in Excel

[gdunn]

I've searched through the archives to research all the Excel exporting options available to me, but none seem to address the problem of needing multiple worksheets.

Here's my problem: I need to generate a report which is in Excel (workbook) format. That file (after its emailed as an attachment) should be double-clickable to launch Excel. That part's easy. Once in Excel, I need to see multiple worksheets, each containing a category of information I'm trying to send the recipient. One tab might be 'apples', the next 'bananas', a third 'oranges', etc... Within each of those tabs, there will be rows and columns of information, pertaining to apples, bananas or oranges.

I don't think a CSV file can import in this way, so that method is out.

HTML tables are nice and simple, but suffer the same fate (how do I get multiple worksheets?).

I'm in the process of evaluating the delivery format library from www.darkstreak.com. It looks great, but I don't see a way to create multiple worksheets.

Any ideas?

[Anon]

I've had success with this by taking an existing Excel file and saving it to XML format and then using that xml code to build my excel file. The only problem is that this will only work in Excel 2002.

If you find another way, please let me know. I need for this to work in Excel 2000.

Thanks!