testexcel.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 testExcel {
	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("塀偟僼傽僀儖");

			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("[Enter]傪墴偟偰偔偩偝偄丅廔椆偟傑偡");
			System.in.read();

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

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