页面历史

//ClientSide 对象 spreadsheetReport 事件 onParamValueChanged
function main(spreadsheetReport, param) {
    // var hideSheets = ['数据1', '数据2']; //数组里边写需要隐藏的sheet页名称
    var value = spreadsheetReport.getParameterValue("产品类别发货区域");//实际参数名称
    var hideMaps = {
        "饮料东北": "数据1Sheet1",//参数名：sheet页名
        "华北": "Sheet2",
        "点心华东": "数据2Sheet3",
    }; //数组里边写需要隐藏的sheet页名称和对应参数
    var sheetNames = spreadsheetReport.visibleSheetNames;
    var removeSheetName = hideMaps[value];
    var row = spreadsheetReport.sheetsTable.rows[0];
    if (removeSheetName) {
        for (var j = 0; j < row.cells.length; j++) {
            if (row.cells[j]._sheetName !== removeSheetName) {
                row.cells[j].style.display = 'none';
            } else {
                row.cells[j].style.display = '';
            }
        }
    }else{//未选择隐藏参数则显示所有
        for (var j = 0; j < row.cells.length; j++) {
            row.cells[j].style.display = '';
        }
    }
}