streamingSpreadsheetRead

Reads a sheet from an Excel file using streaming and returns it as a query, CSV string or HTML string.

streamingSpreadsheetRead(source [, options]) → returns any

This function requires Adobe ColdFusion 2025 and up.  Not supported on Lucee, etc.
  1. CFDocs
  2. Functions
  3. ColdFusion 2025 New Functions and Tags
  4. streamingSpreadsheetRead
  5. CF2025+
  6. 0 Issue
  7. Edit
See Also:   streamingspreadsheetnew   streamingspreadsheetprocess   streamingspreadsheetcleanup   spreadsheetread

Argument Reference

source string
Required

File path of the spreadsheet to read.

options struct

Struct of read options. Keys: sheetName, format (query, csv or html), headerRow, rows, columns, destinationFilePath, excludeHeaderRow, randomAccessWindowSize.

Examples
Sample code invoking the streamingSpreadsheetRead function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub