spreadsheetSetRepeatingRows

Sets the print-title rows of the active sheet in a spreadsheet workbook, so the given row range repeats at the top of every printed page. The range is an A1 address such as "1:1" or "1:3". Implemented via the _xlnm.Print_Titles defined name. The fluent member form is setRepeatingRows(rows).

spreadsheetSetRepeatingRows(spreadsheetObj, range) → returns any

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

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

rows string
Required

A1 address of the row range to repeat on every printed page, e.g. "1:1".

Compatibility

RustCFML:

Not supported on wasm32.

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