testnoreleasemanager.java

使用JCom的时候

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

/*
	ReleaseManager傪巊傢側偄応崌偺僒儞僾儖
	妋曐偝傟偨俠俷俵僆僽僕僃僋僩偵懳偟偰丄昁偢release()傪屇傋偽
	僾儘僙僗傪惓忢偵廔椆偡傞偙偲偑偱偒傑偡丅偟偐偟丄僜乕僗偑暋嶨偵
	側傝傑偡偟丄偳偙偱release()傪屇傋偽傛偄偺偐偑傢偐傝偵偔偄偱偡丅
	ReleaseManager偼偦傟傪娗棟偟丄揔愗偵張棟偟偰偔傟傑偡丅
	ReleaseManager偼偁傜備傞働乕僗傪憐掕偟偰愝寁偝傟偰偄傞偺偱丄
	偙偺僜乕僗傪嶲峫偵偡傞偙偲偼側偄偱偟傚偆丅
*/
public class testNoReleaseManager {
	public static void main(String[] args) throws Exception {
		try {
			System.out.println("EXCEL傪婲摦拞...");
			IDispatch xlApp = new IDispatch(null, "Excel.Application");  // EXCEL杮懱
			xlApp.put("Visible", new Boolean(true));	// '僨僼僅儖僩偼False(昞帵偟側偄)
			IDispatch xlBooks = (IDispatch)xlApp.get("Workbooks");
			IDispatch xlBook = (IDispatch)xlBooks.invoke("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^)");
			xlRange.release();		// @@@

			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.invoke("Close", arglist3);
			xlApp.invoke("Quit", null);
			xlSheet.release();		// @@@
			xlBook.release();		// @@@
			xlBooks.release();		// @@@
			xlApp.release();		// @@@
			System.out.println("偛惷挳丄偁傝偑偲偆偛偞偄傑偟偨丅");
		}
		catch(Exception e) { e.printStackTrace(); }
	}
}