Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ColdFusion Microsoft Excel

Posted on 2000-05-03
2
Medium Priority
?
230 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 200 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. 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 :…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

971 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