Converts the active sheet of a spreadsheet workbook to an array of row-arrays: a raw grid of cell values (all as strings), one inner array per row. The fluent member form is toArray().
spreadsheetToArray(spreadsheetObj)
→ returns array
Write a small grid and read it back as an array of arrays.
wb = Spreadsheet("xlsx");
spreadsheetSetCellValue(wb, "a", 1, 1);
spreadsheetSetCellValue(wb, "b", 1, 2);
spreadsheetSetCellValue(wb, "1", 2, 1);
writeDump(spreadsheetToArray(wb));Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.