package com.qxueyou.scc.base.util;
|
|
import com.jacob.activeX.ActiveXComponent;
|
import com.jacob.com.ComThread;
|
import com.jacob.com.Dispatch;
|
import com.jacob.com.Variant;
|
|
public class JacobUtil {
|
|
public static final String DOC = "doc";
|
public static final String DOCX = "docx";
|
public static final String PDF = "pdf";
|
public static final String XLS = "xls";
|
public static final String XLSX = "xlsx";
|
public static final String MP4 = "mp4";
|
public static final String PPT = "ppt";
|
public static final String PPTX = "pptx";
|
|
// 8 ´ú±íword±£´æ³Éhtml
|
public static final int WORD2HTML = 8;
|
// 17´ú±íword±£´æ³Épdf
|
public static final int WD2PDF = 17;
|
public static final int PPT2PDF = 32;
|
public static final int XLS2PDF = 0;
|
|
public static void main(String[] args) {
|
String pptfile = "D:/upload/ÐÂÔ±¹¤ÈëÖ°Ïòµ¼¼°ÐÅÏ¢201605.xlsx";
|
//String pdffile = "D:/upload/b.pdf";
|
String htmlfile="D:/upload/excel.pdf";
|
//ppt2pdf(pptfile,pdffile);
|
excel2pdf(pptfile,htmlfile);
|
}
|
|
/**
|
* @param resourceType ×ÊÔ´ÀàÐÍ
|
* @param path ×ÊԴ·¾¶
|
* @return
|
* TODO Îļþת»»
|
*/
|
public static Integer formatConvert(String resourceType, String resourcePath) {
|
Integer pages = 0;
|
String resource = resourcePath.substring(0, resourcePath.lastIndexOf("."));
|
if(resourceType.equalsIgnoreCase(DOC)||resourceType.equalsIgnoreCase(DOCX)){
|
//wordת³ÉpdfºÍͼ??
|
word2pdf(resourcePath, resource+".pdf");
|
}else if(resourceType.equalsIgnoreCase(XLS)||resourceType.equalsIgnoreCase(XLSX)){
|
//excelÎļþת³ÉͼƬ
|
excel2pdf(resourcePath, resource+".pdf");
|
}else if(resourceType.equalsIgnoreCase(PPT)||resourceType.equalsIgnoreCase(PPTX)){
|
ppt2pdf(resourcePath, resource+".pdf");
|
}else if(resourceType.equalsIgnoreCase(MP4)){
|
//ÊÓƵÎļþ²»×ª??
|
pages = 0;
|
}
|
return pages;
|
}
|
|
|
public static void word2pdf(String docfile, String pdffile)
|
{
|
// Æô¶¯wordÓ¦ÓóÌÐò(Microsoft Office Word 2003)
|
ActiveXComponent app = null;
|
try{
|
ComThread.InitSTA();
|
app = new ActiveXComponent("Word.Application");
|
app.setProperty("Visible", false);
|
System.out.println("*****ÕýÔÚת»»...*****");
|
// ÉèÖÃwordÓ¦ÓóÌÐò²»¿É??
|
// app.setProperty("Visible", new Variant(false));
|
// documents±íʾword³ÌÐòµÄËùÓÐÎĵµ´°¿Ú£¬£¨wordÊǶàÎĵµÓ¦ÓóÌÐò???
|
Dispatch docs = app.getProperty("Documents").toDispatch();
|
// ´ò¿ªÒª×ª»»µÄwordÎļþ
|
/* Dispatch doc = Dispatch.invoke(
|
docs,
|
"Open",
|
Dispatch.Method,
|
new Object[] { docfile, new Variant(false),
|
new Variant(true) }, new int[1]).toDispatch(); */
|
|
Dispatch doc = Dispatch.call(
|
docs,
|
"Open",
|
docfile,
|
false,
|
true).toDispatch();
|
// µ÷ÓÃDocument¶ÔÏóµÄsaveAs·½·¨,½«Îĵµ±£´æΪpdf¸ñʽ
|
/*Dispatch.invoke(doc, "ExportAsFixedFormat", Dispatch.Method, new Object[] {
|
pdffile, new Variant(wdFormatPDF) }, new int[1]);*/
|
|
Dispatch.call(doc, "ExportAsFixedFormat", pdffile, WD2PDF);
|
// ¹Ø±ÕwordÎļþ
|
Dispatch.call(doc, "Close", false);
|
}
|
catch (Exception e)
|
{ ComThread.Release();
|
e.printStackTrace();
|
}
|
finally
|
{
|
//¹Ø±ÕwordÓ¦ÓóÌÐò
|
app.invoke("Quit", 0);
|
ComThread.Release();
|
}
|
System.out.println("*****ת»»Íê±Ï********");
|
}
|
|
|
|
public static void ppt2pdf(String pptfile,String pdffile){
|
ActiveXComponent app = null;
|
//app.setProperty("Visible", new Variant(false));
|
try {
|
ComThread.InitSTA();
|
app = new ActiveXComponent("PowerPoint.Application");
|
Dispatch files = app.getProperty("Presentations").toDispatch();
|
Dispatch file = Dispatch.call(files, "open", pptfile, false, true).toDispatch();
|
Dispatch.call(file, "SaveAs", pdffile, PPT2PDF);
|
Dispatch.call(file,"Close");
|
} catch (Exception e) {
|
ComThread.Release();
|
e.printStackTrace();
|
//throw e;
|
}finally{
|
app.invoke("Quit");
|
ComThread.Release();
|
}
|
}
|
|
public static void excel2pdf(String excelfile,String pdffile){
|
ActiveXComponent app = null;
|
try{
|
ComThread.InitSTA(true);
|
app = new ActiveXComponent("Excel.Application");
|
app.setProperty("Visible", false);
|
app.setProperty("AutomationSecurity", new Variant(3));//½ûÓÃ??
|
Dispatch excels = app.getProperty("Workbooks").toDispatch();
|
/*Dispatch excel = Dispatch.invoke(excels, "Open", Dispatch.Method, new Object[]{
|
excelfile,
|
new Variant(false),
|
new Variant(false),
|
},new int[9]).toDispatch();*/
|
Dispatch excel = Dispatch.call(excels, "Open",
|
excelfile,false,true).toDispatch();
|
//ת»»¸ñʽExportAsFixedFormat
|
/*Dispatch.invoke(excel, "ExportAsFixedFormat", Dispatch.Method, new Object[]{
|
new Variant(0),//pdf¸ñʽ=0
|
pdffile,
|
new Variant(0)//0=±ê×¼(Éú³ÉµÄpdfͼƬ²»»á±äÄ£??) 1=??СÎÄ??(Éú³ÉµÄpdfͼƬģºýµÄÒ»Ëúºý??)
|
}, new int[1]);*/
|
Dispatch.call(excel, "ExportAsFixedFormat",XLS2PDF,
|
pdffile);
|
Dispatch.call(excel, "Close", false);
|
if(app!=null){
|
app.invoke("Quit");
|
app=null;
|
}
|
}catch(Exception e){
|
ComThread.Release();
|
e.printStackTrace();
|
}finally{
|
ComThread.Release();
|
}
|
}
|
|
}
|
