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

Introduction

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

Prototype

@Override
public HSSFSheet createSheet(String sheetname) 

Source Link

Document

Create a new sheet for this Workbook and return the high level representation.

Usage

From source file:com.fota.devMgt.controller.DevstatExcelDown.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<DevSearchVO> resultData = (List<DevSearchVO>) 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("??");
    header.createCell(1).setCellValue("");
    header.createCell(2).setCellValue("");
    header.createCell(3).setCellValue("?");
    header.createCell(4).setCellValue("??");
    header.createCell(5).setCellValue("?");
    header.createCell(6).setCellValue("IMEI");
    header.createCell(7).setCellValue("CTN");
    header.createCell(8).setCellValue("FOTA");
    header.createCell(9).setCellValue("?");
    header.createCell(10).setCellValue("?");
    header.createCell(11).setCellValue("???");
    header.createCell(12).setCellValue("??");

    int index = 0;
    for (int i = 0; i < resultData.size(); i++) {
        DevSearchVO fvo = resultData.get(i);
        HSSFRow row = sheet.createRow(++index);
        row.createCell(0).setCellValue(fvo.getDevId());
        row.createCell(1).setCellValue(fvo.getBizNm());
        row.createCell(2).setCellValue(fvo.getSvcNm());
        row.createCell(3).setCellValue(fvo.getMakerNm());
        row.createCell(4).setCellValue(fvo.getDevModelNm());
        row.createCell(5).setCellValue(fvo.getClientNm());
        row.createCell(6).setCellValue("");
        row.createCell(7).setCellValue("");
        row.createCell(8).setCellValue(fvo.getFotaYn());
        row.createCell(9).setCellValue(fvo.getProcessStatCd());
        row.createCell(10).setCellValue(fvo.getLastAccDt());
        row.createCell(11).setCellValue(fvo.getDevAccTerm());
        row.createCell(12).setCellValue(fvo.getCretDt());
    }

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

---

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");

    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    // ?  /*from ww  w.j av  a2s  .  co 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. j  a va 2s. c  o m
    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);

    //  ?/* ww w.j  av  a2  s .co  m*/
    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 av  a 2  s  .com
    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);

    //  ?//  w  w w . j ava 2s  .c  om
    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.  java 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  av  a2s . 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("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);

    //  ?/*  w  w  w  .ja  v a 2s  .c  o  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  va  2  s .c  o  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();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• »