getCellValue

Gets the value of a cell in the active sheet.

getCellValue( workbook, row, column )

Required arguments

• workbook spreadsheet object
• row numeric
• column numeric

Chainable? Yes but ends the chain.

Example

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