Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. <cfset exportData.body = []>
  2. <cfset exportData.body.append(["ACR", "", "", "", "Last"])>
  3. <cfset exportData.body.append(["", "", "", "", "Last"])>
  4.  
  5. <cfset Workbook = SpreadSheetNew("Products")>
  6. <cfset SpreadsheetAddRows( Workbook, exportData.body, 2, 1 )>
  7.  
  8. <!---Trigger download to excel file in browser--->
  9. <cfheader name="content-disposition" value="attachment; filename=PulledData.xls">
  10. <cfcontent type="application/msexcel" variable="#spreadsheetReadBinary(workbook)#" reset="true">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement