这是我得到的结果。
- function test(){
- let arr=Worksheets("原始表").Range("a1:i61").Value();
- let bt=arr.shift();
- let res=arr.reduce((p,[xsbm,pg,xj,lz,xg,lg,xhs,blg,hmg])=>(
- p[[xsbm]]=p[[xsbm]]||[xsbm,0,0,0,0,0,0,0,0,0],
- p[[xsbm]][1]+=pg,
- p[[xsbm]][2]+=xj,
- p[[xsbm]][3]+=lz,
- p[[xsbm]][4]+=xg,
- p[[xsbm]][5]+=lg,
- p[[xsbm]][6]+=xhs,
- p[[xsbm]][7]+=blg,
- p[[xsbm]][8]+=hmg,
- p[[xsbm]][9]=p[[xsbm]][1]+p[[xsbm]][2]+p[[xsbm]][3]+p[[xsbm]][4]+p[[xsbm]][5]+p[[xsbm]][6]+p[[xsbm]][7]+p[[xsbm]][8],
- p),
- {})
- bt.push("合计")
- res=Object.values(res);
- res.unshift(bt);
- Worksheets("结果表").Range("l1").Resize(res.length,res[0].length).Value2=res;
-
- }
复制代码
|