testsheetcopy2.java

使用JCom的时候

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

public class testSheetCopy2 {
	public static void main(String[] args) throws Exception {
		ReleaseManager rm = new ReleaseManager();
		try {
			System.out.println("EXCEL傪婲摦拞...");
			ExcelApplication xlApp = new ExcelApplication(rm);
			xlApp.Visible(true);
			ExcelWorkbooks xlBooks = xlApp.Workbooks();
			ExcelWorkbook xlBook = xlBooks.Add();	// create new book
			ExcelWorksheet xlSheet = xlApp.ActiveSheet();

			// set string to cell A1 .
			System.out.println("僙儖A1偵暥帤楍傪僙僢僩");
			ExcelRange xlRange = xlSheet.Range("A1");
			xlRange.Value("JCom (^o^)");

			// copy cell from A1 to B2 .
			// 僙儖傪僐僺乕偟偰傒傞丅扨堦僙儖
			System.out.println("僙儖A1偺撪梕傪B1偵僐僺乕");
			xlRange.Copy(xlSheet.Range("B2"));

			// copy cells from A1:B2 to C1:D2 .
			// 僙儖傪僐僺乕偟偰傒傞丅暋悢僙儖 A1:B2傪 C1:D2傊僐僺乕
			System.out.println("僙儖A1:B2偺撪梕傪C1:D2傊僐僺乕");
			ExcelRange xlRangeA1B2 = xlSheet.Range("A1:B2");
			xlRangeA1B2.Copy(xlSheet.Range("C1"));

			// copy sheet.
			// 僔乕僩傪僐僺乕偟偰傒傞
			System.out.println("僔乕僩傪僐僺乕");
			xlSheet.Copy(null, xlSheet);

			System.out.println("Hit [Enter] key to exit.");
			System.in.read();

			// quit.
			// 廔椆偝偣傞丅
			xlBook.Close(false, null, false);
			xlApp.Quit();
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { rm.release(); }
	}
}