以下WPS多个文件合并JS实例,注意WPS文件表格格式要一致
(1)主程序XLS_SUM1();
(2)打开指定文件 function OPEN_XLS(path_F_name,F_name),path_F_name文件路径,F_name文件名;
(3)关闭文件 CLOSE_XLS(F_name)
(4) 指定列转为数字XLS_NUM(0),这个函数水平有限
(5)排序XL_SORT(X1=0) 直接录制宏完成的
function OPEN_XLS(path_F_name,F_name) //打开文件
{
//var path1=ThisWorkbook.Path + "\\" ;
Workbooks.Open(path_F_name, undefined, undefined, undefined, undefined, undefined, undefined, undefined, undefined, undefined, undefined, undefined, true);
Windows.Item(F_name).Activate();
let m1=Range("A" + Rows.Count).End(xlUp).Row;
let end_rang="A3:O"+m1;
Range(end_rang).Select();
Selection.Copy(undefined);
Windows.Item("WPS合并文件.xlsm").Activate();
let m2=Range("A" + Rows.Count).End(xlUp).Row+1;
&nb