I've had to setup a lot of automated excel generation and find the XML Spreadsheet format the easiest and you can easily do separate worksheets, the only drawback is you need excel 2003.
Design you spreadsheet in excel then save as "XML Spreadsheet". Then use that as a template and put in all your cfoutput's and have CF save it as *.xls. It takes a bit of trial and error as if you get something wrong excel just wont open it. There is a good reference at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xmlss.asp -- Morgan Dennithorne Lonely Planet. www.lonelyplanet.com On Mon, 14 Feb 2005 10:16:58 +1100, M@ Bourke <[EMAIL PROTECTED]> wrote: > if you dont want to change your page then you will have problems > > but if its for office 2003 ya could dump it as a xml structure > and make multiple sheets. > but as far as a html page simply being converted to diff sheets I cant > see it happening. > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
