|
JSA代码,不是VBA
- function 提取数据(){
- let fname=Dir(`${ThisWorkbook.Path}\\*HS.CSV`);
- let obj={},res=[["LOT","Vge","Icsc"]];
- while(fname!=""){
- let key=fname.split("_").slice(0,2).join("_");
- obj[key]=`${ThisWorkbook.Path}\\${fname}`;
- fname=Dir();
- }
- for (let key in obj){
- let fnum=FreeFile();
- Open(obj[key],fnum,jsInput);
- let k=0,m,n;
- while(!EOF(fnum)){
- let [a,b,c,d]=LineInput(fnum).split(/\t/g);
- if (++k<=7) continue;
- if (a>1.2 && m==null) m=b;
- n=n==null?d:(n<d?d:n);
- }
- res.push([key,m,n]);
- Close(fnum);
- }
- Sheets.Item("sum").Activate();
- Cells.ClearContents();
- Range("a1").Resize(res.length,res[0].length).Value2=res;
-
- }
复制代码 |
|