spreadsheetFormatCellRange

Formats the cells within the given range.

spreadsheetFormatCellRange (spreadsheetObj, format, startRow, startColumn, endRow, endColumn);

This function requires Adobe ColdFusion. Not supported on Lucee, OpenBD, etc.

Argument Reference for the spreadsheetFormatCellRange function

spreadsheetObj

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

format

Required: Yes
A structure that contains format information.

startRow

Required: Yes
The number of the first row to format.

startColumn

Required: Yes
The number of the first column to format.

endRow

Required: Yes
The number of the last row to format.

endColumn

Required: Yes
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> 

Fork me on GitHub