I was wondering this one as well. I did some research and ended up with this
site: http://www.15seconds.com/issue/031007.htm
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
describes.
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.
I was wondering this one as well. I did some research and ended up with this site: http://www.15seconds.com/issue/031007.htm
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 describes.
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.
CAroline