Returns the width of a column in the active sheet of a spreadsheet workbook, in character widths (the same units setColumnWidth uses). Returns 0 when the column has no explicit width set. Columns are 1-based. The fluent member form is getColumnWidth(column).
spreadsheetGetColumnWidth(spreadsheetObj, column)
→ returns numeric
Set a width, then read it back.
wb = Spreadsheet("xlsx");
spreadsheetSetColumnWidth(wb, 2, 30);
writeDump(spreadsheetGetColumnWidth(wb, 2));
Expected Result: 30
Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.