Example usage for org.apache.poi.hssf.usermodel HSSFRow createCell

Introduction

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

Prototype

@Override
public HSSFCell createCell(int column) 

Source Link

Document

Use this to create new cells within the row and return it.

Usage

From source file:com.esd.ps.excel.PoiCreateExcel.java

License:Open Source License

/**
 * ?//from   w w w  .j  av a2s.com
 * 
 * @param FilePath
 * @param companyList
 * @return
 */
public static boolean createRegistrationExcel(String FilePath, List<Registration> list) {
    // Excel Workbook,excel
    HSSFWorkbook wb = new HSSFWorkbook();
    // Excelsheet,exceltab
    HSSFSheet sheet = wb.createSheet("sheet1");
    // excel?
    sheet.setColumnWidth(0, 4000);
    sheet.setColumnWidth(1, 3500);

    // Excel?
    HSSFRow headRow = sheet.createRow(0);
    HSSFCell headell = headRow.createCell(0);
    // ???
    headell = headRow.createCell(0);
    headell.setCellValue("??");
    headell = headRow.createCell(1);
    headell.setCellValue("??");
    headell = headRow.createCell(2);
    headell.setCellValue("??");
    // sheet.setColumnWidth(2, 12000); // 

    headell = headRow.createCell(3);
    headell.setCellValue("QQ");
    headell = headRow.createCell(4);
    headell.setCellValue("??");

    headell = headRow.createCell(5);
    headell.setCellValue("??");
    SimpleDateFormat sdf = new SimpleDateFormat(Constants.DATETIME_FORMAT);
    for (int i = 1; i <= list.size(); i++) {
        Registration r = list.get(i - 1);
        // Excel?
        HSSFRow row = sheet.createRow(i);
        HSSFCell cell = row.createCell(0);
        // ???
        // ??
        cell = row.createCell(0);
        cell.setCellValue(r.getName());
        // ??
        cell = row.createCell(1);
        cell.setCellValue(r.getCard());
        // ?
        cell = row.createCell(2);
        cell.setCellValue(r.getPhone());
        // QQ
        cell = row.createCell(3);
        cell.setCellValue(r.getQq());
        // ??
        cell = row.createCell(4);
        cell.setCellValue(r.getAddress());
        // ??
        cell = row.createCell(5);
        cell.setCellValue(sdf.format(r.getCreateTime()));
    }
    try {
        FileOutputStream os = new FileOutputStream(FilePath);
        wb.write(os);
        os.flush();
        os.close();
        list.clear();
        list = null;
        os = null;
        wb = null;
        System.gc();
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }
    return true;
}

---

From source file:com.excel.ExcelView.java

public void setExcelHeader(HSSFSheet excelSheet, List titles) {
    HSSFRow excelHeader = excelSheet.createRow(0);
    for (int i = 0; i < titles.size(); i++) {
        excelHeader.createCell(i).setCellValue(titles.get(i).toString());
    }//ww  w  .  j a  v a  2  s. co m
}

---

From source file:com.excel.ExcelView.java

public void setExcelRows(HSSFSheet excelSheet, List<List<String>> content) {
    int record = 1;
    for (List<String> row : content) {
        HSSFRow excelRow = excelSheet.createRow(record++);
        int cnt = 0;
        for (String value : row) {
            excelRow.createCell(cnt++).setCellValue(value);
        }//from w  w w.  ja v  a  2 s .  c  o  m
    }
}

---

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

    //  ?/*from  w ww.  j  a v a 2s.  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("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  w  w  w . ja va2s.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  w w  w .  j  a  v  a2 s .com*/
    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);

    //  ?/*from   w w  w .j a v a2  s.c  o 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);

    //  ?//from  ww w.j a  v a2s .  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("");
    //(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 .ja va2 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("?");
    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);

    //  ?/* w ww . j a v a  2s.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("");
    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();
}

---

• «
• 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
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »