POI Utility ColdFusion Component : Kinky Solutions : A Student's Perspective by Ben Nadel

Overview CFHttp Session CSS Rule Kinky Calendar Kinky eCards Kinky File Explorer POI Utility

The POIUtility.cfc is a ColdFusion component that helps you read Microsoft Excel files into ColdFusion queries as well as convert ColdFusion queries into multi-sheet Microsoft Excel files.

Features

• Optional Header Row.
• Basic CSS style definitions for header, row, and alternating row.
• Write single or multiple Excel sheets at one time.
• Read entire workbook into array of sheets or read in single sheet.

POI ColdFusion Custom Tag Features

• Create Excel documents using ColdFusion custom tags.
• Write Excel file to file server or to a ColdFusion variable (or both).
• CSS control at the global, column, row, and cell levels (with proper cascading).
• Date and Number mask support.

Downloads

Build 2008/09/24

This release has a bug fix and a new feature. Thanks to the masterful problem solving and guidance of Nathan Mische, I have been able to fix the "bleeding" problem that some people have been experiencing in Microsoft Excel 2007. Also, thanks to Chris Pijl who showed me how to set the default zoom of a workbook sheet.

This build fixed several known bugs:

• "Style Bleed" as seen on some Excel 2007 documents.

Build 2008/08/08

I have added the formula support to the ColdFusion 7 version of the custom tags. I have also fixed the issue in which empty cells were not getting formatted.

Build 2008/08/04

I have added support for formulas and cell aliasing for the ColdFusion custom tags. Currently, this realease has only updated the ColdFusion 8 version of the tags. Soon, the ColdFusion 7 version should be compatible also.

Build 2008/08/01

The custom tags in this release were completely rearchitected. Instaead of using a new instance of the CSSRule.cfc for every cell, I am not creating one instance of it and caching it in the document.cfm tag. Then, rather than using it to house the CSS properties, I am simply using it as a utility and passing "structs" to and from it. This has had significant performance increases.

I have also moved this performance increases over to the CFMX 7 compatible version and updated the one or two bugs for true CFMX 7 compatibility.

Build 2008/06/10

This is a very exciting release because it now contains a ColdFusion MX7 compatible version of the custom tag library thanks to Dan Wilson. I will be maintaining this version going forward in parallel with all the new development (it is stored in a sub directory labelled "coldfusion_mx7". I have also added the ability to set the print orientation of each sheet (to Portrait or Landscape).

Build 2008/06/06

I have added the ability to create freeze panes. This can be done by setting the FreezeRow and FreezeColumn attributes of the Sheet tag; or, it can be done by setting Freeze="true" on either the Column tag or the Row tag. I have also updated the branded template example to use a better branded template with my corporate logo.

This build fixed several known bugs:

• Invalid DateFormat error.
• Font-Size error in POICSSRule.cfc

Build 2008/05/29

This build fixed several known bugs:

• "Too Many Formats" error fixed via cached cell styles.
• Manual index use and ColSpan.

Build 2008/03/25

This build adds a whole new way to create Excel documents using ColdFusion custom tags. These custom tags give you very granular control over the formatting of the Excel document using CSS-based formatting.

Build 2007/07/26

This build does not add any functionality, but comes bundles with some basic examples on how to read and write Microsoft Excel files using ColdFusion and the POIUtility.cfc

Build 2007/07/12

This build does not come with any examples or documentation. The next build will. This build fixed several known bugs:

• Undefined query for empty sheets.
• Handle NULL rows.
• Handle NULL cells.
• Closing file input stream to OS doesn't lock file.