Gabrielle, It really depends no the situation. THIS solution works for me a LOT. I do find, however, that it breaks on really really large files. I think Excel has trouble parsing the HTML into whatever internal format it uses. The benefits though is that it is easy to add things like CSS (borders, font-sizes, font-colors, etc).
If you don't need any formatting or design type stuff, sometimes a CSV (plain text file) is best (and most light weight). The downside though is that the end user might have to import the data manually (not sure though). You have less control, regardless. You cannot tell the columns how to load (treat as text vs. treat as numbers - something you can mess with using HTML version). The *best* solution might be to use some sort of Excel COM object (as other people mentioned), but that has some serious overhead to it, not to mention the buying of third party projects OR the installing of some Java packages. It however, creates REAL Excel documents. I would use this only when you need maximum control (or if you need to import FROM an excel file). For small to moderate things, though, the HTML version has worked great for me. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Gabrielle Mack [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 3:36 PM To: CF-Talk Subject: ColdFusion and Microsoft Excel This is a great solution. But what, dare i ask, would you consider to be the *best*? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
