資源簡介

代碼片段和文件信息
import?com.jacob.activeX.*;
import?com.jacob.com.*;
public?class?Print?{
//private?static?final?String?PRINT_NAME=new?String(“FX7AF20D“);?
/**
?*?說明
?*??(1)首先將JACOB的DLL拷貝至?C:\Windows\System32?中
?*??(2)DCom?Server?Process?Launcher(DcomLaunch)服務(wù)需要打開
?*??(3)需要安裝Microsoft?office?2003+
?*??打印屬性參見?PrintOut?方法?(Excel)
?*?@param?path?打印路徑地址,形如?\\XX\\YY.xls
?*?@param?copies?打印份數(shù)
?*/
public?static?void?printExcel(String?pathint?copies){
if(path.isEmpty()||copies<1){
return;
}
//初始化COM線程
ComThread.InitSTA();
//新建Excel對(duì)象
ActiveXComponent?xl=new?ActiveXComponent(“Excel.Application“);
try?{?
System.out.println(“Version=“?+?xl.getProperty(“Version“));
//設(shè)置是否顯示打開Excel??
Dispatch.put(xl?“Visible“?new?Variant(true));
//打開具體的工作簿
Dispatch?workbooks?=?xl.getProperty(“Workbooks“).toDispatch();?
Dispatch?excel=Dispatch.call(workbooks“Open“System.getProperty(“user.dir“)+path).toDispatch();?
//設(shè)置打印屬性并打印
Dispatch.callN(excel“PrintOut“new?object[]{Variant.VT_MISSING?Variant.VT_MISSING?new?Integer(copies)
new?Boolean(false)/*PRINT_NAME*/Variant.VT_MISSING?new?Boolean(true)Variant.VT_MISSING?““});
//關(guān)閉文檔
//Dispatch.call(excel?“Close“?new?Variant(false));??
}?catch?(Exception?e)?{?
e.printStackTrace();?
}?finally{
//xl.invoke(“Quit“new?Variant[0]);
//始終釋放資源?
ComThread.Release();?
}?
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-04-01?19:29??打印\
?????文件??????217600??2013-10-07?10:15??打印\jacob-1.17-x64.dll
?????文件??????176128??2013-10-07?10:15??打印\jacob-1.17-x86.dll
?????文件???????47763??2013-10-07?10:15??打印\jacob.jar
?????文件????????1639??2013-10-11?11:09??打印\Print.java
?????文件????????1189??2016-04-01?19:17??打印\TestDoc.java
?????文件?????????269??2013-10-11?11:04??打印\說明.txt
評(píng)論
共有 條評(píng)論