spreadsheetFormatCellRange Code Examples and CFML Documentation

Argument Reference

spreadsheetObj any
Required

The Excel spreadsheet object for which you want to format the cells.

format struct
Required

A structure that contains format information.

startRow numeric
Required

The number of the first row to format.

startColumn numeric
Required

The number of the first column to format.

endRow numeric
Required

The number of the last row to format.

endColumn numeric
Required

The number of the last column to format.

Examples

Sample code invoking the spreadsheetFormatCellRange function

Tag Syntax

Checking to see if the region is present in the cache

<!--- Get the spreadsheet data as a query. ---> 
 <cfquery 
     name='courses' datasource='cfdocexamples' 
     cachedwithin='#createTimespan(0, 6, 0, 0)#'> 
     SELECT CORNUMBER,DEPT_ID,CORLEVEL,COURSE_ID,CORNAME,CORDESC,LASTUPDATE 
     FROM COURSELIST 
 </cfquery> 
 <cfscript> 
     ///We need an absolute path, so get the current directory path. 
     theFile=getDirectoryFromPath(getCurrentTemplatePath()) & 'courses.xls'; 
     //Create a new Excel spreadsheet object and add the query data.    
 theSheet = spreadsheetNew('CourseData'); 
     spreadsheetAddRows(theSheet,courses); 
     // Define a format for the column. 
     format1=structNew() 
     format1.font='Courier'; 
     format1.fontsize='10'; 
     format1.color='dark_blue;'; 
     format1.italic='true'; 
     format1.bold='true'; 
     format1.alignment='left'; 
     spreadsheetFormatCellRange(theSheet,format1, 3,4,30,10); 
 </cfscript> 
 <!--- Write the spreadsheet to a file, replacing any existing file. ---> 
 <cfspreadsheet action='write' filename='#theFile#' name='theSheet' sheet=1 sheetname='courses' overwrite=true>

spreadsheetFormatCellRange

Argument Reference

spreadsheetObj any Required

format struct Required

startRow numeric Required

startColumn numeric Required

endRow numeric Required

endColumn numeric Required

Examples Add An Example Sample code invoking the spreadsheetFormatCellRange function