Skip to main content
Participant
July 12, 2007
Question

Charts in Excel

  • July 12, 2007
  • 1 reply
  • 654 views
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
This topic has been closed for replies.

1 reply

Inspiring
July 12, 2007
Create the chart in Excel then save it as HTML, then use CF to recreate that then use CFCONTENT
Participant
July 16, 2007
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):

Inspiring
July 16, 2007
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!