Charts in Excel

[JHollemans]

I like to create an Excel file on the fly containing one or more charts. I found a method to create an Excel file by ColdFusion in this thread, but how do I add a chart?

Thanks in advance,

J Hollemans

[Stressed_Simon]

Create the chart in Excel then save it as HTML, then use CF to recreate that then use CFCONTENT

[JHollemans]

Thanks for your reply Simon!

I Found out that it's posible to render a html-file by Excel, but is there any documentation of this format?
For example, to render a formula I should use this code (which is no default html):

[Stressed_Simon]

That is correct just make sure if the number of columns you are totalling up is dynamic then the final cell eg SUM(A1: A4) will need ot be dynamic too!

[JHollemans]

That's clear Simon, but I asked for some documentation, do you perhaps know where to find it?
Thanks in advance!

[Stressed_Simon]

I don't believe there is any documentation for this, I worked this out myself so I don't have anything for you to look at I afraid.

[Newsgroup_User]

> I Found out that it's posible to render a html-file by Excel, but is there any
> documentation of this format?
> For example, to render a formula I should use this code (which is no default
> html):

MS file formats are not open-source, so you might struggle a bit there.
But doing a search on the Microsoft site might be a good place to start.

--
Adam