showRow

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 2 revisions

Shows the specified row in the currently active sheet if hidden

showRow( workbook, row)

Required arguments

workbook spreadsheet object
row numeric

Chainable? Yes.

Example

data = QueryNew( "First,Last", "VarChar,VarChar", [ [ "a","b" ], [ "c","d" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.hideRow( workbook, 2 ); //hide it
spreadsheet.showRow( workbook, 2 ); //show it again