SpreadsheetQuerywrite()

Writes out the query to the sheetname

Usage

BOOLEAN = SpreadsheetQuerywrite(
				
					
					
						spreadsheet, 
					
				
					
					
						query, 
					
				
					
					
						sheetname
					
				
				)

Argument	Summary
spreadsheet	spreadsheet object
query	the query object
sheetname	the name of the sheet name. Must already be created. Use SpreadSheetCreateSheet()

Calling

Supports named-parameter calling allowing you to use the function like:

SpreadsheetQuerywrite(
   spreadsheet=?, 
   query=?, 
   sheetname=?
);

Supports passing parameters as a structure using ArgumentCollection:

SpreadsheetQuerywrite( ArgumentCollection={
   spreadsheet : ?, 
   query : ?, 
   sheetname : ?
} );

IsSpreadsheetobject SpreadsheetAddcolumn SpreadsheetAddfreezepane SpreadsheetAddimage SpreadsheetAddinfo SpreadsheetAddrow SpreadsheetAddrows SpreadsheetAddsplitpane SpreadsheetColumnfittosize SpreadsheetCreatesheet SpreadsheetDeletecolumn SpreadsheetDeletecolumns SpreadsheetDeleterow SpreadsheetDeleterows SpreadsheetDeletesheet SpreadsheetFindcell SpreadsheetFormatcell SpreadsheetFormatcolumn SpreadsheetFormatcolumns SpreadsheetFormatrow SpreadsheetFormatrows SpreadsheetGetcellcomment SpreadsheetGetcellformula SpreadsheetGetcellvalue SpreadsheetInfo SpreadsheetMergecells SpreadsheetNew SpreadsheetQueryread SpreadsheetQuerywrite SpreadsheetRead SpreadsheetReadbinary SpreadsheetRemovecolumn SpreadsheetSetactivesheet SpreadsheetSetactivesheetnumber SpreadsheetSetcellcomment SpreadsheetSetcellformula SpreadsheetSetcellvalue SpreadsheetSetcolumnwidth SpreadsheetSetfooter SpreadsheetSetheader SpreadsheetSetrowwidth SpreadsheetShiftcolumns SpreadsheetShiftrows SpreadsheetWrite

SpreadsheetQuerywrite()

Usage

Calling

See Also