SpreadsheetQueryread()

Reads the given sheet from the spreadsheet object as a query. If there are formulae in the cells they will be evaluated

Usage

QUERY = SpreadsheetQueryread(
				
					
					
						spreadsheet, 
					
				
					
					
						sheet, 
					
				
					
					
						headerrow, 
					
				
					
					
						columnnames, 
					
				
					
					
						columns, 
					
				
					
					
						rows
					
				
				)

Argument	Summary
spreadsheet	spreadsheet object
sheet	the sheet number to be active; the first sheet starts at 0
headerrow	the row in the spreadsheet that is to be considered the header for the query (only HEADERROW or COLUMNNAMES must be present) [optional]
columnnames	the comma-separated names for the column names (only HEADERROW or COLUMNNAMES must be present) [optional]
columns	the columns to be used in the format (1,2,3,5-6); defaults to all [optional]
rows	the rows to be used in the format (1,2,3,5-6); defaults to all [optional]

Calling

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

SpreadsheetQueryread(
   spreadsheet=?, 
   sheet=?, 
   headerrow=?, 
   columnnames=?, 
   columns=?, 
   rows=?
);

Supports passing parameters as a structure using ArgumentCollection:

SpreadsheetQueryread( ArgumentCollection={
   spreadsheet : ?, 
   sheet : ?, 
   headerrow : ?, 
   columnnames : ?, 
   columns : ?, 
   rows : ?
} );

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

SpreadsheetQueryread()

Usage

Calling

See Also