I got the below code snippet from teratech.com's Cold Cuts and it works great. As you can see it not only formats an Wxcel table from html calls but you can also use Excel formulas and functions.
The problem I have though is I am not able to pass Coldfusion variables to it in order to dynamically use it. If anyone can show me how to accomplish this I would appreciate it. Terry Troxel <cfsetting showdebugoutput="No"> <cfheader name="Content-Disposition" value="inline; filename=hello.xls"> <cfcontent type="application/msexcel"> <table border="2" bgcolor="#C0C0C0"> <tr><td bgcolor="#FF00FF">some data</td><td>Some more data</td></tr> <tr><td><font color="#800000"><strong>second row data</strong></font></td><td bgcolor="#008080">55.8</td></tr> <tr><td><font color="#800000"><strong>Third row data</strong></font></td><td bgcolor="#008080">83.5</td></tr> <tr><td>Fourth Row</td><td bgcolor="#008080">$567890</td></tr> <tr><td><font color="#800000"><strong>Total</strong></font></td><td bgcolor="#C0C0C0"><strong>=Sum(B2..B4)</strong></td></tr> </table> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
