Formats the contents of a multiple rows of an Excel spreadsheet object.
spreadsheetFormatRows(spreadsheetObj, format, rows)
returns void
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
| spreadsheetObj | any | Yes | The spreadsheet object for which formatting will be applied | |
| format | struct | Yes | A structure containing the formatting information | |
| rows | string | Yes | A string containing comma-separated row numbers or row ranges |
<cfset q = queryNew("Name,Beers,Vegetables,Fruits,Meats", "cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer")>
<!---<cfloop index="x" from="1" to="10">--->
<cfset queryAddRow(q)>
<cfset querySetCell(q, "Name", "John")>
<cfset querySetCell(q, "Beers", "1")>
<cfset querySetCell(q, "Vegetables", "1")>
<cfset querySetCell(q, "Fruits", "1")>
<cfset querySetCell(q, "Meats", "1")>
<cfset mySheet = spreadsheetNew( "Test" ) />
<!--- Make a spreadsheet object --->
<cfset s = spreadsheetNew()>
<!--- Add header row --->
<cfset spreadsheetAddRow(s, "Name,Beers,Vegetables,Fruits,Meats")>
<!--- Add query --->
<cfscript>format1.font="Courier";
format1.fontsize="10";
format1.color="dark_blue;";
spreadsheetFormatRows(s,format1,"1-2");
</cfscript>
<cfdump var="#s#" /> <cfheader name="Content-Disposition" value="inline; filename=testFile.xls"> <cfcontent type="application/vnd.msexcel" variable="#spreadSheetReadBinary(s)#">