testenum.java

使用JCom的时候

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

class testEnum {

	public static void main(String[] args) throws Exception {
		ReleaseManager rm = new ReleaseManager();
		try {
			System.out.println("EXCEL傪婲摦拞...");
			// 偡偱偵棫偪忋偑偭偰偄傞偲丄怴偟偄僂傿儞僪僂偱奐偔丅
			ExcelApplication excel = new ExcelApplication(rm);
			excel.Visible(true);

			ExcelWorkbooks xlBooks = excel.Workbooks();
			ExcelWorkbook xlBook = xlBooks.Add();	// 怴偟偄僽僢僋傪嶌惉
			ExcelWorksheets xlSheets = xlBook.Worksheets();

			// 僔乕僩偐傜IEnumVARIANT傪惗惉丅Enum偭傐偄憖嶌
			System.out.println("偡傋偰偺僔乕僩柤傪楍嫇偟偰傒傞");
			IEnumVARIANT enum = xlSheets.NewEnum();
			for(;;) {
				IDispatch disp = (IDispatch)enum.next();
				if(disp==null) break;
				ExcelWorksheet xlSheet = new ExcelWorksheet(disp);
				System.out.println(""+xlSheet.Name());
			}

			System.out.println("暿偺曽朄偱摨偠偙偲傪傗偭偰傒傞");
			enum.reset();	// 嵟弶偐傜
			Object[] ary = enum.next(100);	// 嵟戝侾侽侽屄偺僆僽僕僃僋僩傪庢摼
			for(int i=0; i<ary.length; i++) {
				ExcelWorksheet xlSheet = new ExcelWorksheet((IDispatch)ary[i]);
				System.out.println(""+xlSheet.Name());
			}

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

			xlBook.Close(false,null,false);
			excel.Quit();

			System.out.println("偛惷挳丄偁傝偑偲偆偛偞偄傑偟偨丅");
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { rm.release(); }
	}
}