Easiest way is to mock up the spreadsheet you want in Excel, with the multiple workbooks, then export it as XML. Then you can view the generated XML and recreate it dynamically from your Cold Fusion app. Only problem is that this won't work as easily on versions of Excel prior to 2003, or on the Mac.
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claude Raiola Sent: Tuesday, 15 January 2008 9:18 AM To: [EMAIL PROTECTED]; [email protected] Subject: [cfaussie] Cold Fusion Exporting To Excel Hi, I have a bookings table containing details of guests who have stayed rooms within a hotel I am wanting to output the table grouping the data into room number and then sorting the bookings by arrival date. All that is easy However I am wanting the output to be stored in one single excel spreadsheet where the each room number has its own tab (workbook) within the single spreadsheet file and then the bookings relevant to each room number appear within each workbook Kind Regards Claude Raiola B.Econ(Acc.); B.Hotel Mngt. Mobile: 0414 228 948 Phone: 07 3666 0981 Fax: 07 3319 6444 Websites: www.WebsiteSolutions.com.au www.AustralianAccommodation.com www.AccommodationNewZealand.com www.HospitalityPurchasing.net www.Samaris.net From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Georgiou Sent: Tuesday, 15 January 2008 7:52 AM To: [EMAIL PROTECTED] Subject: Re: [coldfusion-howto] SQL Statement needs a line break? thanks all! I will try all these suggestions and let you know.. George On Jan 14, 2008 1:46 AM, Hank Miller <[EMAIL PROTECTED]> wrote: > You can try... > > USE [mydb]; > SET ANSI_NULLS ON; > SET QUOTED_IDENTIFIER ON; > SET ANSI_PADDING ON; > CREATE TABLE [dbo].[tbl_test]( > > Get rid of the "GO"s. > > -hankcfman > > ----- Original Message ---- > From: George Georgiou <[EMAIL PROTECTED] <george1977%40gmail.com>> > To: [EMAIL PROTECTED] <coldfusion-howto%40yahoogroups.com> > Sent: Sunday, January 13, 2008 1:47:29 PM > Subject: [coldfusion-howto] SQL Statement needs a line break? > > Hi there, > > I am an experienced coldfusion developer (7 years now). This is the first > time i see this. I am trying to create a table from a CFQuery. I have > something like : > > <cfquery .... > > USE [mydb] > GO > SET ANSI_NULLS ON > GO > SET QUOTED_IDENTIFIER ON > GO > SET ANSI_PADDING ON > GO > CREATE TABLE [dbo].[tbl_test]( > . > .... etc etc etc > > If I paste this in the query analyzer it works great. If I run this > through > a cfquery I get an error like [Macromedia][SQLServer JDBC > Driver][SQLServer]Incorrect syntax near 'GO'. > > The problem is that it seems that coldfusion sends the sql statement as a > single line (i.e. no line-breaks). > > Is there any way to add a 'line-break' to the cfquery after each sql-line? > I > have tried using the #chr(10)#, the #chr(13)# (and also the <br>) but it > does not work. In other words I have tried something like: > > USE [mydb] #chr(10)# > GO#chr(10)# > SET ANSI_NULLS ON #chr(10)# > GO #chr(10)# > SET QUOTED_IDENTIFIER ON #chr(10)# > GO #chr(10)# > > etc.... > > but still, this doesn't work :-( > > Any ideas on how to do this ? > > thanks, > George > > [Non-text portions of this message have been removed] > > ~~~~~~~~~ > *** Yahoo's No. 1 and the biggest group of ColdFusion Developers > > ColdFusion MX Hosting - 250 MB Space/5 GB monthly Bandwidth for just > $19.99/year. Free Setup, ASP.NET <http://asp.net/>, HELM Control Panel. > http://www.hostingatoz.com. We also offer ColdFusion Reseller Hosting > Plans. > > Post message: [EMAIL PROTECTED]<coldfusion-howto%40yahoogroups.com> > Subscribe: [EMAIL PROTECTED]<coldfusion-howto-subscribe%40yahoogroups.com> > Un-Subscribe: [EMAIL > PROTECTED]<coldfusion-howto-unsubscribe%40yahoogroups.com> > > ... > > Yahoo! Groups Links > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] __._,_.___ Messages in this topic (7) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Calendar ~~~~~~~~~ *** Yahoo's No. 1 and the biggest group of ColdFusion Developers ColdFusion MX Hosting - 250 MB Space/5 GB monthly Bandwidth for just $19.99/year. Free Setup, ASP.NET, HELM Control Panel. http://www.hostingatoz.com. We also offer ColdFusion Reseller Hosting Plans. Post message: [EMAIL PROTECTED] Subscribe: [EMAIL PROTECTED] Un-Subscribe: [EMAIL PROTECTED] ... MARKETPLACE Earn your degree in as few as 2 years - Advance your career with an AS, BS, MS degree - College-Finder.net. Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Recent Activity ยท 4 New Members Visit Your Group Yahoo! News Odd News You won't believe it, but it's true New web site? Drive traffic now. Get your business on Yahoo! search. Drive Traffic Sponsored Search can help increase your site traffic.. __,_._,___ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
