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

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

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/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.