SpreadsheetML might be the best way to do this. The quick and easy way to create a SpreadsheetML file is to create a mockup of your spreadsheet in Excel, then save it as XML. This creates an XML file with all the formatting you need. All you need to do is recreate that file with dynamic data, and you've got an instant Excel spreadsheet.
More info here: http://www.javaworld.com/javaworld/jw-07-2004/jw-0712-officeml.html Bye! > -----Original Message----- > From: Gabrielle Mack [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 28 November 2006 7:40 AM > To: CF-Talk > Subject: ColdFusion and Microsoft Excel > > Question: > I am a newb to CF and I have been assigned the daunting task > of dynamically generating an excel file with absolutely no > user action entailed. We currently have code that takes HTML > and throws it in an excel file, but the user is prompted to > download/save it. We dont want that. I have seen many > different solutions given here, but i am not sure which to > follow. The overall task is to create and excel file on the > fly and then email it out to a user. Any help is appreciated. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
