- @if(0)==(0) echo off
- del "%~dp0new_01.xls"
- cscript -nologo -e:jscript %0 "%~dp01.xls" "%~dp0new_01.xls"
- pause & exit
- @end
- var xlApp = new ActiveXObject("Excel.Application");
- var xlBook = xlApp.Workbooks.open(WScript.Arguments.Item(0));
- xlBook.worksheets(1).activate;
- var XlSheet = xlBook.activeSheet;
- var Count = XlSheet.usedrange.rows.count;
- XlSheet.Range(XlSheet.Cells(1, 4),XlSheet.Cells(Count, 4)).Delete;
- for(var i = 1; i <= Count; i++) {
- XlSheet.Cells(i, 10).value = i > 1 ? "一周5天考勤次数20次" : "备注";
- XlSheet.Cells(i, 6).value = i > 1 ? 20 - XlSheet.Cells(i, 5).value - XlSheet.Cells(i, 7).value - XlSheet.Cells(i, 8).value - XlSheet.Cells(i, 9).value : XlSheet.Cells(i, 6).value;
- }
- xlBook.SaveAs(WScript.Arguments.Item(1));
- xlBook.Close();
- xlApp.Quit();
复制代码
|