// 使用FieldPressEntity中的每一个entity，一个entity包含了所有属性

    public void insertintoExcel(String yyyy, String mm) throws Exception {

        List<FieldPressEntity> result = tyFieldPressDao.search(yyyy, mm);

        // 读取Excel的模板

        HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(new File(

                "D:/201512.xls")));

        HSSFSheet sheet = null;

        // 读取sheet的模板

        sheet = workbook.getSheetAt(0);

        // 定义行

        HSSFRow row;

        // 定义单元格

        HSSFCell cell;

        // for循环，循环目标为行循环

        for (int i = 0; i < result.size(); i++) {

            System.out.println(result.size());

            // 给e循环赋值

            FieldPressEntity e = result.get(i);

            // 循环行

            row = sheet.getRow(3 + i);

            // 给行内的单元格赋值

            cell = row.getCell(1);

            cell.setCellValue(e.getH17());

            System.out.println(i + "i内+" + e.getH17());

            cell = row.getCell(2);

            cell.setCellValue(e.getH18());

            System.out.println(i + "i内+" + e.getH18());

            cell = row.getCell(3);

            cell.setCellValue(e.getH19());

            System.out.println(i + "i内+" + e.getH19());

            cell = row.getCell(4);

            cell.setCellValue(e.getH20());

            System.out.println(i + "i内+" + e.getH20());

            cell = row.getCell(5);

            cell.setCellValue(e.getH21());

            System.out.println(i + "i内+" + e.getH21());

            cell = row.getCell(6);

            cell.setCellValue(e.getH22());

            System.out.println(i + "i内+" + e.getH22());

            cell = row.getCell(7);

            cell.setCellValue(e.getH23());

            System.out.println(i + "i内+" + e.getH23());

            cell = row.getCell(8);

            cell.setCellValue(e.getH00());

            System.out.println(i + "i内+" + e.getH00());

            cell = row.getCell(9);

            cell.setCellValue(e.getH01());

            System.out.println(i + "i内+" + e.getH01());

            cell = row.getCell(10);

            cell.setCellValue(e.getH02());

            System.out.println(i + "i内+" + e.getH02());

            cell = row.getCell(11);

            cell.setCellValue(e.getH03());

            System.out.println(i + "i内+" + e.getH03());

            cell = row.getCell(12);

            cell.setCellValue(e.getH04());

            System.out.println(i + "i内+" + e.getH04());

            cell = row.getCell(13);

            cell.setCellValue(e.getH05());

            System.out.println(i + "i内+" + e.getH05());

            cell = row.getCell(14);

            cell.setCellValue(e.getH06());

            System.out.println(i + "i内+" + e.getH06());

            cell = row.getCell(15);

            cell.setCellValue(e.getH07());

            System.out.println(i + "i内+" + e.getH07());

            cell = row.getCell(16);

            cell.setCellValue(e.getH08());

            System.out.println(i + "i内+" + e.getH08());

            cell = row.getCell(17);

            cell.setCellValue(e.getH09());

            System.out.println(i + "i内+" + e.getH09());

            cell = row.getCell(18);

            cell.setCellValue(e.getH10());

            System.out.println(i + "i内+" + e.getH10());

            cell = row.getCell(19);

            cell.setCellValue(e.getH11());

            System.out.println(i + "i内+" + e.getH11());

            cell = row.getCell(20);

            cell.setCellValue(e.getH12());

            System.out.println(i + "i内+" + e.getH12());

            cell = row.getCell(21);

            cell.setCellValue(e.getH13());

            System.out.println(i + "i内+" + e.getH13());

            cell = row.getCell(22);

            cell.setCellValue(e.getH14());

            System.out.println(i + "i内+" + e.getH14());

            cell = row.getCell(23);

            cell.setCellValue(e.getH15());

            System.out.println(i + "i内+" + e.getH15());

            cell = row.getCell(24);

            cell.setCellValue(e.getH16());

            System.out.println(i + "i内+" + e.getH16());

            cell = row.getCell(25);

            cell.setCellValue(e.getDaily_sum());

            System.out.println(i + "i内+" + e.getDaily_sum());

            cell = row.getCell(26);

            cell.setCellValue(e.getDaily_avg());

            System.out.println(i + "i内+" + e.getDaily_avg());

            cell = row.getCell(27);

            cell.setCellValue(e.getDaily_max());

            System.out.println(i + "i内+" + e.getDaily_max());

            cell = row.getCell(28);

            cell.setCellValue(e.getDaily_min());

            System.out.println(i + "i内+" + e.getDaily_min());

        }

        // 写入一个新的Excel表内

        FileOutputStream out = new FileOutputStream(new File("E:/"+yyyy+mm+".xls"));

        // Excel表写入完成

        workbook.write(out);

        // Excel表退出

        out.close();

    }