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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
