Description
Formats the cells within the given range.
Returns
Nothing
Category
Microsoft Office Integration
Function syntax
SpreadsheetFormatCellRange (spreadsheetObj, format, startRow, startColumn, endRow, endColumn)
See also
SpreadsheetFormatCell, SpreadsheetFormatColumns, SpreadsheetFormatRow, SpreadsheetFormatRows
History
ColdFusion 9.0.1: Added the function. Supports preformatting of a cell while you use this function.
Parameters
Parameter |
Description |
|---|---|
spreadsheetObj |
The Excel spreadsheet object for which you want to format the cells. |
format |
A structure that contains format information. |
startRow |
The number of the first row to format. |
startColumn |
The number of the first column to format. |
endRow |
The number of the last row to format. |
endColumn |
The number of the last column to format. |
Example
| <!--- 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=SructNew() 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> |
