Tipical Charlie

Excel File Processing in CFML: Reading and Writing Dozens of Ways

by Charlie Arehart

Charlie gives us a long list of ways in which you might process your Excel file in ColdFusion. You'd be surprised at what options are out there!

As promised, you'll find the following list of links that correspond to the footnotes in the article. (Please note that footnote 7 was accidentally left out of the article. The description in footnote 7 below is the same as the text in the article.)

1 CFComet Tools List

2 Adobe Technote: Accessing Complex COM Objects in ColdFusion MX Using Java Stubs

3 Adobe Technote: ColdFuson MX: Using Application Scope to Improve COM Performance

4 Adobe Technote: Issues with Using COM Objects in ColdFusion MX

5 QueryToCSV by Qasim Rasheed

6 QueryToCSV UDF Update by Aaron Longnion

7 The GenerateExcel UDF7 from Topper

8 ColdFusion docs on CFHTTP

9 Parsing CSV Data Using ColdFusion (Ben Nadel) and
ColdFusion CFHttp To Query Much Faster Than Java Buffered Reader

10 Coldfusion and Yahoo CSV Stock Quote service (blog entry by Alex Le)

11 CSV Files and Coldfusion - a New Approach (Mark Kruger)

12 Dynamic Excel File from ColdFusion (Jehiah Czebotar)

13 How Can ColdFusion Generate an Excel File (Jeremy Peterson, entry in the ColdFusion Cookbook)

14 ColdFusion Documentation Pages on CFContent

15 ColdFusion 6 Documentation Pages

16 Query2Excel

17 Creating And Streaming Simple Microsoft Excel Files With ColdFusion (Ben Nadel)

18 Modify Excel Spreadsheets with ColdFusion the Easy Way (Jason Delmore)

19 Reading a Microsoft Excel File in ColdFusion Using JExcel API (Ben Nadel)

20 Creating real Excel files using JExcelAPI and ColdFusion (Denny)

21 Matt Williams' Blog Entries on JXLS

22 Generating Excel spreadsheets from CFMX

23 ColdFusion POIUtility.cfc Updates And Bug Fixes (Ben Nadel)

24 Populating An Existing Formatted Excel Document Using ColdFusion And POI (Ben Nadel)

25 POI Example from Chapter 27 of Ben Forta's ColdFusion 7 Advanced Book

26 The CFHSSF CFC

27 CFX_ExcelQuery

28 CFX_Query2Excel

29 CFX_Excel

30 CFX_Query2Excel

31 CFX_Excel2Query

32 ColdFusion Documentation on Integration with .NET

33 ColdFusion .NET Integration (Raymond Camden)

34 Microsoft Support Article about Using OLE DB to Directly Access Office Files

35 ColdFusion Documentation on Using ODBC and JDBC to Open Excel or CSV Files

36 ColdFusion Techniques: Test & Excel ODBC (CFDJ Article)

37 ColdFusion Q&D: Reading Excel Data (Christopher Wigginton)

38 How Do I Return a Query from an Excel File (ColdFusion Cookbook Entry by Kyle Hayes)

39 Creating a Query from an Excel File (Kyle Hayes)

40 jacoZoom Driver

41 Adobe Technote: Dynamic Data Sources in ColdFusion MX

42 Building Reports with ColdFusion MX 7 (Adobe Devnet)

43 Using the ColdFusion Report Builder (Adobe Devnet)

44 Excel's Web Query (CFDJ, December 2001)

45 Creating Microsoft Excel Documents With ColdFusion and XML (Ben Nadel)

46 Creating Multiple Tabs in Excel with Coldfusion (Todd Sharp)

47 Building Excel Spreadsheets via XML (EasyCFM Tutorial by Kris Brixon)

48 Wikipedia Entry on OOXML (Open Office XML)

49 Volume 3 of the ColdFusion 8 Web Application Construction Kit, Advanced Application Development

50 Forta.com Link to the ColdFusion 8 Web Application Construction Kit (Containing Source Code)

• Data: How do you make it work for you
• Do More, Code Less
• ColdFusion 8 Special Edition
• Focus on the User Interface
• Special Business Issue
• Object Oriented ColdFusion
• ColdFusion MX 7 Features You Need to Know