spreadsheetToQuery

Converts the active sheet of a spreadsheet workbook to a CFML query. Row 1 supplies the column names (empty headers become column_N); each subsequent row becomes a query row with all cell values as strings. The fluent member form is toQuery().

spreadsheetToQuery(spreadsheetObj) → returns query

This function requires RustCFML.  Not supported on Lucee, Adobe ColdFusion, etc.
  1. CFDocs
  2. Functions
  3. Spreadsheet Manipulation Functions
  4. spreadsheetToQuery
  5. RustCFML
  6. 0 Issue
  7. Edit
See Also:   spreadsheetToArray   spreadsheetToCsv   spreadsheetToJson   spreadsheetNew

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

Compatibility

RustCFML:

Not supported on wasm32.

Examples
Sample code invoking the spreadsheetToQuery function

Write a header row and data rows, then read back a query.

wb = Spreadsheet("xlsx");
spreadsheetAddRow(wb, "name,score", 1, 1, false);
spreadsheetAddRow(wb, "Alice,90", 2, 1, false);
q = spreadsheetToQuery(wb);
writeDump(q);

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

Fork me on GitHub