testjcom.java

使用JCom的时候

import jp.ne.so_net.ga2.no_ji.jcom.*;

public class testJCom {
	public static void main(String[] args) throws Exception {
		ReleaseManager rm = new ReleaseManager();
		try {
			System.out.println("EXCEL傪婲摦拞...");
			IDispatch xlApp = new IDispatch(rm, "Excel.Application");  // EXCEL杮懱
			xlApp.put("Visible", new Boolean(true));	// '僨僼僅儖僩偼False(昞帵偟側偄)
			IDispatch xlBooks = (IDispatch)xlApp.get("Workbooks");
			IDispatch xlBook = (IDispatch)xlBooks.method("Add",null);	// 怴偟偄僽僢僋傪嶌惉
			IDispatch xlSheet = (IDispatch)xlApp.get("ActiveSheet");

			System.out.println("僙儖A1偵暥帤楍傪僙僢僩");
			Object[] arglist = new Object[1];
			arglist[0] = "A1";
			IDispatch xlRange = (IDispatch)xlSheet.get("Range",arglist);
			xlRange.put("Value","JCom偡偛偄偧両(^o^)");

			System.out.println("[Enter]傪墴偟偰偔偩偝偄丅廔椆偟傑偡");
			System.in.read();

			Object[] arglist3 = new Object[3];
			arglist3[0] = new Boolean(false);
			arglist3[1] = null;
			arglist3[2] = new Boolean(false);
			xlBook.method("Close", arglist3);
			xlApp.method("Quit", null);
			System.out.println("偛惷挳丄偁傝偑偲偆偛偞偄傑偟偨丅");
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { rm.release(); }
	}
}