How to generate excel files with multiple sheets?

[Pedro Martins]

I'm generating an excel file using the OWC, on the server side. I need to
create an excel file with more than one sheet. Here's the code (C#) I've
tried:

currentSheet.Sheets.Add( Missing.Value, Missing.Value, 1,
XlSheetType.xlWorksheet );

This doesn't produce any results. Is there any working method of doing this?

Thanks in advance,
Pedro

 

[rweide]

I use this to add worksheet after each sheet:
SS1.Worksheets.Add SS1.Worksheets(SS1.Worksheets.Count),,1
And, I use (VBScript) this to populate each sheet:
With SS1.ActiveSheet
.Cells.copyFromRecordset adoRS
.Range("A2").Select
Wend
And depending on how you get the resultsets, you need to add these to your
loop.