資源簡介

代碼片段和文件信息
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)服務需要打開
?*??(3)需要安裝Microsoft?office?2003+
?*??打印屬性參見?PrintOut?方法?(Excel)
?*?@param?path?打印路徑地址,形如?\\XX\\YY.xls
?*?@param?copies?打印份數
?*/
public?static?void?printExcel(String?pathint?copies){
if(path.isEmpty()||copies<1){
return;
}
//初始化COM線程
ComThread.InitSTA();
//新建Excel對象
ActiveXComponent?xl=new?ActiveXComponent(“Excel.Application“);
try?{?
System.out.println(“Version=“?+?xl.getProperty(“Version“));
//設置是否顯示打開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();?
//設置打印屬性并打印
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?““});
//關閉文檔
//Dispatch.call(excel?“Close“?new?Variant(false));??
}?catch?(Exception?e)?{?
e.printStackTrace();?
}?finally{
//xl.invoke(“Quit“new?Variant[0]);
//始終釋放資源?
ComThread.Release();?
}?
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????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
?????文件????????269??2013-10-11?11:04??打印\說明.txt
?????目錄??????????0??2013-10-11?11:08??打印
-----------?---------??----------?-----??----
???????????????443399????????????????????6
評論
共有 條評論