binaryFromQuery

Returns a byte array of a spreadsheet object from a query. The query column names are included by default as a bold header row.

binaryFromQuery( data[, addHeaderRow [, boldHeaderRow [, xmlFormat [, streamingXml [, streamingWindowSize [, ignoreQueryColumnDataTypes ] ] ] ] ] ] )

Required arguments

• data query: the data you want to download

Optional arguments

• addHeaderRow boolean default=true: whether to include the query column names as a header row
• boldHeaderRow boolean default=true: whether to make the header row bold
• xmlFormat boolean default=false: whether to create an XML spreadsheet (.xlsx)
• streamingXml boolean default=false: whether to create a memory-efficient streaming XML spreadsheet
• streamingWindowSize integer default=100: (positive integer greater than 0) the maximum number of rows that are kept in memory at once while populating a streaming spreadsheet, before being flushed to disk.
• ignoreQueryColumnDataTypes boolean default=false: whether to ignore the query column data types (e.g. VarChar) and auto-detect each cell type from the value.

Examples

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
binary = spreadsheet.binaryFromQuery( data );