WPS JS统计每个姓名出现的次数

原文： https://www.cnblogs.com/MrFlySand/p/16383242.html

function 统计学生所有积分(){	
	alert("1")
	/*var nameCell = Sheets.Item("官微").Range("C3").Value2;
	alert(nameCell[4] == null)*/		
	
	for(var i = 2; i < 100; i++){
		var integration = 0;
		for(var j = 3; j < 100; j++){
			var nameCell = Sheets.Item("视频").Range("E"+j).Value2; // 获取单元格的值，
			var cell = Sheets.Item("积分表").Range("A"+i).Value2;
//			alert(nameCell)
			//匹配姓名			
			for(var a = 0; nameCell != null && nameCell[a] != null && nameCell[a+1] != null; a++){
				var breakNum = 0;
				for(var b = 0; cell != null && cell[b] != null; b++){
					if(nameCell[a] == cell[b] && nameCell[a+1] == cell[b+1]){
						//alert(a+","+b+"："+cell[b]+","+cell[b+1])
						integration++;
						a++;
						b++;
//						breakNum = 1;
//						break;
					}
				}	
//				if(breakNum) break;
			}
		}
		Sheets.Item("积分表").Range("E"+i).Value2 = integration;
	}
	alert("2")
}