Another thing to try if you have a complex spreadsheet (i.e. formulas, multiple sheets, etc.) is to create the spreadsheet in Excel with all of the formatting and such you need, then do save as "single file web page (.mht)" from Excel.
Open the file up in a Dreamweaver or whatever and dig through the markup to find the cells you need to be dynamic, and replace them with the appropriate CF code. Once you spend a little time getting a feel for the Excel-specific markup then generating rows, columns, etc. isn't too hard. Now, rename the file to end in .cfm, and cfinclude the template within the cfsavecontent from the previous solution, and the rest should work out the same. Excel opens it right up with formatting, multiple sheets, formulas etc. intact. I don't know if it would retain, say, charts or pivot tables or more complex stuff like that (haven't tried it). This works well for Word also by the way, retaining margins, page breaks, etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
