Solved

ColdFusion Microsoft Excel

Posted on 2000-05-03
2
228 Views
Last Modified: 2013-12-24
I am trying to create a website for a local software company which will allow their customers (they sell software to health care organizations) to go online and check their data against everyone else.  The organizations send their info nightly to a main database.  The company wants me to see if it is possible to build a website which will allow the organization  for example, to go online and check the rate of their psychiatric patients who come back compared to other organizations.  They want to know if it is possible to have this info displayed back to the user via the internet as a microsoft excel graph.   So the user would choose the info they wanted to know, hit submit, their choices would be sent to the database checked against the parameters they chose and sent back to them as an Excel graph.  Is this possible?  I am trying to use coldfusion but have never used it so I am trying to learn it as well.  
0
Comment
Question by:peloke050300
2 Comments
 
LVL 2

Expert Comment

by:dlewis9
ID: 2777498
There's not really a built-in method to build an excel sheet with a graph already defined like that from Cold Fusion.  You could use Crystal Reports to create the graph from the data and display that through CF (see CFREPORT).

Or you could also use a Custom Tag that someone has written or write your own.  These aren't quite as pretty, however.  You can find Customer Tags for free or for a small charge by searching the Developer's Exchange on Allaire.com.

Here is one that I ran across:

http://www.net-smart-inc.com/CustomTags/BarGraphData.cfm

If you're looking to make it real pretty, you probably need to go with something that does something beyond just plain HTML.  There are some of these available as Custom Tags as well, such as:

http://www.cfxgraphicsserver.com/
0
 

Accepted Solution

by:
jsal218112 earned 50 total points
ID: 2801116
Yes, you can fairly easily output a comma separated file to the client
which the can be opened directly by Excel. However, if you want
to have it come up as a chart in Excel without the user needing to
fiddle around with it, I would try CFX_EXCEL available from the
dev gallery at
http://www.allaire.com/developer/gallery/index.cfm?ObjectID=7238&nocache=yes
and then create a default template.  Alternately, you could create
the chart on the server side and have it displayed as a .gif; there
are several different ways to do this. It depends several factors
such as whether your client machines all have Excel, how much
processing you want done on the client side, etc. We do some
things with healthcare data.

0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how to generate a csr to request an intermediate ca on os x 3 31
spamming  on Hosted svrs? 6 87
change time in cron 4 78
Public IP Address Amazon Servers 2 56
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now