|
代码也修改了下
- function JSA排序(){
- let key,arr=Sheets.Item("明细表").Range("a1").CurrentRegion.Value2;
- arr.forEach((x,i)=>{
- if (x[0]=="编号") key=arr[i+1][0];
- x[x.length]=key;
- });
- arr.sort((a,b)=>a[a.length-1]-b[b.length-1]); //排序
- Sheets.Item("排序结果").Activate();
- Cells.Delete();
- Range("a1").Resize(arr.length,arr[0].length-1).Value2=arr;
- Range("a1").CurrentRegion.Borders.LineStyle=1;
- Range("a1").HorizontalAlignment=xlHAlignCenter;
- arr.reduce((dic,[x],i)=>{
- Range(`a${i+1}`).Resize(1,arr[0].length-1).Interior.Color=dic[x] || 16777215;
- Range(`a${i+1}`).Resize(1,arr[0].length-1).Font.Bold=x=="编号"?true:false;
- return dic;
- },{"编号":176464,"序号":9687376});
- Range("a1").CurrentRegion.EntireColumn.AutoFit();
- }
复制代码 |
|