spreadsheetGetCellFormat

Returns a struct of the formatting applied to a cell.

spreadsheetGetCellFormat(spreadsheet, row, column) → returns struct

Argument Reference

spreadsheet any
Required

The spreadsheet object.

row numeric
Required

Row number (1-based).

column numeric
Required

Column number (1-based).

Compatibility

RustCFML:

Not supported on wasm32. Returns only the keys the cell's style sets: bold, italic, fontsize, font, color, bgcolor, alignment, verticalalignment, wraptext and dataformat. Colors are #RRGGBB strings. Member form: getCellFormat(row, column).

Examples
Sample code invoking the spreadsheetGetCellFormat function

Format a cell, then read the format struct back.

wb = Spreadsheet("xlsx");
spreadsheetFormatCell(wb, { bold: true, bgcolor: "#ffcc00", alignment: "center" }, 1, 1);
writeDump(spreadsheetGetCellFormat(wb, 1, 1));

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

Fork me on GitHub