Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook write

List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook write

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFWorkbook
  6. write

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFWorkbook write.

Prototype

private void write(POIFSFileSystem fs) throws IOException

Source Link

Document

Writes the workbook out to a brand new, empty POIFS

Usage

From source file:com.fota.fota3g.statisticsMgt.controller.FotaReportExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "FOTA_";
    String fileName = date + "_" + formNm;

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<FotaReportInfoVo> fotaReportTotalList = (List<FotaReportInfoVo>) model.get("fotaReportTotalList");
    @SuppressWarnings("unchecked")
    List<FotaReportFailCauseAnalysisViewVo> failCauseAnalysisTotalList = (List<FotaReportFailCauseAnalysisViewVo>) model
            .get("failCauseAnalysisTotalList");
    @SuppressWarnings("unchecked")
    List<FotaReportFirmPkgDownloadViewVo> firmPkgDownloadtotalList = (List<FotaReportFirmPkgDownloadViewVo>) model
            .get("firmPkgDownloadtotalList");

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    // ?  /*  www .  ja va  2 s  . c o  m*/
    HSSFSheet sheet1 = workbook.createSheet("?  ");

    //  ?
    HSSFRow title = sheet1.createRow(0);
    title.createCell(0).setCellValue("?  ");

    HSSFRow header = sheet1.createRow(1);
    header.createCell(0).setCellValue("");
    header.createCell(1).setCellValue("");
    header.createCell(2).setCellValue("  ");
    header.createCell(3).setCellValue("");
    header.createCell(4).setCellValue("");
    header.createCell(5).setCellValue("");
    header.createCell(6).setCellValue(" ??");

    HSSFRow subHeader = sheet1.createRow(2);
    subHeader.createCell(0).setCellValue("?");
    subHeader.createCell(1).setCellValue("?");
    subHeader.createCell(2).setCellValue("? ");
    subHeader.createCell(3).setCellValue("");
    subHeader.createCell(4).setCellValue("");
    subHeader.createCell(5).setCellValue("");
    subHeader.createCell(6).setCellValue("");
    subHeader.createCell(7).setCellValue("");
    subHeader.createCell(8).setCellValue("");
    subHeader.createCell(9).setCellValue("");
    subHeader.createCell(10).setCellValue("");
    subHeader.createCell(11).setCellValue("PIN ");
    subHeader.createCell(12).setCellValue("");

    int index = 2;
    if (fotaReportTotalList != null && fotaReportTotalList.size() > 0) {
        for (int i = 0; i < fotaReportTotalList.size(); i++) {
            FotaReportInfoVo fvo = fotaReportTotalList.get(i);
            HSSFRow row = sheet1.createRow(++index);

            row.createCell(0).setCellValue(fvo.getModel());
            row.createCell(1).setCellValue(fvo.getSubscriberCount());
            row.createCell(2).setCellValue(fvo.getFirmwareVersionCheckCount());
            row.createCell(3).setCellValue(fvo.getFirmwareVersionCheckSucc());
            row.createCell(4).setCellValue(fvo.getFirmwareVersionCheckFail());
            row.createCell(5).setCellValue(fvo.getFirmwareVersionCheckSuccRate());
            row.createCell(6).setCellValue(fvo.getFirmwareUpdateRealTime());
            row.createCell(7).setCellValue(fvo.getFirmwareUpdateReservation());
            row.createCell(8).setCellValue(fvo.getFirmwareUpdateSucc());
            row.createCell(9).setCellValue(fvo.getFirmwareUpdateFail());
            row.createCell(10).setCellValue(fvo.getFirmwareUpdateFinalVersion());
            row.createCell(11).setCellValue(fvo.getFirmwareUpdatePinLock());
            row.createCell(12).setCellValue(fvo.getFirmwareUpdateSuccRate());
        }
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    //  ?? ? 
    HSSFSheet sheet2 = workbook.createSheet(" ?? ?");

    //  ?
    HSSFRow title2 = sheet2.createRow(0);
    title2.createCell(0).setCellValue(" ?? ?");

    HSSFRow header2 = sheet2.createRow(1);
    header2.createCell(0).setCellValue("");
    header2.createCell(1).setCellValue("?");
    header2.createCell(2).setCellValue("");
    header2.createCell(3).setCellValue("??");

    index = 1;
    if (failCauseAnalysisTotalList != null && failCauseAnalysisTotalList.size() > 0) {
        for (int i = 0; i < failCauseAnalysisTotalList.size(); i++) {
            FotaReportFailCauseAnalysisViewVo fvo = failCauseAnalysisTotalList.get(i);
            HSSFRow row = sheet2.createRow(++index);

            row.createCell(0).setCellValue(fvo.getDevision());
            row.createCell(1).setCellValue(fvo.getModel());
            row.createCell(2).setCellValue(fvo.getCount());
            row.createCell(3).setCellValue(fvo.getCause());

        }
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    //     
    HSSFSheet sheet3 = workbook.createSheet("   ");

    //  ?
    HSSFRow title3 = sheet3.createRow(0);
    title3.createCell(0).setCellValue("   ");

    HSSFRow header3 = sheet3.createRow(1);
    header3.createCell(0).setCellValue("?");
    header3.createCell(1).setCellValue(" ");
    header3.createCell(2).setCellValue(" ");

    index = 1;
    if (firmPkgDownloadtotalList != null && firmPkgDownloadtotalList.size() > 0) {
        for (int i = 0; i < firmPkgDownloadtotalList.size(); i++) {
            FotaReportFirmPkgDownloadViewVo fvo = firmPkgDownloadtotalList.get(i);
            HSSFRow row = sheet3.createRow(++index);

            row.createCell(0).setCellValue(fvo.getModel());
            row.createCell(1).setCellValue(fvo.getFirmwarePkg());
            row.createCell(2).setCellValue(fvo.getDownloadCount());
        }
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.fota3g.statisticsMgt.controller.NewFotaReportExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "FOTA_";
    String fileName = date + "_" + formNm;

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<NewFotaReportInfoVo> fotaReportExcelList = (List<NewFotaReportInfoVo>) model
            .get("fotalReportExcelList");

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    // FOTA /*from   ww w  .  ja  va 2 s  .c om*/
    HSSFSheet sheet1 = workbook.createSheet("FOTA_");

    //  ?
    HSSFRow title = sheet1.createRow(0);
    title.createCell(0).setCellValue("FOTA_");

    HSSFRow header = sheet1.createRow(1);
    header.createCell(0).setCellValue("FOTA  ID");
    header.createCell(1).setCellValue("FOTA ");
    header.createCell(2).setCellValue("??");
    header.createCell(3).setCellValue("?");
    header.createCell(4).setCellValue(" ");
    header.createCell(5).setCellValue("FOTA  ");
    header.createCell(6).setCellValue("");
    header.createCell(7).setCellValue("FOTA ? ");
    header.createCell(8).setCellValue(" ?");
    header.createCell(9).setCellValue("? ?");
    header.createCell(10).setCellValue("?  ??");
    header.createCell(11).setCellValue("DM Timeout");
    header.createCell(12).setCellValue("");

    int index = 1;
    if (fotaReportExcelList != null && fotaReportExcelList.size() > 0) {
        for (int i = 0; i < fotaReportExcelList.size(); i++) {
            NewFotaReportInfoVo fvo = fotaReportExcelList.get(i);
            HSSFRow row = sheet1.createRow(++index);

            row.createCell(0).setCellValue(fvo.getRequestId());
            row.createCell(1).setCellValue(fvo.getRequestName());
            row.createCell(2).setCellValue(fvo.getWriteDate());
            row.createCell(3).setCellValue(fvo.getStartDate());
            row.createCell(4).setCellValue(fvo.getStartTime() + "~" + fvo.getEndTime());
            row.createCell(5).setCellValue(fvo.getTotalCount());
            row.createCell(6).setCellValue(fvo.getSuccessCount());
            row.createCell(7).setCellValue(fvo.getTotalFailCount());
            row.createCell(8).setCellValue(fvo.getCancelDevCount());
            row.createCell(9).setCellValue(fvo.getNonRegistedDevCount());
            row.createCell(10).setCellValue(fvo.getDevSessionCloseCount());
            row.createCell(11).setCellValue(fvo.getDmTimeoutCount());
            row.createCell(12).setCellValue(fvo.getSuccessRate());

        }
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.fota3g.statisticsMgt.controller.PkgDownExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "  ";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<FirmwareVersionVo> columnList = (List<FirmwareVersionVo>) model.get("columnList");
    @SuppressWarnings("unchecked")
    List resultList = (List) model.get("resultList");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?//w w w.j  a  va2 s .  c om
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("??");
    for (int i = 0, j = 1; i < columnList.size(); i++, j++) {
        header.createCell(j).setCellValue(columnList.get(i).getVersion());
    }
    header.createCell(columnList.size()).setCellValue("");

    // ??
    int index = 0;
    HashMap<String, String> tempResultItemMap = null;
    for (int i = 0; i < resultList.size(); i++) {
        HSSFRow row = sheet.createRow(++index);
        tempResultItemMap = (HashMap) resultList.get(i);

        row.createCell(0).setCellValue(tempResultItemMap.get("01_SUMDATE").toString());
        for (int j = 0, k = 1; j < columnList.size(); j++, k++) {
            row.createCell(k).setCellValue(tempResultItemMap.get(columnList.get(j).getVersion()).toString());
        }
        row.createCell(columnList.size()).setCellValue(tempResultItemMap.get("ROW_SUM").toString());

    } // end of for(int i=0; i<resultList.size(); i++)

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.fotastatMgt.controller.FotastatExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "FOTA";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<FotastatSearchVO> resultData = (List<FotastatSearchVO>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?/* w  ww  .  j  a v a2s .co m*/
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("?");
    header.createCell(1).setCellValue("FOTA Type");
    header.createCell(2).setCellValue("");
    header.createCell(3).setCellValue("");
    header.createCell(4).setCellValue("?");
    header.createCell(5).setCellValue("??");
    header.createCell(6).setCellValue("");
    header.createCell(7).setCellValue("?");
    header.createCell(8).setCellValue("?");
    header.createCell(9).setCellValue("");
    //(ctn)  
    header.createCell(10).setCellValue("");
    header.createCell(11).setCellValue("");
    header.createCell(12).setCellValue("?");
    header.createCell(13).setCellValue("???");
    header.createCell(14).setCellValue("PUSH");

    int index = 0;
    if (resultData != null && resultData.size() > 0) {
        for (int i = 0; i < resultData.size(); i++) {
            FotastatSearchVO fvo = resultData.get(i);
            HSSFRow row = sheet.createRow(++index);
            row.createCell(0).setCellValue(fvo.getProcessStatCd());
            row.createCell(1).setCellValue(fvo.getFotaType());
            row.createCell(2).setCellValue(fvo.getBizNm());
            row.createCell(3).setCellValue(fvo.getSvcNm());
            row.createCell(4).setCellValue(fvo.getDevMakerNm());
            row.createCell(5).setCellValue(fvo.getDevModelNm());
            row.createCell(6).setCellValue(fvo.getModemMakerNm());
            row.createCell(7).setCellValue(fvo.getModemModelNm());
            row.createCell(8).setCellValue(fvo.getClientNm());
            row.createCell(9).setCellValue(fvo.getDealerNm());
            //(ctn)  
            row.createCell(10).setCellValue(fvo.getDevFirmwareMakerVer());
            row.createCell(11).setCellValue(fvo.getUpdFirmwareMakerVer());
            row.createCell(12).setCellValue(fvo.getCretDt());
            row.createCell(13).setCellValue(fvo.getDevNonAccPeriod());
            row.createCell(14).setCellValue(fvo.getPushRsvYn());
        }
    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.qualityMgt.controller.DeviceQualityAnalysisExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "??";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<DeviceQualityAnalysisInfoVo> resultData = (List<DeviceQualityAnalysisInfoVo>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?/*  ww  w  .ja  v a 2s  . com*/
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("??");
    header.createCell(1).setCellValue("");
    header.createCell(2).setCellValue("");
    header.createCell(3).setCellValue("??");
    header.createCell(4).setCellValue("");
    header.createCell(5).setCellValue("?");
    header.createCell(6).setCellValue("??");
    header.createCell(7).setCellValue("");
    header.createCell(8).setCellValue("?");
    header.createCell(9).setCellValue("?");
    // 
    header.createCell(10).setCellValue("QMV");
    // ? 
    header.createCell(11).setCellValue("CPU");
    header.createCell(12).setCellValue("MEM");
    header.createCell(13).setCellValue("CHW");
    header.createCell(14).setCellValue("CHWE");
    header.createCell(15).setCellValue("ErrorDesc");
    //  
    header.createCell(16).setCellValue("RSSI");
    header.createCell(17).setCellValue("RAT");
    header.createCell(18).setCellValue("RSCP (WCDMA)");
    header.createCell(19).setCellValue("E/I (WCDMA)");
    header.createCell(20).setCellValue("RSRP (LTE)");
    header.createCell(21).setCellValue("RSRQ (LTE)");
    header.createCell(22).setCellValue("RMNET/QMI (LTE)");
    header.createCell(23).setCellValue("BR");
    header.createCell(24).setCellValue("SRVS");
    header.createCell(25).setCellValue("Tx");
    header.createCell(26).setCellValue("SS");
    header.createCell(27).setCellValue("CS");
    header.createCell(28).setCellValue("FREQ");
    header.createCell(29).setCellValue("APN");
    header.createCell(30).setCellValue("QoS");
    header.createCell(31).setCellValue("PSC (WCDMA)");
    header.createCell(32).setCellValue("D/N");
    header.createCell(33).setCellValue("VER");
    header.createCell(34).setCellValue("IMEI");
    header.createCell(35).setCellValue("ICCID");

    int index = 0;
    for (int i = 0; i < resultData.size(); i++) {
        DeviceQualityAnalysisInfoVo fvo = resultData.get(i);
        HSSFRow row = sheet.createRow(++index);
        //  ??
        row.createCell(0).setCellValue(fvo.getLastAccDt());
        row.createCell(1).setCellValue(fvo.getBizNm());
        row.createCell(2).setCellValue(fvo.getSvcNm());
        row.createCell(3).setCellValue(fvo.getDevId());
        row.createCell(4).setCellValue(fvo.getCtn());
        row.createCell(5).setCellValue(fvo.getDevMakerNm());
        row.createCell(6).setCellValue(fvo.getDevModelNm());
        row.createCell(7).setCellValue(fvo.getModemMakerNm());
        row.createCell(8).setCellValue(fvo.getModemModelNm());
        row.createCell(9).setCellValue(fvo.getDevQulInfo());
        // 
        row.createCell(10).setCellValue(fvo.getQmv());
        // ? 
        row.createCell(11).setCellValue(fvo.getCpu());
        row.createCell(12).setCellValue(fvo.getMem());
        row.createCell(13).setCellValue(fvo.getChw());
        row.createCell(14).setCellValue(fvo.getChwe());
        row.createCell(15).setCellValue(fvo.getErrorDesc());
        //  
        row.createCell(16).setCellValue(fvo.getRssi());
        row.createCell(17).setCellValue(fvo.getRat());
        row.createCell(18).setCellValue(fvo.getRscp());
        row.createCell(19).setCellValue(fvo.getEi());
        row.createCell(20).setCellValue(fvo.getRsrp());
        row.createCell(21).setCellValue(fvo.getRsrq());
        row.createCell(22).setCellValue(fvo.getRmnet());
        row.createCell(23).setCellValue(fvo.getBr());
        row.createCell(24).setCellValue(fvo.getSrvc());
        row.createCell(25).setCellValue(fvo.getTx());
        row.createCell(26).setCellValue(fvo.getSs());
        row.createCell(27).setCellValue(fvo.getCs());
        row.createCell(28).setCellValue(fvo.getFreq());
        row.createCell(29).setCellValue(fvo.getApn());
        row.createCell(30).setCellValue(fvo.getQos());
        row.createCell(31).setCellValue(fvo.getPsc());
        row.createCell(32).setCellValue(fvo.getDn());
        row.createCell(33).setCellValue(fvo.getVer());
        row.createCell(34).setCellValue(fvo.getImei());
        row.createCell(35).setCellValue(fvo.getIccid());

    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.qualityMgt.controller.LongTimeDisconnectDevMgtExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    //      logger.warn("LongTimeDisconnectDevMgtExcelDown - buildExcelDocument() start...");

    String date = DateTimeUtil.getCurrentDate();
    String formNm = "??";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<LongTimeDisconnectDevInfoVo> resultData = (List<LongTimeDisconnectDevInfoVo>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?/*from   w  ww  .j  a va 2  s  . c o  m*/
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("???");
    header.createCell(1).setCellValue("??");
    header.createCell(2).setCellValue("");
    header.createCell(3).setCellValue("?");
    header.createCell(4).setCellValue("?");
    header.createCell(5).setCellValue("??");
    header.createCell(6).setCellValue("");
    header.createCell(7).setCellValue("?");
    header.createCell(8).setCellValue("IMEI");
    header.createCell(9).setCellValue("");
    header.createCell(10).setCellValue("OFF ");

    int index = 0;
    if (resultData != null && resultData.size() > 0) {
        for (int i = 0; i < resultData.size(); i++) {
            LongTimeDisconnectDevInfoVo fvo = resultData.get(i);
            HSSFRow row = sheet.createRow(++index);

            row.createCell(0).setCellValue(fvo.getDevDisConnectDate());
            row.createCell(1).setCellValue(fvo.getOffYn());
            row.createCell(2).setCellValue(fvo.getSvcNm());
            row.createCell(3).setCellValue(fvo.getClientNm());
            row.createCell(4).setCellValue(fvo.getDevMakerNm());
            row.createCell(5).setCellValue(fvo.getDevModelNm());
            row.createCell(6).setCellValue(fvo.getModemMakerNm());
            row.createCell(7).setCellValue(fvo.getModemModelNm());
            row.createCell(8).setCellValue(fvo.getImei());
            row.createCell(9).setCellValue(fvo.getCtn());
            row.createCell(10).setCellValue(fvo.getOffReportYn());
        }
    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.qualityMgt.controller.ModemQualityInfoExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<ModemQulSearchVO> resultData = (List<ModemQulSearchVO>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?// ww w . j a  va 2  s  . c  om
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("");
    header.createCell(1).setCellValue("");
    //(ctn)  
    header.createCell(2).setCellValue("?");
    header.createCell(3).setCellValue("??");
    header.createCell(4).setCellValue("");
    header.createCell(5).setCellValue("?");
    header.createCell(6).setCellValue("");
    header.createCell(7).setCellValue("RAT");
    header.createCell(8).setCellValue("RSSI");
    header.createCell(9).setCellValue("?");

    int index = 0;
    for (int i = 0; i < resultData.size(); i++) {
        ModemQulSearchVO fvo = resultData.get(i);
        HSSFRow row = sheet.createRow(++index);
        row.createCell(0).setCellValue(fvo.getBizNm());
        row.createCell(1).setCellValue(fvo.getSvcNm());
        row.createCell(2).setCellValue(fvo.getDevMakerNm());
        row.createCell(3).setCellValue(fvo.getDevModelNm());
        row.createCell(4).setCellValue(fvo.getModemMakerNm());
        row.createCell(5).setCellValue(fvo.getModemModelNm());
        row.createCell(6).setCellValue("(?)");
        row.createCell(7).setCellValue(fvo.getRat());
        row.createCell(8).setCellValue(fvo.getRssi());
        row.createCell(9).setCellValue(fvo.getLastAccDt());
    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.qualityMgt.controller.QualityInfoExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<QulSearchVO> resultData = (List<QulSearchVO>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?/*from  w w  w.  j a v  a  2s. co  m*/
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("");
    header.createCell(1).setCellValue("");
    //(ctn)  
    header.createCell(2).setCellValue("?");
    header.createCell(3).setCellValue("??");
    header.createCell(4).setCellValue("");
    header.createCell(5).setCellValue("?");
    header.createCell(6).setCellValue("?");
    header.createCell(7).setCellValue("ErrorDesc");
    header.createCell(8).setCellValue("");
    header.createCell(9).setCellValue("RAT");
    header.createCell(10).setCellValue("RSSI");
    header.createCell(11).setCellValue("()");
    header.createCell(12).setCellValue("???");
    header.createCell(13).setCellValue("??");

    int index = 0;
    for (int i = 0; i < resultData.size(); i++) {
        QulSearchVO fvo = resultData.get(i);
        HSSFRow row = sheet.createRow(++index);
        row.createCell(0).setCellValue(fvo.getBizNm());
        row.createCell(1).setCellValue(fvo.getSvcNm());
        //(ctn)  
        row.createCell(2).setCellValue(fvo.getDevMakerNm());
        row.createCell(3).setCellValue(fvo.getDevModelNm());
        row.createCell(4).setCellValue(fvo.getModemMakerNm());
        row.createCell(5).setCellValue(fvo.getModemModelNm());
        row.createCell(6).setCellValue(fvo.getDevQulInfo());
        row.createCell(7).setCellValue(fvo.getErrorDesc());
        row.createCell(8).setCellValue("(?)");
        row.createCell(9).setCellValue(fvo.getRat());
        row.createCell(10).setCellValue(fvo.getRssi());
        row.createCell(11).setCellValue(fvo.getQulAccCycle());
        row.createCell(12).setCellValue(fvo.getDevNonAccPeriod());
        row.createCell(13).setCellValue(fvo.getLastAccDt());
    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.statMgt.controller.StatDevExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "?";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<StatDevSearchVO> resultData = (List<StatDevSearchVO>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?/*  w  w  w  . j  a v a 2  s . co  m*/
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("FOTA TYPE");
    header.createCell(1).setCellValue("");
    header.createCell(2).setCellValue("");
    header.createCell(3).setCellValue("?");
    header.createCell(4).setCellValue("??");
    header.createCell(5).setCellValue("??");
    header.createCell(6).setCellValue("??");
    header.createCell(7).setCellValue("??");
    header.createCell(8).setCellValue("??");

    int index = 0;
    for (int i = 0; i < resultData.size(); i++) {
        StatDevSearchVO fvo = resultData.get(i);
        HSSFRow row = sheet.createRow(++index);
        row.createCell(0).setCellValue(fvo.getFotaType());
        row.createCell(1).setCellValue(fvo.getBizNm());
        row.createCell(2).setCellValue(fvo.getSvcNm());
        row.createCell(3).setCellValue(fvo.getDevMakerNm());
        row.createCell(4).setCellValue(fvo.getDevModelNm());
        row.createCell(5).setCellValue(fvo.getDevCntDtFrom());
        row.createCell(6).setCellValue(fvo.getDevCntDtTo());
        row.createCell(7).setCellValue(fvo.getIncDevCnt());
        row.createCell(8).setCellValue(fvo.getSumDevCntNow());
    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}

From source file:com.fota.statMgt.controller.StatFotaExcelDown.java

License:Open Source License

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    String date = DateTimeUtil.getCurrentDate();
    String formNm = "FOTA";
    String fileName = date + "_" + formNm;
    String sheetName = "sheet1";

    response.setContentType("application/vnd.ms-excel;charset=UTF-8");
    response.setHeader("Content-disposition",
            "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls");

    @SuppressWarnings("unchecked")
    List<StatFotaSearchVO> resultData = (List<StatFotaSearchVO>) model.get("resultData");

    HSSFSheet sheet = workbook.createSheet(sheetName);

    //  ?//from  w  ww .  j a  v a  2 s . c  o  m
    HSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("??");
    header.createCell(1).setCellValue("FOTA TYPE");
    header.createCell(2).setCellValue("");
    header.createCell(3).setCellValue("");
    header.createCell(4).setCellValue("?");
    header.createCell(5).setCellValue("??");
    header.createCell(6).setCellValue("");
    header.createCell(7).setCellValue("?");
    header.createCell(8).setCellValue("");
    header.createCell(9).setCellValue("?");
    header.createCell(10).setCellValue("");
    header.createCell(11).setCellValue("");
    header.createCell(12).setCellValue("");
    header.createCell(13).setCellValue("");
    header.createCell(14).setCellValue("(%)");

    int index = 0;
    for (int i = 0; i < resultData.size(); i++) {
        StatFotaSearchVO fvo = resultData.get(i);
        HSSFRow row = sheet.createRow(++index);
        row.createCell(0).setCellValue(fvo.getCretDt());
        row.createCell(1).setCellValue(fvo.getFotaType());
        row.createCell(2).setCellValue(fvo.getBizNm());
        row.createCell(3).setCellValue(fvo.getSvcNm());
        row.createCell(4).setCellValue(fvo.getDevMakerNm());
        row.createCell(5).setCellValue(fvo.getDevModelNm());
        row.createCell(6).setCellValue(fvo.getFirmwareMakerVer());
        row.createCell(7).setCellValue(fvo.getEarlyCnt());
        row.createCell(8).setCellValue(fvo.getWaitCnt());
        row.createCell(9).setCellValue(fvo.getVersionChkCnt());
        row.createCell(10).setCellValue(fvo.getProcessCnt());
        row.createCell(11).setCellValue(fvo.getSuccessCnt());
        row.createCell(12).setCellValue(fvo.getFailCnt());
        row.createCell(13).setCellValue(fvo.getTotal());
        row.createCell(14).setCellValue(fvo.getSuccessRate());
    }

    workbook.write(response.getOutputStream());
    response.getOutputStream().close();
}