One technique I have found very effective is to first create the sheet in Excel with some dummy values, and the formatting, formulas, etc. that I want, and then save it as HTML. Then, using that as a template, simply replace any static values with CFML. The benefit is that the HTML format as saved from Excel has a number of extra tags and such that describe Excel-specific formatting, formulas, etc.
This is also works with Word docs as well. Doug -----Original Message----- From: "Dawson, Michael" <[EMAIL PROTECTED]> Date: Sat, 15 Jan 2005 10:40:07 -0600 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=376 18&forumid=4#190580 I just recently tried this and it is great. http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA You have complete control over just about everything and you don't have to worry about Excel converting any HTML. M!ke -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
