Skip to content

ColdFusion spreadsheet functionality support

Jump to bottom Edit New page
Julian Halliwell edited this page Apr 14, 2025 · 8 revisions

Spreadsheet CFML supports all of the functionality offered by Adobe ColdFusion, although implementation details may vary in some cases.

Below is a list of ColdFusion spreadsheet functions with the corresponding library method:

Support for <cfspreadsheet action="read">

In Adobe ColdFusion, the SpreadsheetRead() function is limited to just returning a spreadsheet object, whereas the <cfspreadsheet action="read"> tag has a range of options for reading and returning data from a spreadsheet file.

The read() method in this library allows you to read a spreadsheet file into a query and return that instead of a spreadsheet object. It includes all of the options available in <cfspreadsheet action="read">.

<cfscript>
myQuery = spreadsheet.read( src=mypath, format="query" );
</cfscript>

The read() method also features the following additional options not available in ColdFusion:

  • fillMergedCellsWithVisibleValue
  • includeHiddenColumns
  • includeRichTextFormatting
  • csvDelimiter
  • queryColumnTypes

Full documentation of read()

Add a custom footer
Add a custom sidebar
Clone this wiki locally