For hiding/unhiding rows
&ExcelSpreadSheet.ToggleRow(rowIdx, visible)
Type Returned:
Boolean
Where:
rowIdx: the number of the row to be hide/unhide.
visible: boolean that indicates if to show or hide the row.
It will hide or unhide the row indicated in rowIdx depending on the value of visible. If visible is set to true, it will unhide the row. If set to false, it will hide it.
Extended Data Types: ExcelSpreadSheet data type
Languages: Java
ExcelSpreadsheet Data Type