Jingle Bells
Ha! You think thats bad?? Try living in the snow belt of the great lakes (ie...upstate nyseasonal depression capital haha) ~| 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:262069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Microsoft Excel
Yep that helps! Both of these sound great, but i am not exactly sure on how to go about coding this. Subject: RE: ColdFusion and Microsoft Excel From: Ben Nadel Date: Mon, 27 Nov 2006 15:45:37 -0500 Thread: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:49062#261780 The simple solution (but not the *best*): Create the Excel table using very simple HTML in a ColdFusion string buffer (CFSaveContent). Then save that file to a temporary file (CFFile to a file in a temp directory, possibly GetTempDirectory()). Use CFMailParam tag inside of CFMail to attach the File (FILE attribute). Make sure SPOOLING is NOT enabled. Send the email. Delete the temporary file. You have to make sure not to spool as you might delete the file before the email is sent. If you cannot control this, you can safe the file to a temp directory then just clear that directly periodically (say, every night or so). Does that help? . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ 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:261854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion and Microsoft Excel
Ok I understand everything except this chunk of bad boy: !--- Get xls file name. --- cfset strXlsFile = REReplace( strTempFile, \.[a-z]+$, .xls, ONE ) / Thank you so much for your help by the way. Are you single ;-P ? ~| 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:261892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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:261914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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:261779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4