Can we add HTML content to one of many sheets using cfspreadsheetobj?

<cfset objSpreadsheet = SpreadsheetNew("REGISTRO DE VENTAS") />					
				  <cfset SpreadSheetSetActiveSheet(objSpreadsheet, "REGISTRO DE VENTAS")/>	
				  <cfset SpreadsheetAddRow(objSpreadsheet,encabezadosMatrizVentas)>										  
				  <cfset SpreadsheetAddRows( objSpreadsheet, MatrizVentas) />

Instead of query I want to use html save content to export to excel in one of sheets

I didnt see anyone answering this, and maybe they did already but yes you can. You would use someting like this: <cfspreadsheet action="write" filename="Myspreadsheet.xlsx" sheet="MySheet1"> <tr> <td>Sheet 1 Foo</td> </tr> </cfspreadsheet> <cfspreadsheet action="write" filename="<Myspreadsheet.xlsx" sheet="MySheet2"> <tr> <td>Sheet 2 Bar</td> </tr> </cfspreadsheet>