|
JSA代码
- function 汇总表(){
- let obj=[...Sheets].reduce((obj,sh)=>{
- if (sh.Range("a2").Value2!="序号") return obj;
- let key=sh.Range("a1").Value2 || sh.Name;
- let temp=obj[key]=[[,],[key],["序号","药品通用名","英文名称","其他名称"]];
- sh.UsedRange.Value2.forEach(([a,b,c,d])=>{
- if (a==null || typeof(a)=="string") return;
- temp.push([temp.length-2,b,c,d]);
- });
- return obj;
- },{});
- let res=Object.values(obj).flat();
- Sheets.Item("药物汇总表").Range("a1").Resize(res.length,4).Value2=res;
- Sheets.Item("药物汇总表").Range("1:1").Delete();
- }
复制代码 |
|