JS代码,简单了点
- function 数据汇总(){
- let res=[...Sheets].reduce((res,sh)=>{
- if (sh.Range("a7").Value2!="编号") return res;
- let [kh,dh,rq]=["b5","f1","f4"].map(x=>sh.Range(x).Value2.split("·").reverse()[0]); //客户、单号、日期
- let [r1,r2]=[["编号",1],["备 注:",-1]].map(([a,b])=>sh.Cells.Find(a).Row + b);
- sh.Range(`a${r1}:g${r2}`).Value2.forEach(function(x){
- if (x[5]==null) return;
- res.push([rq,dh,kh,x[0],x[2],x[5].match(this)[0]]);
- },/\d+(\.\d+)?/);
- return res;
- },[["日期","订单号","客户名","产品编号","产品名称","产品数量"]]);
- Sheets.Item("要求").Range("a3").Resize(res.length, res[0].length).Value2=res;
- }
复制代码 |