java 调用 vbs 操作excel

groovy代码(前提是安装有office软件)

 static void runVbs(String vbsPath, Object ... objects) {

        String runVbs =  "cmd /c start ${vbsPath}"

        if(objects) {  //args
            objects.each {
                if(it) {
                    runVbs += " ${it}"
                }
            }
        }
        Runtime.getRuntime().exec(runVbs)
    }

set-author.vbs

dim args
set args = wscript.arguments
Dim objXL
Set objXL = CreateObject("Excel.Application")

    objXL.Application.DisplayAlerts = False
    objXL.Workbooks.Open (args(0))
    objXL.ActiveWorkbook.Author = args(1)

    objXL.Save
    objXL.Application.DisplayAlerts = True

 With objXL   
    .Workbooks.Close
    .Application.Quit
End With
Set objXL = Nothing

代码调用

                    runVbs("d:\\set-author.vbs",  "d:\\1.xls",  "张三")