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("啦啦啦啦啦!");
}
}
}