You are viewing this page out of context. To see it in the context it is intended please click here.

About This Page

Reply posted by Caroline McGrath on Mon 20 Dec 2004 in response to Keeping the boss happy

Re: Creating multiple worksheets - use XML

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