|
JSA代码
- function 求和(){
- const arr=Sheets.Item("Sheet1").Range("a1").CurrentRegion.Value2;
- const [start,end]=["h1","i1"].map(x=>Sheets.Item("Sheet2").Range(x).Value2);
- const hj=["合计","",0,"",0,""];
- let obj=arr.filter(x=>x[0]>=start && x[0]<=end).reduce((obj,x)=>{
- let temp=obj[x[1]]=obj[x[1]] || [x[1],x[2],0,x[4],0,""];
- [temp,hj].forEach(ar=>[2,4].forEach(j=>ar[j]+=x[j+1])) //累加数量、金额
- return obj;
- },{"表头":arr[0].slice(1)});
- let res=Object.values(obj).concat([hj]);
- Sheets.Item("Sheet2").Range("a2").Resize(res.length,res[0].length).Value2=res;
- }
复制代码 |
|