Yes, I've done this with a Word doc before, as well. It does work great. I built a spreadsheet that is very dynamic, so I don't think that I could save as HTML because there are too many variations. I might be able to do it, but I felt it was easier to do it with the Java API.
Here is the link, if you are interested in how I used CF to create dynamic spreadsheets. You will need Excel to view the files. If you look at the generated spreadsheet, you can see that the rows are different for the dates. http://acelinkdev.evansville.edu/devfiles/javaexcel/salon/DailySalesShee tForm.cfm I think I may save this spreadsheet as HTML and see what it gives me. Thanks MAD -----Original Message----- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: Saturday, January 15, 2005 3:04 PM To: CF-Talk Subject: Creating .xls files with column headers 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-6F8A9F878188 D7CA 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190609 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
