ColdFusion 9.0 Resources |
SpreadsheetDeleteColumnsDescriptionDeletes the data from multiple columns of an Excel spreadsheet object. This function does not remove the columns. See alsoSpreadsheetAddColumn, SpreadsheetDeleteColumn, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatColumn, SpreadsheetFormatColumns, SpreadsheetShiftColumns Parameters
ExampleThe following example deletes the data from columns 2-4 and column 6 from a spreadsheet. <!--- 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); //Delete columns 2 though 4 and 6. SpreadsheetDeleteColumns(theSheet,"2-4,6"); </cfscript> <!--- Write the spreadsheet to a file, replacing any existing file. ---> <cfspreadsheet action="write" filename="#theFile#" name="theSheet" sheet=1 sheetname="courses" overwrite=true> |