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