workbookFromQuery

Returns a workbook object from a query. The query column names are included by default as a bold header row.

workbookFromQuery( data [, addHeaderRow [, boldHeaderRow [, xmlFormat ] ] ] )

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)

Example

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