Spire.XLS for Java 16.11.1 新增 VBA 宏管理支持
新功能:
- 支持添加 Vba 宏。
- 支持获取设置Vba 宏。
- 支持复制 Vba宏。
Workbook workbook = new Workbook();
//添加VBA项目到文档
IVbaProject vbaProject = workbook.getVbaProject();
vbaProject.setName("SampleVBAMacro");
vbaProject.setCodePage(936); //设置编码,支持中文
//将模块添加到VBA项目
IVbaModule vbaModule = vbaProject.getModules().add("frmDataEntry", VbaModuleType.UserForm);
workbook.saveToFile(outputFile, FileFormat.Xlsm);
workbook.dispose();
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet ws = wb.getWorksheets().get(0);
IVbaProject vbaProject = wb.getVbaProject();
// 工程属性
vbaProject.setPassword("1234");
vbaProject.setName("modify");
vbaProject.setDescription("Description");
vbaProject.setHelpFileName("image1.png");
vbaProject.setConditionalCompilation("DEBUG = 2");
vbaProject.setLockProjectView(true);
String text = "Password:" + vbaProject.getPassword() + "\n";//设置的密码,可以获取 TestUtil.writeAllText(outputFile_TXT, text);
//sheet 属性
IVbaModule mod = vbaProject.getModules().getWorksheetModule(ws);
mod.setName("IVbaModule");
mod.setSourceCode("Dim lRow As Long");
mod.setType(VbaModuleType.Module);
wb.saveToFile(outputFile);
wb.dispose();
Workbook wb1 = new Workbook();
wb1.loadFromFile(inputFile_1);
IVbaProject vbaProject1 = wb1.getVbaProject();
Workbook wb2 = new Workbook();
wb2.loadFromFile(inputFile_2);
IVbaProject vbaProject2 = wb2.getVbaProject();
Workbook wb3 = new Workbook();
wb3.loadFromFile(inputFile_3);
IVbaProject vbaProject3 = wb3.getVbaProject();
Workbook wb4 = new Workbook();
wb4.loadFromFile(inputFile_4);
IVbaProject vbaProject4 = wb4.getVbaProject();
Workbook dest = new Workbook();
dest.getVbaProject().getModules().add(vbaProject1.getModules().get("SampleModule").clone(dest.getVbaProject().getModules()));
dest.getVbaProject().getModules().add(vbaProject2.getModules().get("Employee").clone(dest.getVbaProject().getModules()));
dest.getVbaProject().getModules().add(vbaProject2.getModules().get(1).clone(dest.getVbaProject().getModules()));
dest.getVbaProject().getModules().add(vbaProject3.getModules().get(0).clone(dest.getVbaProject().getModules()));
dest.getVbaProject().getModules().add(vbaProject4.getModules().get(0).clone(dest.getVbaProject().getModules()));
dest.saveToFile(outputFile);
问题修复:
- 修复了 Excel 转 pdf, ofd, textBox 内容丢失的问题。
获取 Spire.XLS for Java 16.11.1 请点击:







