I don't know what this is worth since I did not implement it myself. A friend told me that he created an object that allowed him to mime the HTML data from the CF Web Site to Excel by creating a macro through the GUI and then using that MACRO with CFOBJECT to create a function that can take the format and color features between Excel and CF program intact. I will be trying to implement this soon, so if this is asked again and you all are still stuck. I will most my implementation. Rob >From: Rich Wild <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: export excel charts - COM and CF (vs MSChart?) >Date: Thu, 16 Nov 2000 15:16:29 -0000 >MIME-Version: 1.0 >Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id >MHotMailBBDD5999001D40042A08CF1F7A8C098A27; Thu Nov 16 08:45:59 2000 >Received: from bluemountain.e-mango.com ([195.217.219.253]) by >www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# >0-54969U100L100S0V35) with ESMTP id com for ><[EMAIL PROTECTED]>; Thu, 16 Nov 2000 10:32:33 -0500 >Received: by bluemountain.e-mango.com with Internet Mail Service >(5.5.2650.21)id <W1251NWQ>; Thu, 16 Nov 2000 15:16:37 -0000 >From [EMAIL PROTECTED] Thu Nov 16 08:46:46 2000 >Message-ID: ><[EMAIL PROTECTED]> >Return-Path: [EMAIL PROTECTED] > >Mark, > >I've posted the code here: > >http://www.cfcomet.com/cfcomet/forum/ViewThread.cfm?ThreadID=12000E3E-9979-4 >0B3-BABA4F2429E67135 > >hmmm - MSChart... to be honest and expose my utter lack of knowledge - I >didn't know you could - I can't seem to find an example of anyone doing it >through CFobject, but there's an asp version (which you could translate) >at: > > >http://www.4guysfromrolla.com/webtech/MSChartExample.shtml > >By the way, has anyone used Cold Fusion Graphlets ( >http://forums.allaire.com/cfo/graphlets.htm )?? or are they the >icky-spare-5-minutes java applets that they look like? (examples weren't >working) > >------------------------------------------------------- >Rich Wild >Senior Web Designer > >------------------------------------------------------- >e-mango.com ltd Tel: 01202 587 400 >Lansdowne Place Fax: 01202 587 401 >17 Holdenhurst Road >Bournemouth Mailto:[EMAIL PROTECTED] >BH8 8EW, UK http://www.e-mango.com >------------------------------------------------------- >This message may contain information which is legally >privileged and/or confidential. If you are not the >intended recipient, you are hereby notified that any >unauthorised disclosure, copying, distribution or use >of this information is strictly prohibited. Such >notification notwithstanding, any comments, opinions, >information or conclusions expressed in this message >are those of the originator, not of e-mango.com ltd, >unless otherwise explicitly and independently indicated >by an authorised representative of e-mango.com ltd. >------------------------------------------------------- > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: 16 November 2000 14:16 > > To: CF-Talk > > Subject: RE: export excel charts - COM and CF (vs MSChart?) > > > > > > > > Rich, > > > > I'm interested in seeing the macro, especially the gif export > > part. I am > > also wondering if people are using the MSChart object for this task, > > without Excel. Wouldn't this be less overhead than opening > > excel? Or does > > that not factor in if excel is already running on the server? > > > > Mark > > > > Mark Wimer > > American Bird Conservancy, c/o > > USGS-Patuxent Wildlife Research Center > > 12100 Beech Forest Road, Laurel, MD 20708-4038 > > Ph: 301-497-5596 Email: [EMAIL PROTECTED] > > > > > > > > Aha. > > > > If anyone is interested, I wrote a macro to handle the data > chart > > creation > > and gif export that runs whenever a certain cell's value changes. > > > > Through CFOBJECT I'll see if I can insert data - hence triggering the > > macro, > > exporting the gif. Then free the connection, move the file > > using cffile (or > > set the macro to save the gif in the webroot) and serve the gif using > > cfcontent or something similar. > > > > Just got to get it working now, but the theory is so far sound unless > > anyone > > can spot any glaring holes. ;) > > > > ------------------------------------------------------- > > Rich Wild > > Senior Web Designer > > > > ------------------------------------------------------- > > e-mango.com ltd Tel: 01202 587 400 > > Lansdowne Place Fax: 01202 587 401 > > 17 Holdenhurst Road > > Bournemouth Mailto:[EMAIL PROTECTED] > > BH8 8EW, UK http://www.e-mango.com > > ------------------------------------------------------- > > This message may contain information which is legally > > privileged and/or confidential. If you are not the > > intended recipient, you are hereby notified that any > > unauthorised disclosure, copying, distribution or use > > of this information is strictly prohibited. Such > > notification notwithstanding, any comments, opinions, > > information or conclusions expressed in this message > > are those of the originator, not of e-mango.com ltd, > > unless otherwise explicitly and independently indicated > > by an authorised representative of e-mango.com ltd. > > ------------------------------------------------------- > > > > > > > > > > > -----Original Message----- > > > From: Rich Wild [mailto:[EMAIL PROTECTED]] > > > Sent: 16 November 2000 07:59 > > > To: CF-Talk > > > Subject: export excel charts - COM and CF > > > > > > > > > > > > Has anyone tried the following: > > > > > > Connecting to an instance of excel thru com, inserting data, > > > running a macro > > > on that inserted data which creates a chart based on that > > > data, then exports > > > the chart as gif - then tidying up (close com connection, use > > > cffile to move > > > gif to webroot and serve). > > > > > > I'm not particulary worried about the first bit or the last > > > bit, but the > > > firing off the macro and exporting is the bit that I'm > > > seeking help about. > > > Nate Weiss had some handy tips about ensuring that the macro > > > security is set > > > to the proper level for the NT account that CF runs under, > > > which wasn't > > > something I had considered quite frankly... > > > Are there any other things I should be aware of? Opinions on > > > the efficiency > > > of such a task to serve up a few dynamic gif reports? (I've > > > looked at the > > > various graphing tags and none of them are suitable (read > > > limited) , and > > > cfx_graphicsserver is too pricey an option) > > > > > > Help appreciated. > > > > > > :) > > > ------------------------------------------------------- > > > Rich Wild > > > Senior Web Designer > > > > > > ------------------------------------------------------- > > > e-mango.com ltd Tel: 01202 587 400 > > > Lansdowne Place Fax: 01202 587 401 > > > 17 Holdenhurst Road > > > Bournemouth Mailto:[EMAIL PROTECTED] > > > BH8 8EW, UK http://www.e-mango.com > > > -------------------------------------------------------------- > > > ---------------------------------- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > Unsubscribe: > > http://www.houseoffusion.com/index.cfm?sidebar=lists or send > > a message with > > 'unsubscribe' in the body to [EMAIL PROTECTED] > > -------------------------------------------------------------- > > ---------------------------------- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: >http://www.houseoffusion.com/index.cfm?sidebar=lists or send a >message with 'unsubscribe' in the body to >[EMAIL PROTECTED] > > > > >---------------------------------------------------------------------------- >-------------------- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a >message with 'unsubscribe' in the body to >[EMAIL PROTECTED] >------------------------------------------------------------------------------------------------ >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a >message with 'unsubscribe' in the body to >[EMAIL PROTECTED] _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]