java统计excel并生成新的excel

package cn.excel; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import java.util.ArrayList; import java.util.List; import jxl.Cell; import jxl.CellType; import jxl.Sheet; import jxl.Workbook; import jxl.write.Label; public class ExcelRead{ public static void main(String[] args) throws InterruptedException{ jxl.Workbook readwb = null; List<User> countlist = new ArrayList<User>(); for(int k = 1; k<13; k++){ System.out.println("第"+k+"月提成总计："); List<User> userlist = new ArrayList<User>(); try{ // 构建Workbook对象, 只读Workbook对象 // 直接从本地文件创建Workbook InputStream instream = new FileInputStream("E:/14年/2014-"+k+"提成.xls"); readwb = Workbook.getWorkbook(instream); // Sheet的下标是从0开始 // 获取第一张Sheet表 Sheet readsheet = readwb.getSheet(0); // 获取Sheet表中所包含的总列数 int rsColumns = readsheet.getColumns(); // 获取Sheet表中所包含的总行数 int rsRows = readsheet.getRows(); int nameCols = 0; int sumCols = 0; for (int j = 0; j < rsColumns; j++){ String title = readsheet.getCell(j, 0).getContents(); if(title != null && (title.equals("业务员") || title.equals("经手人"))){ nameCols = j; System.out.println("业务员:" + j + "列"); } if(title != null && (title.equals("提成") || title.equals("提成金额"))){ sumCols = j; System.out.println("提成额:" + j + "列"); } } for (int i = 1; i < rsRows; i++) { String name = readsheet.getCell(nameCols, i).getContents(); if(name != null && !name.equals("")){ User user = new User(); user.setMonth(k); user.setName(name); double sum = 0.0; try { sum = Double.parseDouble(readsheet.getCell(sumCols, i).getContents()); user.setSum(sum); } catch (Exception e) { // TODO: handle exception System.out.println("---异常信息：" + name + ":" + readsheet.getCell(sumCols, i).getContents()); } //判断是否包含该人的记录 boolean isContain = false; for(User user2 : userlist){ if(user2.getName() == name){ isContain = true; user2.setSum(user2.getSum() + sum); } } if(!isContain){ userlist.add(user); } } } } catch (Exception e) { e.printStackTrace(); } finally { readwb.close(); } for(User user : userlist){ System.out.println(user.getName() + ":" + user.getSum()); } System.out.println("****************************************"); countlist.addAll(userlist); Thread.sleep(1000); } try { ExcelWrite.Write(countlist); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }