RE: export excel charts - COM and CF (vs MSChart?)
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) I've used them - but not for a very long time. For a while, I thought they'd taken them out of the product, but they're still there. They've been in there since before CF 2, I think. They're not especially useful now, but they're better than nothing. For documentation on how to use them, find your old CF 2 manual, or look in the first edition of the Forta CFWACK book. There's a chapter that covers them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: export excel charts - COM and CF (vs MSChart?)
I don't know about it's integration with MS Excel, but Corda's PopChart Server is a great piece of software. It can export to GIF, PNG, and SWF. http://www.popchart.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 9:57 AM To: CF-Talk Cc: '[EMAIL PROTECTED]' Subject: RE: export excel charts - COM and CF (vs MSChart?) 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) I've used them - but not for a very long time. For a while, I thought they'd taken them out of the product, but they're still there. They've been in there since before CF 2, I think. They're not especially useful now, but they're better than nothing. For documentation on how to use them, find your old CF 2 manual, or look in the first edition of the Forta CFWACK book. There's a chapter that covers them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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]
RE: export excel charts - COM and CF (vs MSChart?)
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
RE: export excel charts - COM and CF (vs MSChart?)
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 - 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 - 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