java生成Excel导出本地

public void fpmxExportFind() throws Exception {
    OutputStream os = new FileOutputStream("D://名称.xls");
    try {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet fpst = wb.createSheet("sheet1");
        fpst.setActive(true);
        for (int i = 0; i < 11; i++) {
            fpst.setColumnWidth(i, 200 * 35);
        }
        fpst.setColumnWidth(1, 200 * 35);
        HSSFRow row = fpst.createRow(0);
        row.setHeightInPoints(50);
        HSSFCellStyle cellStyle = wb.createCellStyle();
        HSSFFont font = wb.createFont();// 设置字体
        font.setFontHeightInPoints((short) 25);// 设置字体
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);// 字体加粗
        cellStyle.setFont(font);
        cellStyle.setLocked(false);
        cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);//水平居中

        for (int i = 0; i < 11; i++) {
            cellStyle = wb.createCellStyle();
            HSSFCell cell = row.createCell(i);
            cellStyle.setWrapText(true);
            cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
            cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//垂直居中
            cellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
            cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
            switch (i) {
                case 0:
                    cell.setCellValue("纵标题1");
                    break;
                case 1:
                    cell.setCellValue("纵标题1");
                    break;
                case 2:
                    cell.setCellValue("纵标题1");
                    break;
                case 3:
                    cell.setCellValue("纵标题1");
                    break;
                case 4:
                    cell.setCellValue("纵标题1");
                    break;
                case 5:
                    cell.setCellValue("纵标题1");
                    break;
                case 6:
                    cell.setCellValue("纵标题1");
                    break;
                case 7:
                    cell.setCellValue("纵标题1");
                    break;
                case 8:
                    cell.setCellValue("纵标题1");
                    break;
                case 9:
                    cell.setCellValue("纵标题1");
                    break;
                case 10:
                    cell.setCellValue("纵标题1");
                    break;
            }
            cell.setCellStyle(cellStyle);
        }
        List<SBLBCX_DLXX> authList = eInvoiceRepository.getAuth();//list的数据

        for (SBLBCX_DLXX nsrxx:authList) {
            String key = "XWNSR:" + nsrxx.getNSRSBH();
            Map<String, String> all = jedisService.hgetall(key);
            int startspRow = fpst.getLastRowNum();
            HSSFRow fpxxRow = fpst.createRow(startspRow + 1);

            String dz=all.get("51");
            String jp=all.get("41");
            String pt=all.get("31");
            String zp=all.get("21");
            fpxxRow.createCell(0).setCellValue(nsrxx.getSBLX());
            fpxxRow.createCell(1).setCellValue(nsrxx.getJQBH());
            fpxxRow.createCell(2).setCellValue(nsrxx.getNSRSBH());
            fpxxRow.createCell(3).setCellValue(nsrxx.getNSRMC());
            fpxxRow.createCell(4).setCellValue(nsrxx.getDQBM());
            fpxxRow.createCell(5).setCellValue(all.get("DXH"));
            fpxxRow.createCell(6).setCellValue(all.get("51"));
            fpxxRow.createCell(7).setCellValue(all.get("21"));
            fpxxRow.createCell(8).setCellValue(all.get("31"));
            fpxxRow.createCell(9).setCellValue(all.get("41"));

            if (null == all || all.isEmpty()) {
                logger.info("无相关信息");
            }
            if(StringUtil.checkStrIsEmpty(all.get("51"))){
                dz="0";
            }
            if (StringUtil.checkStrIsEmpty(all.get("41"))){
                jp="0";
            }
            if(StringUtil.checkStrIsEmpty(all.get("31"))){
                pt="0";
            }
            if(StringUtil.checkStrIsEmpty(all.get("21"))) {
                zp="0";
            }
            fpxxRow.createCell(10).setCellValue(Integer.valueOf(dz) + Integer.valueOf(pt) + Integer.valueOf(jp) + Integer.valueOf(zp));
        }
        int lastRowNum = fpst.getLastRowNum();
        fpst.addMergedRegion(new CellRangeAddress(lastRowNum+2, lastRowNum+2, 0, 10));

        wb.write(os);
        os.flush();
        os.close();
    } catch (Exception e) {
        logger.error("POI生成发票列表表格异常！Exception=" + e);
    }
}