Doug. That is a good solution idea to explore. As far as charts, I think the MHT file actually stores a Base64 GIF image of the chart. Then when you open it up in Excel, it has the GIF chart, but does not recompute based on the excel data. But, I have not tried anything that complex in a while.
If nothing else, this method helps you figure out how to get numeric columns to render AS text (so that leading zeros don't get taken off and date/time values don't go all weird). ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 3:59 PM To: CF-Talk Subject: RE: ColdFusion and Microsoft Excel 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:261922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
