I was wondering this one as well. I did some research and ended up with this
To create multiple worksheets you have to use xml rather than html. You would
have to save a number of files (main file, one per worksheet) on the server to
achieve this, which for me counteracts my reason for using the method Jake
Whilst the above link seems to take you through all the steps in a nice easy
manner, I think that I'd rather use LotusScript to write an Excel file on the
server in the usual way - at least I'm using a language I am familiar with.