cfdocs

spreadsheetFormatColumns

Formats the contents of a multiple columns of an Excel spreadsheet object.

spreadsheetFormatColumns(spreadsheetObj, format, columns)

returns void

Argument Reference

Name	Type	Required	Default	Description
spreadsheetObj	variableName	Yes		The spreadsheet object for which formatting will be applied
format	string	Yes		A structure containing the formatting information
columns	string	Yes		A string containing comma-separated column numbers or column ranges

Tag Example

<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;"; 
     spreadsheetFormatColumns(s,format1,"1-3"); 
     </cfscript> 
 <cfdump var="#s#" /> <cfheader name="Content-Disposition" value="inline; filename=testFile.xls">  <cfcontent type="application/vnd.msexcel" variable="#SpreadSheetReadBinary(s)#">

This site is open source. Improve this page.