package?class_demo;

import?java.io.FileInputStream;
import?java.io.FileNotFoundException;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFCellstyle;
import?org.apache.poi.hssf.usermodel.HSSFFont;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.hssf.util.Region;
import?org.apache.poi.poifs.filesystem.POIFSFileSystem;

public?class?Excel_Sheet?{
	/*
	?*?示例，在d盤放兩個示例Excel文件（單個Sheet）。
	?*?生成后會在D盤產生一個合并好Sheet的Excel文件。exlsample_2.xls
	?*/
	public?static?void?main（String[]?args）?{
		try?{
			POIFSFileSystem?fs?=?new?POIFSFileSystem（new?FileInputStream（“d:\\exlsample.xls“））;
			POIFSFileSystem?fs_1?=?new?POIFSFileSystem（new?FileInputStream（“d:\\exlsample_1.xls“））;
			HSSFWorkbook?wb?=?new?HSSFWorkbook（fs）;
			HSSFWorkbook?wb_1?=?new?HSSFWorkbook（fs_1）;
			HSSFWorkbook?wbt?=?new??HSSFWorkbook（）;
			//?source?target?為源sheet?頁和目標sheet頁
			wbt?=?copyRows（wbwbt）;
			wbt?=?copyRows（wb_1wbt）;
			FileOutputStream?fileOut?=?new?FileOutputStream（“d:\\exlsample_2.xls“）;
			wbt.write（fileOut）;
			fileOut.flush（）;
			fileOut.close（）;
			System.out.println（“生成完成!“）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	
	/*
	?*?對SHeet進行復制，將源Excle保存到目標Excle中
	?*/
	public?static?HSSFWorkbook?copyRows（HSSFWorkbook?wb?HSSFWorkbook?pTargetWb?）?{
		int?pStartRow?=?0;???????????????????????//開始行
		int?pEndRow?=0;??????????????????????????//結束行
		int?pPosition?=?0;???????????????????????//位置
		String?pSourceSheetName=““;
		String?pTargetSheetName?=““;
		HSSFRow?sourceRow?=?null;
		HSSFRow?targetRow?=?null;
		HSSFCell?sourceCell?=?null;
		HSSFCell?targetCell?=?null;
		HSSFSheet?sourceSheet?=?null;
		HSSFSheet?targetSheet?=?null;
		Region?region?=?null;
		int?cType;
		int?i;
		short?j;
		int?targetRowFrom;
		int?targetRowTo;
		if?（（pStartRow?==?-1）?||?（pEndRow?==?-1））?{
			return?null;
		}
		pSourceSheetName?=?wb.getSheetName（0）;
		pTargetSheetName?=?pSourceSheetName;
		int?pTargetSheetNumber?=?pTargetWb.getNumberOfSheets（）+1;
		if（pTargetWb.getSheet（pTargetSheetName）?!=null）{
			pTargetSheetName?=?pTargetSheetName+pTargetSheetNumber;
		}
		pTargetWb.createSheet（pTargetSheetName）;
		sourceSheet?=?wb.getSheet（pSourceSheetName）;
		targetSheet?=?pTargetWb.getSheet（pTargetSheetName）;
		pEndRow?=?sourceSheet.getPhysicalNumberOfRows（）;
		//?拷貝合并的單元格
		for?（i?=?0;?i?			region?=?sourceSheet.getMergedRegionAt（i）;
			if?（（region.getRowFrom（）?>=?pStartRow）
					&&?（region.getRowTo（）?<=?pEndRow））?{
				targetRowFrom?=?region.getRowFrom（）?-?pStartRow?+?pPosition;
				targetRowTo?=?region.getRowTo（）?-?pStartRow?+?pPosition;
				region.setRowFrom（targetRowFrom）;
				region.setRowTo（targetRowTo）;
				targetSheet.addMergedRegion（region）;
			}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????379??2012-03-31?09:53??POI_Excel_Sheet\Java_Demo\.classpath

?????文件????????784??2012-03-31?10:24??POI_Excel_Sheet\Java_Demo\.myeclipse\profiler\Excel_Sheet.xml

?????文件????????385??2012-03-31?09:13??POI_Excel_Sheet\Java_Demo\.project

?????文件????????629??2012-03-31?09:14??POI_Excel_Sheet\Java_Demo\.settings\org.eclipse.jdt.core.prefs

?????文件???????9299??2012-03-31?11:43??POI_Excel_Sheet\Java_Demo\bin\class_demo\Excel_Sheet.class

?????文件???????8491??2012-03-31?11:43??POI_Excel_Sheet\Java_Demo\src\class_demo\Excel_Sheet.java

?????文件????1675036??2011-08-22?11:25??POI_Excel_Sheet\poi-3.7-20101029.jar

?????文件??????16151??2012-03-31?15:24??POI_Excel_Sheet\POI_Excel_Sheet.docx

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\.myeclipse\profiler

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\bin\class_demo

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\src\class_demo

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\.myeclipse

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\.settings

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\bin

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo\src

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet\Java_Demo

?????目錄??????????0??2012-03-31?15:25??POI_Excel_Sheet

-----------?---------??----------?-----??----

??????????????1711154????????????????????17