cfdocs

spreadsheetReadBinary

Reads spreadsheet file into a binary object

spreadsheetReadBinary(spreadsheetObj)

returns void

Argument Reference

Name	Type	Required	Default	Description
spreadsheetObj	variableName	Yes		Spreadsheet file

Tag Example

<cfset testSpreadsheet = spreadhsheetnew("New Sheet")>
<cfset spreadsheetAddRow(testSpreadsheet ,"column a,column b,column c")>
<cfheader name="Content-Disposition" value="inline; filename=test.xls">
<cfcontent type="application/vnd-ms.excel" variable="#spreadsheetReadBinary(testSpreadsheet)#">

Script Example

testSpreadsheet = spreadhsheetnew("New Sheet");
spreadsheetAddRow(testSpreadsheet ,"column a,column b,column c");
cfheader(name="Content-Disposition" value="inline; filename=test.xls")'
cfcontent(type="application/vnd-ms.excel" variable="#spreadsheetReadBinary(testSpreadsheet)#");

This site is open source. Improve this page.