package?com.wgc.ExcelUtils;

import?java.io.FileInputStream;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.util.ArrayList;
import?java.util.HashSet;
import?java.util.Iterator;
import?java.util.List;
import?java.util.Set;

import?org.apache.commons.lang3.StringUtils;
import?org.apache.poi.xssf.usermodel.XSSFCell;
import?org.apache.poi.xssf.usermodel.XSSFRow;
import?org.apache.poi.xssf.usermodel.XSSFSheet;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;

public?class?ExcelUtils?{

	private?String?path?=?null;
	
	public?ExcelUtils（）?{}
	public?ExcelUtils（String?path）?{
		this.path?=?path;
	}
	
	public?Set?readColContentFromExcel（int?column）?{
		Set?content?=?new?HashSet（）;
		FileInputStream?input?=?null;
		try?{
			input?=?new?FileInputStream（this.path）;
			XSSFWorkbook?workBook?=?new?XSSFWorkbook（input）;
			XSSFSheet?sheet?=?workBook.getSheetAt（0）;
			String?cellContent?=?null;
			System.out.println（“行數：“?+?sheet.getPhysicalNumberOfRows（））;
			for（int?i=0;?i				XSSFCell?cell?=?sheet.getRow（i）.getCell（column）;
				if（cell?!=?null）?{
					cellContent?=?sheet.getRow（i）.getCell（column）.toString（）;
					if（!StringUtils.isBlank（cellContent））?{
						content.add（cellContent）;
					}?else?{
						break;
					}
				}?else?{
					break;
				}
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			try?{
				input.close（）;
			}?catch?（IOException?e）?{
				e.printStackTrace（）;
			}
		}
		return?content;
	}
	
	public?void?writeResultAtExcel（List?contents?int?column）?{
		FileInputStream?input?=?null;
		FileOutputStream?output?=?null;
		try?{
			input?=?new?FileInputStream（this.path）;
			XSSFWorkbook?workBook?=?new?XSSFWorkbook（input）;
			XSSFSheet?sheet?=?workBook.getSheetAt（0）;
			for（int?i=0;?i				XSSFRow?row?=?sheet.createRow（i）;
				XSSFCell?cell?=?row.createCell（column）;
				cell.setCellValue（contents.get（i））;
				output?=?new?FileOutputStream（path）;
				workBook.write（output）;
			}
			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			try?{
				input.close（）;
				output.close（）;
			}?catch?（IOException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	public?void?compareColumnsContent（int?firstColumn?int?secondColumn?int?resultColumn）?{
		object[]?firstColumnContent?=?this.readColContentFromExcel（firstColumn）.toArray（）;
		object[]?secondColumnContent?=?this.readColContentFromExcel（secondColumn）.toArray（）;
		List?results?=?new?ArrayList（）;
		for（int?i=0;?i			for（int?j=0;?j				if（!StringUtils.isBlank（secondColumnContent[j].toString（）））?{
					if（secondColumnContent[j].toString（）.equals（firstColumnContent[i].toString（）））?{
						results.add（“Equal“）;
					}?else?{
						if（j?							cont

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-07-09?20:59??MyExcelUtils\
?????文件?????????752??2013-07-09?21:42??MyExcelUtils\.classpath
?????文件?????????388??2013-07-09?20:57??MyExcelUtils\.project
?????目錄???????????0??2013-07-09?20:57??MyExcelUtils\.settings\
?????文件?????????598??2013-07-09?20:57??MyExcelUtils\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2013-07-09?21:42??MyExcelUtils\bin\
?????目錄???????????0??2013-07-09?21:42??MyExcelUtils\bin\com\
?????目錄???????????0??2013-07-09?22:44??MyExcelUtils\bin\com\wgc\
?????目錄???????????0??2013-07-09?21:42??MyExcelUtils\bin\com\wgc\ExcelUtils\
?????文件????????4561??2013-07-09?23:14??MyExcelUtils\bin\com\wgc\ExcelUtils\ExcelUtils.class
?????目錄???????????0??2013-07-09?22:44??MyExcelUtils\bin\com\wgc\test\
?????文件?????????616??2013-07-09?23:15??MyExcelUtils\bin\com\wgc\test\Excel_Test.class
?????目錄???????????0??2013-07-09?21:42??MyExcelUtils\lib\
?????文件??????315805??2013-07-09?21:42??MyExcelUtils\lib\commons-lang3-3.1.jar
?????文件??????313898??2013-07-09?21:00??MyExcelUtils\lib\dom4j-1.6.1.jar
?????文件??????358180??2013-07-09?21:00??MyExcelUtils\lib\log4j-1.2.13.jar
?????文件?????1869113??2013-07-09?20:59??MyExcelUtils\lib\poi-3.9-20121203.jar
?????文件??????936648??2013-07-09?20:59??MyExcelUtils\lib\poi-ooxml-3.9-20121203.jar
?????文件?????4802621??2013-07-09?20:59??MyExcelUtils\lib\poi-ooxml-schemas-3.9-20121203.jar
?????文件?????2666695??2013-07-09?21:01??MyExcelUtils\lib\xmlbeans-2.3.0.jar
?????目錄???????????0??2013-07-09?21:02??MyExcelUtils\src\
?????目錄???????????0??2013-07-09?21:02??MyExcelUtils\src\com\
?????目錄???????????0??2013-07-09?22:44??MyExcelUtils\src\com\wgc\
?????目錄???????????0??2013-07-09?21:02??MyExcelUtils\src\com\wgc\ExcelUtils\
?????文件????????3838??2013-07-09?23:14??MyExcelUtils\src\com\wgc\ExcelUtils\ExcelUtils.java
?????目錄???????????0??2013-07-09?22:44??MyExcelUtils\src\com\wgc\test\
?????文件?????????250??2013-07-09?23:15??MyExcelUtils\src\com\wgc\test\Excel_Test.java