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