streamingSpreadsheetProcess

Reads a sheet with streaming and calls a function for each row. Returns the processed streaming spreadsheet object.

streamingSpreadsheetProcess(source [, options], rowProcessor) → returns any

This function requires Adobe ColdFusion 2025 and up. Not supported on Lucee, etc.

Argument Reference

File path of the spreadsheet to read.

Struct of options. Keys: sheetName, async, randomAccessWindowSize.

Function called for each row. It receives the spreadsheet object and the row number, and must return the spreadsheet object.

Examples

Sample code invoking the streamingSpreadsheetProcess function

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

Argument Reference