Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1570042771916-6c95e94f-8302-b0c0-07c2-062c00f0bff8.cfm

Created October 2, 2019 18:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trycf/5eff4bfbefdc0fc57a9caa336dd34f62 to your computer and use it in GitHub Desktop.
Save trycf/5eff4bfbefdc0fc57a9caa336dd34f62 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1570042771916-6c95e94f-8302-b0c0-07c2-062c00f0bff8.cfm
<cfset exportData.body = []>
<cfset exportData.body.append(["ACR", "", "", "", "Last"])>
<cfset exportData.body.append(["", "", "", "", "Last"])>
<cfset Workbook = SpreadSheetNew("Products")>
<cfset SpreadsheetAddRows( Workbook, exportData.body, 2, 1 )>
<!---Trigger download to excel file in browser--->
<cfheader name="content-disposition" value="attachment; filename=PulledData.xls">
<cfcontent type="application/msexcel" variable="#spreadsheetReadBinary(workbook)#" reset="true">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment