spreadsheetAutoSizeColumn

Sets a column of the active sheet to auto-fit its contents. Rows and columns are 1-based. Because a headless engine has no font-metrics renderer, the workbook is written with Excel's best-fit flag and the spreadsheet application computes the exact pixel width when the file is opened. The fluent member form is autoSizeColumn(column) and autoSize() does the same for every column.

spreadsheetAutoSizeColumn(spreadsheetObj, column) → returns any

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

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

column numeric
Required

1-based column index to auto-size (1 = A).

Compatibility

RustCFML:

Not supported on wasm32.

Examples
Sample code invoking the spreadsheetAutoSizeColumn function

Best-fit column 1 after writing data.

wb = Spreadsheet("xlsx");
spreadsheetSetCellValue(wb, "A long name indeed", 1, 1);
spreadsheetAutoSizeColumn(wb, 1);
wb.write(expandPath("/out.xlsx"), true);

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

Fork me on GitHub