// 设置多选下拉框中的选择
var ruleMap = new Array();
ruleMap[2] = "综合部";
ruleMap[3] = "人力资源部";
ruleMap[4] = "财务部";
ruleMap[5] = "业务拓展部";
ruleMap[6] = "科技管理部";
ruleMap[8] = "用户与市场研究所";
ruleMap[9] = "网络技术研究所";
ruleMap[10] = "无线技术研究所";
ruleMap[11] = "业务研究所";
ruleMap[12] = "测试技术研究所";
function main(spreadsheetReport) {
var sheet = spreadsheetReport.workbook.getWorksheets().get(0);
var targetColumn = 5; // F列
for (var i=0;i<10;i++) { //假设对 10 行进行处理
var targetCell = sheet.cells.get(i,targetColumn );
var curValue = targetCell.getValue();
if(curValue)
targetCell.setValue(doTrans(curValue));
}
}
// 将值进行转换
function doTrans(curValue) {
var strArray = curValue.split(",");
for (var i=0;i<strArray.length;i++) {
if (needTrans(strArray)) {
if (ruleMap[parseInt(strArray)]) {
strArray = ruleMap[strArray];
}
}
}
return strArray.join(",");
}
// 检查当前的值是不是需要进行转换
function needTrans(subValue) {
return parseInt(subValue)==subValue; //如果是整数认为要转换
}