GREPARRAY(MAPARRAY(SPLIT($sht,","),if(INARRAY(item,["AA","BB","CC","DD","FF"])>0,item,"")),len(item)>0)
--------------以下是js隐藏工作表的语句，多个值都可以隐藏-------
var sheetNames = ["苹果汁", "橙汁", "葡萄汁", "芒果汁"];
if (!window.flag) {
window.flag = true;
// 循环隐藏每个工作表
for (var i = 0; i < sheetNames.length; i++) {
var name = sheetNames[i];
$('li[title="' + name + '"]').hide();
}
}
1min目标场景问卷
立即参与
