前几天使用Apache 的POI操作ppt,后来发现转成的图片出现乱码,而且处理了之后,还会有遗留
因此决定换一种处理方式
Jacob 是 JAVA-COM Bridge的缩写,是一个中间件,能够提供自动化访问MS系统下COM组件和Win32 libraries的功能。
1.准备
(1)安装MS Office
(2)使用spring boot 框架
(3)pom.xml 添加 jacob 依赖
net.sf.jacob-project
jacob
1.14.3
(4)安装dll
在https://mvnrepository.com/ 查询jacob,选择第一个
选择适合自己机器的dll文件
将下载下来的dll文件放在
C:Program FilesJavajdk1.8.0_151in
C:Program FilesJavajdk1.8.0_151jrein
C:WINDOWSsystem32
C:Program FilesJavajre1.8.0_151in
其实只要在 C:WINDOWSsystem32下就可以找到了
2.使用
MS系统提供的COM组件
COM组件对象ID
MS Word
Word.Application
MS Excel
Excel.Application
MS Powerpoint
Powerpoint.Application
重要的类和方法
JacobObject:用于Java程序MS下的COM进行通信,创建标准的API框架
ComThread:初始化COM组件线程,释放线程,对线程进行管理
Dispatch:调度处理类,封装了操作来从而操作Office,并表示不同MS级别调度对象
Dispatch.get(dispatch, Stringname);获取对象属性
Dispatch.put(dispatch, String name, Objectvalue);设置对象属性
Dispatch.call(dispatch, String name, Object… args);调用对象方法
ActiveXComponent : 创建COM组件
Variant : 与COM通讯的参数或者返回值
可以参考VBA API,使用Jacob操作COM组件 https://docs.microsoft.com/en-us/office/vba/api/powerpoint.slides.insertfromfile 查看
处理过程
初始化ComThread——》初始化应用——》设置应用属性——》获取应用属性或对象,设置属性参数——》调用属性对应的方法
(1)ppt转pdf
publicBackRS ppt2Pdf(String sourcePath, String destPath,BackRS rs){
ActiveXComponent ppt= null;
Dispatch presentations= null;try{
ComThread.InitMTA(true);
ppt= new ActiveXComponent("PowerPoint.application");
Dispatch.put(ppt.getObject(),"DisplayAlerts", new Variant(false));
presentations= ppt.invokeGetComponent("Presentations")
.invokeGetComponent("Open", newVariant(sourcePath));
Dispatch.invoke(presentations,"SaveAs",
Dispatch.Method,new Object[]{destPath, new Variant(32)},new int[1]);
rs.setFlag(true);
rs.setMsg("pdf successfully converted.");
rs.setPath(destPath);
rs.setFileName(sourcePath);
}catch(Exception e) {
rs.setFlag(false);
rs.setMsg(e.getMessage());
}finally{try{if (ppt != null) {
ppt.invoke("Quit");
}
}catch(Exception e) {
rs.setFlag(false);
rs.setMsg(e.getMessage());
}finally{if (presentations != null)
presentations.safeRelease();if (ppt != null)
ppt.safeRelease();
ComThread.Release();
}
}returnrs;
}
(2)ppt按页保存图片
public static final int PPT_SAVEAS_JPG = 17;publicBackRS converter(String fileName){
BackRS rs= newBackRS();
ActiveXComponent ppt= null;
Dispatch presentations= null;
String source=fileName;
File file= newFile(source);if (!file.exists()) {
rs.setFlag(false);
rs.setMsg("转换文件不存在");returnrs;
}
String filePath= file.getParent()+File.separator;
String dest= filePath + getFileNameNoEx(file.getName())+"_JPG";
File destPath= newFile(dest);if (!destPath.exists()) {
destPath.mkdir();
}try{
ComThread.InitMTA(true);
ppt= new ActiveXComponent("PowerPoint.application");
Dispatch.put(ppt.getObject(),"DisplayAlerts", new Variant(false));
presentations= ppt.invokeGetComponent("Presentations").invokeGetComponent("Open", newVariant(source));
saveAs(presentations, dest, PPT_SAVEAS_JPG);
rs.setFlag(true);
rs.setMsg("Image successfully converted.");
rs.setPath(dest);
rs.setFileName(fileName);
}catch(Exception e) {
rs.setFlag(false);
rs.setMsg(e.getMessage());
}finally{try{if (ppt != null) {
ppt.invoke("Quit");
}
}catch(Exception e) {
rs.setFlag(false);
rs.setMsg(e.getMessage());
}finally{if (presentations != null)
presentations.safeRelease();if (ppt != null)
ppt.safeRelease();
ComThread.Release();
}
}returnrs;
}public voidsaveAs(Dispatch presentation, String saveTo,int ppSaveAsFileType)throwsException {
Dispatch.call(presentation,"SaveAs", saveTo, newVariant(
ppSaveAsFileType));
}
(3)ppt合并
public void merge(String outPutPPTPath, ListmergePPTPathList) {//启动 office PowerPoint程序
ActiveXComponent pptApp = null;
Dispatch presentations= null;
Dispatch outputPresentation;try{
ComThread.InitMTA(true);
pptApp= new ActiveXComponent("PowerPoint.Application");
Dispatch.put(pptApp,"Visible", new Variant(true));
presentations= pptApp.getProperty("Presentations").toDispatch();
File file= newFile(outPutPPTPath);if(file.exists()) {
file.delete();
}
file.createNewFile();//打开输出文件
outputPresentation = Dispatch.call(presentations, "Open", outPutPPTPath, false,false, true).toDispatch();//循环添加合并文件
for(String mergeFile : mergePPTPathList) {
Dispatch mergePresentation= Dispatch.call(presentations, "Open", mergeFile, false,false, true).toDispatch();
Dispatch mergeSildes= Dispatch.get(mergePresentation, "Slides").toDispatch();int mergePageNum = Integer.parseInt(Dispatch.get(mergeSildes, "Count").toString());//关闭合并文件
Dispatch.call(mergePresentation, "Close");
Dispatch outputSlides= Dispatch.call(outputPresentation, "Slides").toDispatch();int outputPageNum = Integer.parseInt(Dispatch.get(outputSlides, "Count").toString());//追加待合并文件内容到输出文件末尾
Dispatch.call(outputSlides, "InsertFromFile", mergeFile, outputPageNum, 1, mergePageNum);
}//保存输出文件,关闭退出PowerPonit.
Dispatch.call(outputPresentation, "Save");
Dispatch.call(outputPresentation,"Close");
}catch(Exception e) {
e.printStackTrace();
}finally{try{if (pptApp != null) {
pptApp.invoke("Quit");
}
}catch(Exception e) {
e.printStackTrace();
}finally{if (presentations != null)
presentations.safeRelease();if (pptApp != null)
pptApp.safeRelease();
ComThread.Release();
}
}
}
将mergePPTPathList 中的文件,追加到 outPutPPTPath文件中
下面的语句
Dispatch.call(outputSlides, "InsertFromFile", mergeFile, outputPageNum, 1, mergePageNum);
InsertFromFile( _FileName_, _Index_, _SlideStart_, _SlideEnd_ )
参考这个原型,可以实现追加指定的第umPage页面
Dispatch.call(outputSlides, "InsertFromFile",mergeFile, outputPageNum, umPage, umPage);
说明:
(1)出现错误 Can't get object clsid from progid
检查 dll文件都在指定位置,但还是报错
后来发现原来参考的其他人的文章Jacob调用WPS将Office文件转为PDF文件,对象ID不正确
其中 ppt = new ActiveXComponent("KWPP.Application");改为 ppt = new ActiveXComponent("PowerPoint.application");
(2)Can’t load IA 32-bit .dll on a AMD 64-bit platform
出现这个报错是因为使用的jacob.dll和系统不匹配,把32位的用在了64位的系统上了,几位的系统就用几位jacob.dll
(3)如果不想用Office想用WPS,不能安装极小安装包