readBinary - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns the contents of a spreadsheet object as a byte array.

readBinary( workbook )

Required arguments

• workbook spreadsheet object

Chainable? Yes but ends the chain.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
//create a binary variable ready for downloading
binary = spreadsheet.readBinary( workbook );