SpreadsheetSetRowHidden

Sets the hidden state of a row on the active sheet.

Method Signature

SpreadsheetSetRowHidden(spreadsheetObj=[any], row=[any], hide=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
row	NUMERIC	true	The row number (1-based).
hide	BOOLEAN	false	True to hide, false to show. Default is true.	true

Examples

Hide a row:

// Hide row 5
var spreadsheet = SpreadsheetNew();
SpreadsheetSetRowHidden( spreadsheet, 5, true );

Show hidden rows:

// Unhide row
SpreadsheetSetRowHidden( spreadsheet, 5, false );

Related

• SpreadsheetSetColumnHidden() - Hide column

• SpreadsheetSetRowHeight() - Set row height

• SpreadsheetisRowHidden() - Check if hidden