Solved

ColdFusion Microsoft Excel

Posted on 2000-05-03
2
229 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
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…

734 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