spreadsheetReadBinary

Reads spreadsheet file into a binary object

spreadsheetReadBinary(spreadsheetObj) → returns void

  1. CFDocs
  2. Functions
  3. Spreadsheet Manipulation Functions
  4. spreadsheetReadBinary
  5. CF
  6. 0 Issue
  7. Edit

Argument Reference

spreadsheetObj variableName
Required

Spreadsheet file

Examples
Sample code invoking the spreadsheetReadBinary function 

<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)#">

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)#");

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub