Believe it or not --
Windows 98 and higher has an Import to Excel function.
Just right mouse click on the coldfusion table you want to
turn into Excel, and a menu comes up saying Import to
Excel. It is NOT in Windows 95 though.
Julia Computer Consulting
Web Design @ Reasonable Prices
PO Box 279
Watertown MA 02471-0279
Email: [EMAIL PROTECTED]
http://www.juliagreen.com
Phone: 617-926-3413
Fax: 617-812-5935
----- Original Message -----
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 3:39 PM
Subject: CF to excel
> How flexible is the process of generating excel files?
> I need to have an output that is dynamic for the columns and rows.
> For example:
>
> #student# #student# #student# #student#
> #Skill# #grade# #grade# #grade# #grade#
> #Skill# #grade# #grade# #grade# #grade#
> #Skill# #grade# #grade# #grade# #grade#
>
> Translating into:
> JohnSmith JanSmith SamJones sandyJones
> Reading C A A B
> Math B A B A
> English B B A C
>
> My tables are normalized. There are many tables that make this info.
> 1. One reference table that lists all the skills.
> 2. One table that shows student information.
> 3. One table that lists the studentID/skillID/Grade (hooks the student
info
> with the skills reference table).
> 4. One reference table that lists the quarter and dates of the quarter so
> only the current quarter prints out.
> Is this possible?
> What are the steps to making it so? Do I need to make the information
into
> an array(s) first?
> I've read the how to from Ben's CF5 book and the tutorial from
cfcomet.com-
> but of course I want to make things more difficult.
> Thanks in advance.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
