spreadsheetFormatCell

Formats the contents of a single cell of an Excel spreadsheet object.

spreadsheetFormatCell(spreadsheetObj, format, row, column) → returns void

  1. CFDocs
  2. Functions
  3. ColdFusion 9 New Functions and Tags
  4. spreadsheetFormatCell
  5. CF9+
  6. BD
  7. 0 Issue
  8. Edit
See Also:   SpreadsheetFormatColumn   SpreadsheetFormatColumns   SpreadsheetFormatRow   SpreadsheetFormatRows

Argument Reference

spreadsheetObj any
Required

The spreadsheet object for which formatting will be applied

format struct
Required

A structure containing the formatting information

row numeric
Required

The row the cell to format is in

column numeric
Required

The column the cell to format is in

Examples
Sample code invoking the spreadsheetFormatCell function 

<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 ---> 
 <cfset Spreadsheetformatcell(sheet,{dataformat="@"},2,2) > 
 <cfdump var="#s#" /> <cfheader name="Content-Disposition" value="inline; filename=testFile.xls">  <cfcontent type="application/vnd.msexcel" variable="#SpreadSheetReadBinary(s)#">

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub