testinterior.java

使用JCom的时候

import jp.ne.so_net.ga2.no_ji.jcom.excel8.*;
import jp.ne.so_net.ga2.no_ji.jcom.*;
import java.io.File;
import java.util.Date;

/* Excel梡儔僢僷傪巊偭偨丄JCom偺僒儞僾儖僾儘僌儔儉 
	攚宨怓丄儃乕僟乕偺僥僗僩
*/
class testInterior {
	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);
			// 怓傫側忣曬傪昞帵
			System.out.println("Version="+excel.Version());
			System.out.println("UserName="+excel.UserName());
			System.out.println("Caption="+excel.Caption());
			System.out.println("Value="+excel.Value());

			ExcelWorkbooks xlBooks = excel.Workbooks();
			ExcelWorkbook xlBook = xlBooks.Add();	// 怴偟偄僽僢僋傪嶌惉
			
			// 偡傋偰偺僼傽僀儖傪楍嫇偟偰傒傞
			System.out.println("尰嵼偺僨傿儗僋僩儕偺僼傽僀儖傪僙儖偵愝掕");
			ExcelWorksheets xlSheets = xlBook.Worksheets();
			ExcelWorksheet xlSheet = xlSheets.Item(1);
			ExcelRange xlRange = xlSheet.Cells();

			xlRange.Item(1,1).Value("僼傽僀儖柤" );
			xlRange.Item(1,2).Value("僒僀僘" );
			xlRange.Item(1,3).Value("嵟廔峏怴擔帪");
			xlRange.Item(1,4).Value("僨傿儗僋僩儕");
			xlRange.Item(1,5).Value("僼傽僀儖");
			xlRange.Item(1,6).Value("撉傒崬傒壜");
			xlRange.Item(1,7).Value("彂偒崬傒壜");
//			xlRange.Item(1,8).Value("塀偟僼傽僀儖");

			// 掅儗儀儖僀儞僞乕僼僃乕僗傪巊偭偰丄僒億乕僩偝傟偰偄側偄僆僽僕僃僋僩偵傾僋僙僗偟偰傒傞丅
			// 僙儖偺攚宨怓偵怓傪愝掕丅
			IDispatch interior = (IDispatch)xlRange.Item(1,1).get("Interior");
			interior.put("Color", new Integer(0xFFFF00));	// GGBBRR cyan
			// 宺慄傪愝掕丅
			IDispatch borders = (IDispatch)xlRange.Item(1,1).get("Borders");
			Object[] border_args = new Integer[1];
			border_args[0] = new Integer(9);
			IDispatch border = (IDispatch)borders.get("Item",border_args);	// XlBordersIndex.xlEdgeBottom = 9
			border.put("LineStyle", new Integer(1));	// XlLineStyle.xlContinuous = 1


			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.Item(i+2,1).Value( file.getName() );				// 僼傽僀儖柤僷僗柍偟
				xlRange.Item(i+2,2).Value( (int)file.length() );			// 僼傽僀儖僒僀僘
				xlRange.Item(i+2,3).Value( new Date(file.lastModified()) );	// 嵟廔峏怴擔帪
				xlRange.Item(i+2,4).Value( file.isDirectory()?"Yes":"No" );	// 僨傿儗僋僩儕偐丠
				xlRange.Item(i+2,5).Value( file.isFile()?"Yes":"No" );		// 僼傽僀儖偐丠
				xlRange.Item(i+2,6).Value( file.canRead()?"Yes":"No" );		// 撉傒庢傝壜偐丠
				xlRange.Item(i+2,7).Value( file.canWrite()?"Yes":"No" );	// 彂偒崬傒壜偐丠
//				xlRange.Item(i+2,8).Value( file.isHidden()?"Yes":"No" );	// 塀偟僼傽僀儖偐丠 (jdk1.2埲崀)
			}
			String expression = "=Sum(B2:B"+(filenames.length+1)+")";
			System.out.println("悢幃傪杽傔崬傒丄僼傽僀儖僒僀僘偺崌寁傪媮傔傞 "+expression);
			xlRange.Item(filenames.length+2,1).Value("崌寁");
			xlRange.Item(filenames.length+2,2).Formula(expression);
			xlRange.Columns().AutoFit();	// 墶暆傪僼傿僢僩偝偣傞

			// 僾儕儞僞偵弌椡偡傞応崌偼僐儊儞僩傪偼偢偟偰偔偩偝偄丅
			// 僨僼僅儖僩偺僾儕儞僞偵弌椡偝傟傑偡丅
//			System.out.println("僾儕儞僞偵報嶞偟傑偡丅");
//			xlSheet.PrintOut();

			// 僼傽僀儖偵曐懚偡傞応崌偼僐儊儞僩傪奜偟偰偔偩偝偄丅
			// 僨傿儗僋僩儕傪巜掕偟側偄応崌偼丄(My Documents)偵曐懚偝傟傑偡丅
//			System.out.println("僼傽僀儖偵曐懚偟傑偡丅(My Documents)\\testExcel.xls");
//			xlBook.SaveAs("testExcel.xls");

			System.out.println("10昩屻偵廔椆偟傑偡");
			Thread.sleep(10*1000);

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

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