writeFileFromQuery

Write a spreadsheet file to disk from a query. The query column names are included by default as a bold header row.

writeFileFromQuery( data, filepath [, overwrite [, addHeaderRow [, boldHeaderRow [, xmlFormat ] ] ] ] )

##Required arguments

• data query: the data you want to download
• filepath string: full path of the file to be written, including filename and extension

##Optional arguments

• overwrite boolean default=false: whether or not to overwrite an existing file
• 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

spreadsheet = New spreadsheet();
data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget] ] );
filepath = ExpandPath( "report.xls" );
spreadsheet.writeFileFromQuery( data,filepath,true );