📄 demo.htm
字号:
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<META NAME="KEYWORDS" CONTENT="Java,Com,Bridge,GNU,LGPL,JNI,Microsoft,component,object,model,Excel,Windows,XML">
<META NAME="description" CONTENT="This is a software project web page for Java-COM Bridge library called JCom. This software enable Java to access COM Objects such as Excel or Word.">
<title>僾儘僌儔儅乕's尋媶強/JCom(Java-COM僽儕僢僕)</title>
</head>
<body text="#000000" bgcolor="#FFFFFF">
<center><h2><font color="brown">JCom(Java-COM僽儕僢僕)</font></h2></center>
<center><IMG SRC="./jcom.jpg"></center>
<BR>
<hr><!------------------------------------------------------------------->
<H3>僒儞僾儖侾丗婎杮揑側巊偄曽</H3>
(jcom)/demo/samples/testExcel.java<BR>
<PRE>
import <font color="blue"><B>jp.ne.so_net.ga2.no_ji.jcom.excel8.*</B></font>;
import <font color="blue"><B>jp.ne.so_net.ga2.no_ji.jcom.*</B></font>;
import java.io.File;
import java.util.Date;
/* Excel梡儔僢僷傪巊偭偨丄JCom偺僒儞僾儖僾儘僌儔儉 */
class testExcel {
public static void main(String[] args) throws Exception {
<font color="blue"><B>ReleaseManager</B></font> rm = new <font color="blue"><B>ReleaseManager();</B></font>
try {
System.out.println("EXCEL傪婲摦拞...");
// 偡偱偵棫偪忋偑偭偰偄傞偲丄怴偟偄僂傿儞僪僂偱奐偔丅
<font color="blue"><B>ExcelApplication</B></font> excel = new <font color="blue"><B>ExcelApplication</B></font>(rm);
excel.Visible(true);
// 怓傫側忣曬傪昞帵
System.out.println("Version="+excel.<font color="blue"><B>Version()</B></font>);
System.out.println("UserName="+excel.<font color="blue"><B>UserName()</B></font>);
System.out.println("Caption="+excel.<font color="blue"><B>Caption()</B></font>);
System.out.println("Value="+excel.<font color="blue"><B>Value()</B></font>);
<font color="blue"><B>ExcelWorkbooks</B></font> xlBooks = excel.<font color="blue"><B>Workbooks()</B></font>;
<font color="blue"><B>ExcelWorkbook</B></font> xlBook = xlBooks.<font color="blue"><B>Add</B></font>(); // 怴偟偄僽僢僋傪嶌惉
// 偡傋偰偺僼傽僀儖傪楍嫇偟偰傒傞
System.out.println("尰嵼偺僨傿儗僋僩儕偺僼傽僀儖傪僙儖偵愝掕");
<font color="blue"><B>ExcelWorksheets</B></font> xlSheets = xlBook.<font color="blue"><B>Worksheets</B></font>();
<font color="blue"><B>ExcelWorksheet</B></font> xlSheet = xlSheets.<font color="blue"><B>Item</B></font>(1);
<font color="blue"><B>ExcelRange</B></font> xlRange = xlSheet.<font color="blue"><B>Cells</B></font>();
xlRange.<font color="blue"><B>Item(1,1).Value</B></font>("僼傽僀儖柤" );
xlRange.<font color="blue"><B>Item(2,1).Value</B></font>("僒僀僘" );
xlRange.<font color="blue"><B>Item(3,1).Value</B></font>("嵟廔峏怴擔帪");
xlRange.<font color="blue"><B>Item(4,1).Value</B></font>("僨傿儗僋僩儕");
xlRange.<font color="blue"><B>Item(5,1).Value</B></font>("僼傽僀儖");
xlRange.<font color="blue"><B>Item(6,1).Value</B></font>("撉傒崬傒壜");
xlRange.<font color="blue"><B>Item(7,1).Value</B></font>("彂偒崬傒壜");
File path = new File("./");
String[] filenames = path.list();
for(int i=0; i<filenames.length; i++) {
File file = new File(filenames[i]);
System.out.println(file);
xlRange.<font color="blue"><B>Item(1,i+2).Value</B></font>( file.getName() ); // 僼傽僀儖柤僷僗柍偟
xlRange.<font color="blue"><B>Item(2,i+2).Value</B></font>( (int)file.length() ); // 僼傽僀儖僒僀僘
xlRange.<font color="blue"><B>Item(3,i+2).Value</B></font>( new Date(file.lastModified()) ); // 嵟廔峏怴擔帪
xlRange.<font color="blue"><B>Item(4,i+2).Value</B></font>( file.isDirectory()?"Yes":"No" ); // 僨傿儗僋僩儕偐丠
xlRange.<font color="blue"><B>Item(5,i+2).Value</B></font>( file.isFile()?"Yes":"No" ); // 僼傽僀儖偐丠
xlRange.<font color="blue"><B>Item(6,i+2).Value</B></font>( file.canRead()?"Yes":"No" ); // 撉傒庢傝壜偐丠
xlRange.<font color="blue"><B>Item(7,i+2).Value</B></font>( file.canWrite()?"Yes":"No" ); // 彂偒崬傒壜偐丠
}
String expression = "=Sum(B2:B"+(filenames.length+1)+")";
System.out.println("悢幃傪杽傔崬傒丄僼傽僀儖僒僀僘偺崌寁傪媮傔傞 "+expression);
xlRange.<font color="blue"><B>Item(1,filenames.length+2).Value</B></font>("崌寁");
xlRange.<font color="blue"><B>Item(2,filenames.length+2).Formula</B></font>(expression);
xlRange.<font color="blue"><B>Columns().AutoFit</B></font>(); // 墶暆傪僼傿僢僩偝偣傞
// 僾儕儞僞偵弌椡偡傞応崌偼僐儊儞僩傪偼偢偟偰偔偩偝偄丅
// 僨僼僅儖僩偺僾儕儞僞偵弌椡偝傟傑偡丅
// System.out.println("僾儕儞僞偵報嶞偟傑偡丅");
// xlSheet.<font color="blue"><B>PrintOut</B></font>();
// 僼傽僀儖偵曐懚偡傞応崌偼僐儊儞僩傪奜偟偰偔偩偝偄丅
// 僨傿儗僋僩儕傪巜掕偟側偄応崌偼丄(My Documents)偵曐懚偝傟傑偡丅
// System.out.println("僼傽僀儖偵曐懚偟傑偡丅(My Documents)\\testExcel.xls");
// xlBook.<font color="blue"><B>SaveAs</B></font>("testExcel.xls");
xlBook.<font color="blue"><B>Close</B></font>(false,null,false);
excel.<font color="blue"><B>Quit</B></font>();
System.out.println("偛惷挳丄偁傝偑偲偆偛偞偄傑偟偨丅");
}
catch(Exception e) { e.printStackTrace(); }
finally { rm.<font color="blue"><B>release</B></font>(); }
}
}
</PRE>
<BR>
<hr><!------------------------------------------------------------------->
<H3>僒儞僾儖俀丗Excel傪巊偭偰尒愊彂傪嶌惉</H3>
(jcom)/demo/estimate/<BR>
<BR>
偁傞尒愊彂傪帺摦揑偵嶌傞僔僗僥儉偑偁傞偲壖掕偟傑偡丅
僔僗僥儉帺懱偼俰倎倴倎偱慻傫偱偄傑偡偑丄尒愊彂偺晹暘偩偗偼
俤倶們倕倢偱嶌傞昁梫偑偁傞偲偟傑偡丅俤倶們倕倢偺曽偑昳幙偺崅偄
僔乕僩偑嶌傟傑偡偟丄崱夞偼俤倶們倕倢偺報嶞婡擻傕棙梡偟傑偡丅<BR>
<BR>
傑偢丄estimate.xls傪尒偰偔偩偝偄丅
偙傟偼尒愊彂偺尨巻偵偁偨傝傑偡丅
昁梫側悢幃傕杽傔崬傑傟偰偄傑偡偟丄報嶞斖埻傕愝掕嵪傒偱偡丅
偙偺僼傽僀儖傪偄偭偨傫暿偺柤慜偱僐僺乕偟丄偦傟偵懳偟偰昁梫側
売強偵抣傪擖傟偰偄偒傑偡丅
偦偟偰報嶞偟丄曐懚偟偰廔椆偟傑偡丅<BR>
<BR>
僐僺乕偝傟偨僼傽僀儖偼丄偡傋偰巆偟偰偍偔傕偺偲偟傑偡丅
偟偨偑偭偰僼傽僀儖柤偼儐僯乕僋側抣偵偟傑偡丅
偙傟偼丄尒愊彂No偲堦抳偝偣傞曽偑傛偄偱偟傚偆丅
偦傟傜偼尒愊桳岠婜娫偑夁偓傞傑偱曐帩偟傑偡丅
偨偩偟丄偙偺僒儞僾儖偱偼偦偙傑偱幚憰偟偰偄傑偣傫丅<br>
<BR>
僒儞僾儖偱偼幚嵺偵偼報嶞偟傑偣傫偑丄埲壓偺峴傪僐儊儞僩偐傜奜偣偽報嶞傪峴偄傑偡丅
<PRE> // est.print_enable = true;</PRE>
幚嵺偺塣梡偲側傞偲丄僾儕儞僞偺戙傢傝偵俥俙倃傗儊乕儖偵憲傞偙偲傕
峫偊傜傟傑偡偹丅<BR>
偙偺僒儞僾儖偼JCom Ver2.01埲崀偺僼傽僀儖偵娷傑傟偰偄傑偡丅
Excel97,2000偱摦嶌偟傑偡丅
<BR>
<hr><!------------------------------------------------------------------->
<H3>僒儞僾儖俁丗Excel僼傽僀儖偐傜倃俵俴傪嶌惉</H3>
(jcom)/demo/outxml/<BR>
僒儞僾儖俀偱嶌惉偝傟偨偄偔偮偐偺尒愊彂偐傜丄昁梫側僨乕僞傪
拪弌偟偰倃俵俴偵弌椡偟傑偡丅
傑偢丄僇儗儞僩僨傿儗僋僩儕偵偁傞Excel僼傽僀儖傪奐偒丄
憐掕帠椺偲偼媡偺曽朄偱丄奩摉僙儖偐傜僨乕僞傪庢摼偟傑偡丅
偁偲偼丄PrintWriter傪巊偭偰XML僼傽僀儖傪嶌傝傑偡丅<BR>
<BR>
偙偺僒儞僾儖偱偼XML偺弌椡偺傒側偺偱丄XML僷乕僒偼昁梫
偁傝傑偣傫丅 偟偐偟丄XML僷乕僒偑偁傟偽丄XML仺EXCEL偺
張棟傕壜擻偱偟傚偆丅<BR>
<BR>
仠幚峴曽朄<BR>
偁傜偐偠傔丄俰俠倧倣偑惓偟偔僀儞僗僩乕儖偟偰偄傞傕偺偲偟傑偡丅<BR>
<UL><PRE>
javac OutXML.java //僐儞僷僀儖曽朄
java OutXML // 幚峴曽朄
</PRE></UL>
<hr><!------------------------------------------------------------------->
<H3>僒儞僾儖係丗VB偱嶌惉偟偨俠俷俵傪棙梡偡傞丅</H3>
(jcom)/demo/vbcom/<BR>
<hr><!------------------------------------------------------------------->
<a href="../index.htm">栠傞</a><br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -