Mike, Glad you like that. I am actually working on an update for it right now that works using ColdFUsoin custom tags that should give you MUCH more control over the output and formatting.
-Ben On 3/20/08, Mike Chytracek <[EMAIL PROTECTED]> wrote: > > 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:3468 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
