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]
