java 调用宏_通过java代码实现调用excel当中的宏的操作。

import org.junit.Assert;

import org.junit.Test;public classExcelToolsServiceTest {privateExcelToolsService service;

@Testpublic voidtestMacro() {try{

String path= "C:/Users/admin.admin-PC.000/Desktop/vb/合并的模板/合同模板.xlsm";

service = newExcelToolsService();

service.execMacro(path,"文本替换.生成文档");

}catch(Exception e) {

e.printStackTrace();

Assert.fail();

}

}

}

import com.jacob.activeX.ActiveXComponent;

import com.jacob.com.ComThread;

import com.jacob.com.Dispatch;

import com.jacob.com.Variant;

public class ExcelToolsService {

public void execMacro(String excelPath, String macroName, Variant... params) throws Exception {

ActiveXComponent excel = null;

Dispatch workbooks = null;

Dispatch workbook = null;