本文共 2154 字，大约阅读时间需要 7 分钟。
private final DecimalFormat df = new DecimalFormat("#0.00"); public void test(){ String filePath = "G:\\tmp\\qhjt_yd.xls"; String destPath = "G:\\tmp\\qhjt_yd2.xls"; List > list = getData(); Map nsrxx = getBaseInfo(); try { //读取excel模板 HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(filePath)); //读取第一个工作簿 HSSFSheet sheet = workbook.getSheetAt(0); //设置保留公式 sheet.setForceFormulaRecalculation(true); //定义行与列 HSSFRow row; HSSFCell cell; //第3行,第2列 row = sheet.getRow(2); cell = row.getCell(1); cell.setCellValue(nsrxx.get("nsrmc")); //第3行,第4列 row = sheet.getRow(2); cell = row.getCell(3); cell.setCellValue(nsrxx.get("bsq")); //第13行,第3列 row = sheet.getRow(12); cell = row.getCell(2); cell.setCellValue(nsrxx.get("ycsm")); //第14行,第2列 row = sheet.getRow(13); cell = row.getCell(1); cell.setCellValue(nsrxx.get("tbr")); //第14行,第5列 row = sheet.getRow(13); cell = row.getCell(4); cell.setCellValue(nsrxx.get("lxdh")); //从第6行开始读取到第12行 for(int i=5;i<12;i++){ Map mm = list.get(i-5); //获取行 row = sheet.getRow(i); //依次设置3,4列 cell = row.getCell(2); cell.setCellValue(df.format(mm.get("bq"))); cell = row.getCell(3); cell.setCellValue(df.format(mm.get("tq"))); } FileOutputStream out = new FileOutputStream(destPath); workbook.write(out); out.close(); } catch (IOException ex) { Logger.getLogger(PoiUtil.class.getName()).log(Level.SEVERE, null, ex); } }
转载地址：http://wqwda.baihongyu.com/
