Unhide all rows and columns
Description
Unhides all the rows and columns in the active spreadsheet.
(function()
{
var activeSheet = Api.ActiveSheet;
var indexRowMax = 1048576;
var n = 1;
for (let i = 0; i < indexRowMax; i++) {
activeSheet.GetRows(n).SetHidden(false);
n++;
}
var newRange = activeSheet.GetRange("A1");
newRange.SetValue("All the rows and columns are unhidden now");
})();
Methods used: GetActiveSheet, GetRows, SetHidden, GetRange, SetValue