streamingSpreadsheetNew

Creates a streaming spreadsheet object with a single sheet. Only a window of rows is held in memory, so it suits very large files.

streamingSpreadsheetNew([sheetName] [, randomAccessWindowSize]) → 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. streamingSpreadsheetNew
  5. CF2025+
  6. 0 Issue
  7. Edit
See Also:   spreadsheetnew   streamingspreadsheetread   streamingspreadsheetprocess   streamingspreadsheetcleanup   spreadsheetisstreamingxmlformat

Argument Reference

sheetName string

Name of the sheet. Defaults to sheet1.

randomAccessWindowSize numeric

Number of rows kept in memory. Defaults to 100.

Examples
Sample code invoking the streamingSpreadsheetNew function

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

Fork me on GitHub