spreadsheetToJson

Converts the active sheet of a spreadsheet workbook to a JSON string: an array of row objects where row 1 supplies the keys (empty headers become column_N). When pretty is true the JSON is indented. The fluent member form is toJson(pretty).

spreadsheetToJson(spreadsheetObj [, pretty]) → returns string

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

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

pretty boolean
Default: false

True to pretty-print the JSON (default false).
Values:
  • true
  • false

Compatibility

RustCFML:

Not supported on wasm32.

Examples
Sample code invoking the spreadsheetToJson function

Export a sheet as a JSON array of row objects.

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

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

Fork me on GitHub