xls in Coldfusion

[Imperial, Bob]

Hi folks,

 

I am venturing into new territory in working with creating xls files
with multiple sheets. I've worked with creating basic spreadsheets in
Coldfusion using cfcontent and single queries, fairly easy and
straightforward. I need some direction as to how to go about creating an
xls file with multiple sheets in it. I have data to grab from 22
different tables and ideally each sheet within the excel file would be
based on these individual query result sets from these tables. Clueless
as to where to begin to pull this off or if it can even be done as I've
mentioned, so any and all help/guidance/direction would be greatly
appreciated. I work alone here unfortunately so this list and a couple
of others are my only resource to pull from aside from my collection of
books ;)

 

TIA

 

Bob Imperial

Department of Medicine

043B Macnider Hall, CB 7005

UNC  Chapel Hill, NC 27599

Phone: [phone]

Fax: [phone]

 

 "If you want truly to understand something, try to change it."

 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4807
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

[WIll Swain]

Hi Bob,

Check out Ben Nadel's POI utility for reading and writing to excel files.
http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea
d-And-Write-Excel-Files.htm

I've used it to read in files, not tried writing them with it, but it's all
good stuff, and looks like it will do what you need.

Will

-----Original Message-----
From: Imperial, Robert [mailto:bob_imperial@...]
Sent: 17 September 2009 17:42
To: cf-newbie
Subject: xls in Coldfusion


Hi folks,

 

I am venturing into new territory in working with creating xls files with
multiple sheets. I've worked with creating basic spreadsheets in Coldfusion
using cfcontent and single queries, fairly easy and straightforward. I need
some direction as to how to go about creating an xls file with multiple
sheets in it. I have data to grab from 22 different tables and ideally each
sheet within the excel file would be based on these individual query result
sets from these tables. Clueless as to where to begin to pull this off or if
it can even be done as I've mentioned, so any and all
help/guidance/direction would be greatly appreciated. I work alone here
unfortunately so this list and a couple of others are my only resource to
pull from aside from my collection of books ;)

 

TIA

 

Bob Imperial

Department of Medicine

043B Macnider Hall, CB 7005

UNC  Chapel Hill, NC 27599

Phone: [phone]

Fax: [phone]

 

 "If you want truly to understand something, try to change it."

 





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4809
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

[Paul Kukiel-2]

Hi Robert,

You can have a look at POI:

http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea
d-And-Write-Excel-Files.htm

Or wait patiently for ColdFusion 9 ( which uses POI I believe behind the
scenes ) with the new <cfspreadsheet /> tag.

Paul

-----Original Message-----
From: Imperial, Robert [mailto:bob_imperial@...]
Sent: Thursday, September 17, 2009 12:42 PM
To: cf-newbie
Subject: xls in Coldfusion


Hi folks,

 

I am venturing into new territory in working with creating xls files
with multiple sheets. I've worked with creating basic spreadsheets in
Coldfusion using cfcontent and single queries, fairly easy and
straightforward. I need some direction as to how to go about creating an
xls file with multiple sheets in it. I have data to grab from 22
different tables and ideally each sheet within the excel file would be
based on these individual query result sets from these tables. Clueless
as to where to begin to pull this off or if it can even be done as I've
mentioned, so any and all help/guidance/direction would be greatly
appreciated. I work alone here unfortunately so this list and a couple
of others are my only resource to pull from aside from my collection of
books ;)

 

TIA

 

Bob Imperial

Department of Medicine

043B Macnider Hall, CB 7005

UNC  Chapel Hill, NC 27599

Phone: [phone]

Fax: [phone]

 

 "If you want truly to understand something, try to change it."

 





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4808
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15