I love the POI Utility http://www.bennadel.com/blog/865-POIUtility-cfc-Examples-For-Reading-And-Wri ting-Excel-Files-In-ColdFusion.htm
Mike Chytracek Managing Partner Ignite Solutions p. 312.239.0032 c. 815.302.3507 f. 866.839.7896 -----Original Message----- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 8:58 AM To: CF-Newbie Subject: writing excel files to a directory Hi Folks, I am trying to figure out how to go about taking data pulled from a MSSQL DB and writing it to an xls file, naming it and saving it to a specific directory with minimal user action. I know how to go about basic exporting to xls using <cfheader name="Content-Disposition" value="filename=IPAddresses_#ThisFile#.xls" /> <cfcontent type="application/vnd.ms-excel" /> but this requires more user interaction to save it to a specified directory. I'd like to be able to do it all in code in the simplest manner possible ... if possible :) I'm running CFMX7 Standard and Windows Server 2003, MSSQL 2000. The simpler the better for a slow mind here :) TIA Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3467 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
