spreadsheetSetRepeatingRows

ColdFusion

Open app

Description

Specifies rows that must appear on every page when the sheet is printed.

Returns

None

History

ColdFusion (2025 release): Added the function.

Syntax

spreadsheetSetRepeatingRows(spreadSheetObject, rows)

spreadsheetSetRepeatingRows(spreadSheetObject, rows)

Parameters

Name

Required

Type

Description

spreadSheetObject

Yes

ExcelInfo

The Excel spreadsheet object to which you must set repeating rows.

rows

Yes

String

The range of rows to repeat on every printed page.

Example

SELECT * FROM ART

</cfquery>

theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art-repeat-rows.xls";

// create a spreadsheet object

theSheet=spreadsheetNew("SampleData")

// add rows from the table to the spreadsheet

spreadsheetAddRows(theSheet,art)

// set repeating rows

spreadsheetSetRepeatingRows(theSheet,"10-15")

// write the spreadsheet

spreadsheetWrite(theSheet,theFile,"yes")

</cfscript>

<cfquery name="art" datasource="cfartgallery"> SELECT * FROM ART </cfquery> <cfscript> theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art-repeat-rows.xls"; // create a spreadsheet object theSheet=spreadsheetNew("SampleData") // add rows from the table to the spreadsheet spreadsheetAddRows(theSheet,art) // set repeating rows spreadsheetSetRepeatingRows(theSheet,"10-15") // write the spreadsheet spreadsheetWrite(theSheet,theFile,"yes") </cfscript>

<cfquery name="art" datasource="cfartgallery">
    SELECT * FROM ART
</cfquery>
<cfscript>
    theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art-repeat-rows.xls";
    // create a spreadsheet object
    theSheet=spreadsheetNew("SampleData")
    // add rows from the table to the spreadsheet
    spreadsheetAddRows(theSheet,art)
    // set repeating rows
    spreadsheetSetRepeatingRows(theSheet,"10-15")
    // write the spreadsheet
    spreadsheetWrite(theSheet,theFile,"yes")
</cfscript>

Get help faster and easier

New user?