spreadsheetMergeCells

Merges a rectangular block of two or more Excel spreadsheet object cells.

spreadsheetMergeCells(spreadsheetObj, startrow, endrow, startcolumn, endcolumn) → returns void

spreadsheetMergeCells Argument Reference

spreadsheetObj variableName
Required

No Help Available

startrow numeric
Required

No Help Available

endrow numeric
Required

No Help Available

startcolumn numeric
Required

No Help Available

endcolumn numeric
Required

No Help Available

Examples sample code invoking the spreadsheetMergeCells function


Script Example

<cfset q = queryNew("Name,Beers,Vegetables,Fruits,Meats", "cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer")> 
  <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 ---> 
   <cfscript> 
   Spreadsheetmergecells(s,1,1,1,2); 
 </cfscript> 
 <cfoutput> 
 
 <cfdump var="#s#" /> 
 <cfheader name="Content-Disposition" value="inline; filename=testFile.xls">  <cfcontent type="application/vnd.msexcel" variable="#SpreadSheetReadBinary(s)#">
 </cfoutput> 

Fork me on GitHub