JXL操作excel查出重复值

package com.test;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class ExcelTest {
	
	/**
	 * 判断传入的str是否在传入的list里面已经存在
	 * @param list
	 * @param str
	 * @return 如果存在则返回true，否则返回false;
	 */
	public static boolean isInArray(List list , String str){
		for (int i = 0; i < list.size(); i++) {
			if(list.get(i).equals(str)){
				return true;
			}
		}
		return false;
	}
	
	public static void main(String[] args) {
		try {
			InputStream inputStream = new FileInputStream("e:\\excel\\test.xls");
			Workbook workbook = Workbook.getWorkbook(inputStream);
			int sheetsCount = workbook.getNumberOfSheets(); 
			List listContent = new ArrayList();
			
			for(int m = 1; m < sheetsCount ; m++){
				Sheet sheets = workbook.getSheet(m);
				int sheetRows = sheets.getRows();
				List list = new ArrayList();
				for (int i = 0; i < sheetRows; i++) {
					Cell cell0 = sheets.getCell(0, i);
					Cell cell = sheets.getCell(1, i);
					if(isInArray(list,cell.getContents()) && cell.getContents().trim() != "" && cell.getContents().trim() != null ){
						listContent.add(cell0.getContents() + "\t" + cell.getContents());
					}else{
						list.add(cell.getContents());
					}
				}
			}
			for (int i = 0; i < listContent.size(); i++) {
				System.out.println(listContent.get(i));
			}
		} catch (IOException e) {
			e.printStackTrace();
		} catch (BiffException e) {
			e.printStackTrace();
		} finally{
			System.out.println("啦啦啦啦啦！");
		}
	}
}