spreadsheetSetRepeatingRows

Sets rows that repeat on every printed page.

spreadsheetSetRepeatingRows(spreadsheet, rows) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

rows string
Required

Range of rows to repeat, such as 1:1.

Compatibility

RustCFML:

Not supported on wasm32. Implemented with the _xlnm.Print_Titles defined name. Member form: setRepeatingRows(rows).

Examples
Sample code invoking the spreadsheetSetRepeatingRows function

Row 1 repeats at the top of every printed page.

wb = Spreadsheet("xlsx");
spreadsheetSetRepeatingRows(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