Excel charts

[Renoyl]

Is there a method by which you can create charts from excel spreadsheet information using ColdFusion to display on a web page?

Thanks

 

[codecentric]

Another way of doing it is using Allaire's version of Java, JRun. Or any JVM should be good enough. I'm doing it myself and its pretty cool.

CF 5 will also soon have charting capabilities

Lawrence

info@codecentric.com

 

[strantheman]

You need to use the CFCONTENT tag, use the mime type of XCEL documents, and the file you specify in the CFCONTENT tag contains your data.

XCEL will read HTML table tags and interpret them properly for display.

Just build HTML tables the way you would like to see them in XCEL, save that file, use CFCONTENT to pull that file.

 

[Renoyl]

I appreciate the responses. I need to produce line charts and I need the tag/software to support negative values. If I use the MIME with CFCONTENT, won't that open up something in Excel on a users desktop. I don't want that to happen. I want a dynamic chart that pulls from a datasource. Any thoughts?

 

[KevinFSI]

If you have money to spend on it, I saw a great product at the CF Dev. Conference last Nov. There was a company there called Corda. They had a good product called PopChart, and since they're an allaire partner, the ColdFusion and Chart code should mix together easily.

Look at:

http://www.popchart.com

I really like what I see, but we don't have any use for charts like that here. However, I've kept them in the back of my mind just in case.
Kevin
slanek@ssd.fsi.com

 

[strantheman]

I thought you said you wanted to produce XCEL documents, but I see now. You just want to produce reports based on data in a database? What does excel have to do with that?

You're looking for a reporting system then? I think Kevin is leading you in the right direction as far as a 3rd party solution... should be able to conform it to your type of data.

Do you have a more specific question?