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

List of usage examples for org.apache.poi.hssf.usermodel HSSFRow createCell

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFRow
  6. 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.vportal.portlet.vdoc.service.util.ReportUtil.java

License:Open Source License

public static void createCellAlignLeft(HSSFRow row, short column, String value, HSSFWorkbook wb) {

    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_LEFT);
    style.setBorderBottom(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderLeft(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderRight(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderTop(HSSFCellStyle.SOLID_FOREGROUND);

    HSSFCell cell = row.getCell(column);
    if (cell == null)
        cell = row.createCell(column);
    //cell.setEncoding(wb.ENCODING_UTF_16);
    cell.setCellValue(value);/*from  ww  w  . j ava2  s .c o m*/
    cell.setCellStyle(style);
}

From source file:com.vportal.portlet.vdoc.service.util.ReportUtil.java

License:Open Source License

public static void createCellBold(HSSFRow row, short column, String value, HSSFWorkbook wb) {

    HSSFCellStyle style = wb.createCellStyle();
    HSSFFont font = wb.createFont();/* w  w  w .  jav a  2 s . c  om*/
    font.setColor((short) 0xc);
    font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
    style.setFont(font);
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    style.setBorderBottom(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderLeft(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderRight(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderTop(HSSFCellStyle.SOLID_FOREGROUND);

    HSSFCell cell = row.getCell(column);
    if (cell == null)
        cell = row.createCell(column);
    //cell.setEncoding(wb.ENCODING_UTF_16);
    cell.setCellValue(value);
    cell.setCellStyle(style);
}

From source file:com.vportal.portlet.vdoc.service.util.ReportUtil.java

License:Open Source License

public static void createCell(HSSFRow row, short column, int value, HSSFWorkbook wb) {
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    style.setBorderBottom(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderLeft(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderRight(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderTop(HSSFCellStyle.SOLID_FOREGROUND);

    HSSFCell cell = row.getCell(column);
    if (cell == null)
        cell = row.createCell(column);
    cell.setCellValue(value);//from w  w w .j  a  v a  2s .c o m
    cell.setCellStyle(style);
}

From source file:com.work.fileHandle.fileHandleServlet.java

public HSSFWorkbook createExcel() {

    HSSFWorkbook webbook = new HSSFWorkbook();

    HSSFSheet sheet = webbook.createSheet("?");

    HSSFRow row = sheet.createRow((int) 0);

    HSSFCellStyle style = webbook.createCellStyle();

    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);

    HSSFCell cell = row.createCell((short) 0);
    cell.setCellValue("?");
    cell.setCellStyle(style);/*from   ww  w.ja v  a2s .  co m*/
    cell = row.createCell((short) 1);
    cell.setCellValue("??");
    cell.setCellStyle(style);
    cell = row.createCell((short) 2);
    cell.setCellValue("??");
    cell.setCellStyle(style);
    cell = row.createCell((short) 3);
    cell.setCellValue("??");
    cell.setCellStyle(style);
    cell = row.createCell((short) 4);
    cell.setCellValue("?");
    cell.setCellStyle(style);

    List students = query();

    for (int i = 0; i < students.size(); i++) {
        row = sheet.createRow((int) i + 1);
        Student student = (Student) students.get(i);

        row.createCell((short) 0).setCellValue(student.getStudentId().toString());
        row.createCell((short) 1).setCellValue(student.getStudentCode());
        row.createCell((short) 2).setCellValue(student.getEnName());
        row.createCell((short) 3).setCellValue(student.getCnName());
        row.createCell((short) 4).setCellValue(student.getGrade());
    }

    try {
        String savePath = this.getServletContext().getRealPath("/WEB-INF/uploads");
        String filename = "students-grade.xls";
        File file = new File(savePath);

        if (!file.exists() && !file.isDirectory()) {
            System.out.println(savePath + "??");
            file.mkdir();
        }

        FileOutputStream fout = new FileOutputStream(savePath + "/" + filename);
        webbook.write(fout);
        fout.close();
    } catch (Exception e) {
        e.printStackTrace();
    }

    return webbook;
}

From source file:com.xnradmin.core.test.TestJson.java

private static void processYsmcExcel(String res) throws JSONException, org.json.JSONException {
    JSONObject jo = new JSONObject(res);

    Iterator it = jo.keys();//from   w ww .  j av  a2  s . c  om

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("ysmc");
    HSSFRow row = sheet.createRow((int) 0);
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ?
    HSSFCell cell = row.createCell(0);
    cell.setCellValue("??");
    cell.setCellStyle(style);
    cell = row.createCell(1);

    cell.setCellValue("");
    cell.setCellStyle(style);
    cell = row.createCell(2);

    cell.setCellValue("??");
    cell.setCellStyle(style);
    cell = row.createCell(3);

    cell.setCellValue("??");
    cell.setCellStyle(style);
    cell = row.createCell(4);

    cell.setCellValue("?");
    cell.setCellStyle(style);
    cell = row.createCell(5);

    cell.setCellValue("?2");
    cell.setCellStyle(style);
    cell = row.createCell(6);

    cell.setCellValue("");
    cell.setCellStyle(style);
    cell = row.createCell(7);

    cell.setCellValue("?");
    cell.setCellStyle(style);
    cell = row.createCell(8);

    cell.setCellValue("");
    cell.setCellStyle(style);
    cell = row.createCell(9);

    cell.setCellValue("");
    cell.setCellStyle(style);
    cell = row.createCell(10);

    cell.setCellValue("?");
    cell.setCellStyle(style);
    cell = row.createCell(11);

    int flag = 0;

    while (it.hasNext()) {
        String k = it.next().toString();
        // System.out.println(jo.get(k));
        flag = processYsmcSubLevel1(k, jo.get(k).toString(), wb, sheet, row, flag);
    }

    FileOutputStream fout;
    try {
        fout = new FileOutputStream("/Users/liubin/temp/ysmc" + StringHelper.getSystime("yyyyMMdd") + ".xls");
        wb.write(fout);
        fout.close();
    } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

From source file:com.xnradmin.core.test.TestJson.java

private static int processYsmcSubLevel2(String type1, String type2, String content, HSSFWorkbook wb,
        HSSFSheet sheet, HSSFRow row, int flag) throws JSONException, org.json.JSONException {
    JSONArray data = new JSONArray(content);

    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ?

    for (int i = 0; i < data.length(); i++) {

        JSONObject temp = (JSONObject) data.get(i);

        System.out.println(temp);

        StringBuffer sb = new StringBuffer();
        sb.append("??").append(temp.get("name"));
        sb.append(" | ").append(temp.get("level"));
        sb.append(" | ??").append(temp.get("format"));
        sb.append(" | ??").append(temp.get("unit"));
        sb.append(" | ?:").append(temp.get("own_brand"));
        sb.append(" | ?2: ").append(temp.get("sell_brand"));
        sb.append(" | ").append(temp.get("class1"));
        sb.append(" | ").append(type1);
        sb.append(" | ?").append(type2);
        sb.append(" | ?").append(temp.get("price"));
        sb.append(" | ").append(temp.get("commodity_total_price"));
        System.out.println(sb.toString());

        int f = flag + 1;
        row = sheet.createRow(f);//from  www  .  j  a v  a2s . c  o m
        System.out.println("row: " + f);

        HSSFCell cell0 = row.createCell(0);
        cell0.setCellStyle(style);
        cell0.setCellValue(temp.get("name").toString());

        HSSFCell cell1 = row.createCell(1);
        cell1.setCellStyle(style);
        cell1.setCellValue(temp.get("level").toString());

        HSSFCell cell2 = row.createCell(2);
        cell2.setCellStyle(style);
        cell2.setCellValue(temp.get("format").toString());

        HSSFCell cell3 = row.createCell(3);
        cell3.setCellStyle(style);
        cell3.setCellValue(temp.get("unit").toString());

        HSSFCell cell4 = row.createCell(4);
        cell4.setCellStyle(style);
        cell4.setCellValue(temp.get("own_brand").toString());

        HSSFCell cell5 = row.createCell(5);
        cell5.setCellStyle(style);
        cell5.setCellValue(temp.get("sell_brand").toString());

        HSSFCell cell6 = row.createCell(6);
        cell6.setCellStyle(style);
        cell6.setCellValue(temp.get("class1").toString());

        HSSFCell cell7 = row.createCell(7);
        cell7.setCellStyle(style);
        cell7.setCellValue(temp.get("price").toString());

        HSSFCell cell8 = row.createCell(8);
        cell8.setCellStyle(style);
        cell8.setCellValue(temp.get("commodity_total_price").toString());

        HSSFCell cell9 = row.createCell(9);
        cell9.setCellStyle(style);
        cell9.setCellValue(type1);

        HSSFCell cell10 = row.createCell(10);
        cell10.setCellStyle(style);
        cell10.setCellValue(type2);

        // row.createCell(0).setCellValue(temp.get("name").toString());
        // row.createCell(1).setCellValue(temp.get("format").toString());
        // row.createCell(2).setCellValue(temp.get("unit").toString());
        // row.createCell(3).setCellValue(temp.get("own_brand").toString());
        // row.createCell(4).setCellValue(temp.get("sell_brand").toString());
        // row.createCell(5).setCellValue(temp.get("class1").toString());
        // row.createCell(6).setCellValue(temp.get("price").toString());

        flag = f;
    }
    return flag;
}

From source file:com.yitong.app.service.judicial.dxzpjymx.JymxService.java

public File makeZhjyqqExcel(List<Map> zhjyqqList, String filePath) throws IOException {

    HSSFWorkbook wk = new HSSFWorkbook();
    HSSFSheet sheet = wk.createSheet("zhjyqq");
    // //from www  .  ja  va  2 s  . c  o  m
    HSSFRow firstRow = sheet.createRow(0);
    int totalColNum = 27;
    //?
    HSSFCell[] firstCell = new HSSFCell[totalColNum];
    //??string
    String[] colNames = new String[totalColNum];

    colNames[0] = "?";
    colNames[1] = "?";
    colNames[2] = "???";
    colNames[3] = "??";
    colNames[4] = "?";
    colNames[5] = "";
    colNames[6] = "";
    colNames[7] = "";
    colNames[8] = "?";
    colNames[9] = "??";
    colNames[10] = "??";
    colNames[11] = "?/?";
    colNames[12] = "";
    colNames[13] = "?";
    colNames[14] = "?";
    colNames[15] = "";
    colNames[16] = "";
    colNames[17] = "";
    colNames[18] = "?";
    colNames[19] = "??";
    colNames[20] = "??";
    colNames[21] = "???";
    colNames[22] = "???";
    colNames[23] = "??";
    colNames[24] = "???";
    colNames[25] = "????";
    colNames[26] = "????";

    //??
    for (int i = 0; i < totalColNum; i++) {
        //?
        firstCell[i] = firstRow.createCell(i);
        //? ?? new HSSFRichTextString(colNames[i]) ?
        firstCell[i].setCellValue(new HSSFRichTextString(colNames[i]));
    }

    //???excel
    //j1 ?rs
    int j = 1;
    //?
    DataValidation data_validation = null;

    for (Map m : zhjyqqList) {
        // 
        HSSFRow row = sheet.createRow(j);
        for (int i = 0; i < totalColNum; i++) {
            //??
            HSSFCell cell = row.createCell(i);
            //? ?new HSSFRichTextString()?? 
            //rs.getString(i+1)1??
            if (i == 0) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID")));
            }
            if (i == 1) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("MESSAGEFROM")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CASENUMBER")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CASETYPE")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString(
                        "02".equals(((String) m.get("EMERGENCYLEVEL"))) ? "" : ""));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("SUBJECTTYPE")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("BANKID")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("BANKNAME")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTNAME")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CARDNUMBER")));
            }
            if (i == 12) {
                String str = (String) m.get("INQUIRYMODE");
                String INQUIRYMODE = "";

                if ("01".equals(str)) {
                    INQUIRYMODE = "?";
                } else if ("02".equals(str)) {
                    INQUIRYMODE = "";
                } else if ("03".equals(str)) {
                    INQUIRYMODE = "?+";
                } else {
                    INQUIRYMODE = "";
                }
                cell.setCellValue(new HSSFRichTextString(INQUIRYMODE));
            }
            if (i == 13) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INQUIRYPERIODSTART")));
            }
            if (i == 14) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INQUIRYPERIODEND")));
            }
            if (i == 15) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("REASON")));
            }
            if (i == 16) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("REMARK")));
            }
            if (i == 17) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONTIME")));
            }
            if (i == 18) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGID")));
            }

            if (i == 19) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGNAME")));
            }

            if (i == 20) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDTYPE")));
            }
            if (i == 21) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDNUMBER")));
            }
            if (i == 22) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORNAME")));
            }
            if (i == 23) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORPHONENUMBER")));
            }
            if (i == 24) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDTYPE")));
            }
            if (i == 25) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDNUMBER")));
            }
            if (i == 26) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORNAME")));
            }

        }
        //
        j++;
    }
    //?
    OutputStream out = new FileOutputStream(filePath);
    //?excel?
    wk.write(out);
    //?
    out.close();

    return new File(filePath);

}

From source file:com.yitong.app.service.judicial.dxzpjymx.JymxService.java

public File makeZhjyjgExcel(List<Map> zhxxList, List<Map> jymxList, String filePath) throws IOException {
    HSSFWorkbook wk = new HSSFWorkbook();
    HSSFSheet sheet1 = wk.createSheet("zhxx");
    HSSFSheet sheet2 = wk.createSheet("jymx");
    // // ww w .  j  a v  a 2s .c  o  m
    HSSFRow firstRow1 = sheet1.createRow(0);
    HSSFRow firstRow2 = sheet2.createRow(0);
    int totalColNum1 = 40;
    int totalColNum2 = 31;
    //?
    HSSFCell[] firstCell1 = new HSSFCell[totalColNum1];
    HSSFCell[] firstCell2 = new HSSFCell[totalColNum2];
    //??string
    String[] colNames1 = new String[totalColNum1];

    colNames1[0] = "?";
    colNames1[1] = "ID";
    colNames1[2] = "?";
    colNames1[3] = "??";
    colNames1[4] = "??";
    colNames1[5] = "";
    colNames1[6] = "";
    colNames1[7] = "?";
    colNames1[8] = "";
    colNames1[9] = "";
    colNames1[10] = "";
    colNames1[11] = "";
    colNames1[12] = "??";
    colNames1[13] = "(?)??";
    colNames1[14] = "(?)";
    colNames1[15] = "?";
    colNames1[16] = "??";
    colNames1[17] = "";
    colNames1[18] = "?";
    colNames1[19] = "??";
    colNames1[20] = "?";
    colNames1[21] = "??";
    colNames1[22] = "???";
    colNames1[23] = "??";
    colNames1[24] = "?";
    colNames1[25] = "?/???";
    colNames1[26] = "?/??";
    colNames1[27] = "?/????";
    colNames1[28] = "??";
    colNames1[29] = "??";
    colNames1[30] = "??";
    colNames1[31] = "???";
    colNames1[32] = "???";
    colNames1[33] = "?";
    colNames1[34] = "";
    colNames1[35] = "?";
    colNames1[36] = "???";
    colNames1[37] = "??";
    colNames1[38] = "?";
    colNames1[39] = "?";

    String[] colNames2 = new String[totalColNum2];
    colNames2[0] = "?";
    colNames2[1] = "";
    colNames2[2] = "??";
    colNames2[3] = "";
    colNames2[4] = "";
    colNames2[5] = "?";
    colNames2[6] = "??";
    colNames2[7] = "";
    colNames2[8] = "?";
    colNames2[9] = "??";
    colNames2[10] = "??";
    colNames2[11] = "???";
    colNames2[12] = "??";
    colNames2[13] = "?";
    colNames2[14] = "?";
    colNames2[15] = "?";
    colNames2[16] = "??";
    colNames2[17] = "?";
    colNames2[18] = "?";
    colNames2[19] = "??";
    colNames2[20] = "??";
    colNames2[21] = "?";
    colNames2[22] = "";
    colNames2[23] = "?";
    colNames2[24] = "??";
    colNames2[25] = "?";
    colNames2[26] = "??";
    colNames2[27] = "MAC?";
    colNames2[28] = "IP?";
    colNames2[29] = "";
    colNames2[30] = "?";

    //??
    for (int i = 0; i < totalColNum1; i++) {
        //?
        firstCell1[i] = firstRow1.createCell(i);
        //? ?? new HSSFRichTextString(colNames[i]) ?
        firstCell1[i].setCellValue(new HSSFRichTextString(colNames1[i]));
    }

    //??
    for (int i = 0; i < totalColNum2; i++) {
        //?
        firstCell2[i] = firstRow2.createCell(i);
        //? ?? new HSSFRichTextString(colNames[i]) ?
        firstCell2[i].setCellValue(new HSSFRichTextString(colNames2[i]));
    }

    //???excel
    //j1 ?rs
    int j = 1;

    for (Map m1 : zhxxList) {
        // 
        HSSFRow row = sheet1.createRow(j);
        for (int i = 0; i < totalColNum1; i++) {
            //??
            HSSFCell cell = row.createCell(i);
            //? ?new HSSFRichTextString()?? 
            //rs.getString(i+1)1??
            if (i == 0) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("APPLICATIONID")));
            }
            if (i == 1) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("JSJG")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("TXCODE")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("TRANSSERIALNUMBER")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNAME")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDNUMBER")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCH")));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCHCODE")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTOPENTIME")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONTIME")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONBRANCH")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("REMARK")));
            }
            if (i == 12) {

                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNUMBER")));
            }
            if (i == 13) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSERIAL")));
            }
            if (i == 14) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTTYPE")));
            }
            if (i == 15) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSTATUS")));
            }
            if (i == 16) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CURRENCY")));
            }
            if (i == 17) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CASHREMIT")));
            }
            if (i == 18) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTBALANCE")));
            }

            if (i == 19) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("AVAILABLEBALANCE")));
            }

            if (i == 20) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("LASTTRANSACTIONTIME")));
            }
            if (i == 21) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCREDENTIALTYPE")));
            }
            if (i == 22) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCREDENTIALNUMBER")));
            }
            if (i == 23) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSUBJECTNAME")));
            }
            if (i == 24) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("TELNUMBER")));
            }
            if (i == 25) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDOPERATORNAME")));
            }
            if (i == 26) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDOPERATORCREDENTIALTYPE")));
            }
            if (i == 27) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDOPERATORCREDENTIALNUMBER")));
            }
            if (i == 28) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("RESIDENTADDRESS")));
            }
            if (i == 29) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("RESIDENTTELNUMBER")));
            }
            if (i == 30) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("WORKCOMPANYNAME")));
            }
            if (i == 31) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("WORKADDRESS")));
            }
            if (i == 32) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("WORKTELNUMBER")));
            }
            if (i == 33) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("EMAILADDRESS")));
            }
            if (i == 34) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ARTIFICIALPERSONREP")));
            }
            if (i == 35) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ARTIFICIALPERSONREPCREDENTIALTYPE")));
            }
            if (i == 36) {
                cell.setCellValue(
                        new HSSFRichTextString((String) m1.get("ARTIFICIALPERSONREPCREDENTIALNUMBER")));
            }

            if (i == 37) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("BUSINESSLICENSENUMBER")));
            }
            if (i == 38) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("STATETAXSERIAL")));
            }
            if (i == 39) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("LOCALTAXSERIAL")));
            }

        }
        //
        j++;
    }

    int k = 1;

    for (Map m2 : jymxList) {
        // 
        HSSFRow row = sheet2.createRow(k);
        for (int i = 0; i < totalColNum2; i++) {
            //??
            HSSFCell cell = row.createCell(i);
            //? ?new HSSFRichTextString()?? 
            //rs.getString(i+1)1??
            if (i == 0) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("APPLICATIONID")));
            }
            if (i == 1) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("CARDNUMBER")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSSERIALNUMBER")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("BORROWINGSIGNS")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONTYPE")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONAMOUNT")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("CURRENCY")));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONTIME")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("ACCOUNTBALANCE")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTNAME")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONSERIAL")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTCREDENTIALNUMBER")));
            }
            if (i == 12) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTACCOUNTNUMBER")));
            }
            if (i == 13) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONREMARK")));
            }
            if (i == 14) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTDEPOSITBANKID")));
            }
            if (i == 15) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONBRANCHCODE")));
            }

            if (i == 16) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONBRANCHNAME")));
            }
            if (i == 17) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("SUMMONSNUMBER")));
            }
            if (i == 18) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("LOGNUMBER")));
            }

            if (i == 19) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("VOUCHERCODE")));
            }

            if (i == 20) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("VOUCHERTYPE")));
            }
            if (i == 21) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TERMINALNUMBER")));
            }
            if (i == 22) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("CASHMARK")));
            }
            if (i == 23) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONADDRESS")));
            }
            if (i == 24) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONSTATUS")));
            }
            if (i == 25) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("MERCHANTCODE")));
            }
            if (i == 26) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("MERCHANTNAME")));
            }
            if (i == 27) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("MAC")));
            }
            if (i == 28) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("IPADDRESS")));
            }
            if (i == 29) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("REMARK")));
            }
            if (i == 30) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("TELLERCODE")));
            }

        }
        //
        k++;
    }
    //?
    OutputStream out = new FileOutputStream(filePath);
    //?excel?
    wk.write(out);
    //?
    out.close();

    return new File(filePath);
}

From source file:com.yitong.app.service.judicial.dxzpjymx.JymxService.java

public File makeCkztqqExcel(List<Map> ckztqqList, String filePath) throws IOException {

    HSSFWorkbook wk = new HSSFWorkbook();
    HSSFSheet sheet = wk.createSheet("ckztqq");
    // /*from   www.  j  a  v  a2 s .  c  o  m*/
    HSSFRow firstRow = sheet.createRow(0);
    int totalColNum = 24;
    //?
    HSSFCell[] firstCell = new HSSFCell[totalColNum];
    //??string
    String[] colNames = new String[totalColNum];

    colNames[0] = "?";
    colNames[1] = "?";
    colNames[2] = "???";
    colNames[3] = "??";
    colNames[4] = "?";
    colNames[5] = "";
    colNames[6] = "";
    colNames[7] = "";
    colNames[8] = "?";
    colNames[9] = "??";
    colNames[10] = "??";
    colNames[11] = "?/?";
    colNames[12] = "";
    colNames[13] = "";
    colNames[14] = "";
    colNames[15] = "?";
    colNames[16] = "??";
    colNames[17] = "??";
    colNames[18] = "???";
    colNames[19] = "???";
    colNames[20] = "??";
    colNames[21] = "???";
    colNames[22] = "????";
    colNames[23] = "????";

    //??
    for (int i = 0; i < totalColNum; i++) {
        //?
        firstCell[i] = firstRow.createCell(i);
        //? ?? new HSSFRichTextString(colNames[i]) ?
        firstCell[i].setCellValue(new HSSFRichTextString(colNames[i]));
    }

    //???excel
    //j1 ?rs
    int j = 1;

    for (Map m : ckztqqList) {
        // 
        HSSFRow row = sheet.createRow(j);
        for (int i = 0; i < totalColNum; i++) {
            //??
            HSSFCell cell = row.createCell(i);
            //? ?new HSSFRichTextString()?? 
            //rs.getString(i+1)1??
            if (i == 0) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID")));
            }
            if (i == 1) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("MESSAGEFROM")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CASENUMBER")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CASETYPE")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString(
                        "02".equals(((String) m.get("EMERGENCYLEVEL"))) ? "" : ""));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("SUBJECTTYPE")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("BANKID")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("BANKNAME")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTNAME")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CARDNUMBER")));
            }
            if (i == 12) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("REMARK")));
            }
            if (i == 13) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("REASON")));
            }
            if (i == 14) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONTIME")));
            }
            if (i == 15) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGID")));
            }
            if (i == 16) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGNAME")));
            }
            if (i == 17) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDTYPE")));
            }
            if (i == 18) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDNUMBER")));
            }

            if (i == 19) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORNAME")));
            }

            if (i == 20) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORPHONENUMBER")));
            }
            if (i == 21) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDTYPE")));
            }
            if (i == 22) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDNUMBER")));
            }
            if (i == 23) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORNAME")));
            }

        }
        //
        j++;
    }
    //?
    OutputStream out = new FileOutputStream(filePath);
    //?excel?
    wk.write(out);
    //?
    out.close();

    return new File(filePath);

}

From source file:com.yitong.app.service.judicial.dxzpjymx.JymxService.java

public File makeCkztjgExcel(List<Map> ckztjgList, String filePath) throws IOException {

    HSSFWorkbook wk = new HSSFWorkbook();
    HSSFSheet sheet = wk.createSheet("ckztjg");
    // //ww w.  jav  a  2s  .  c  o  m
    HSSFRow firstRow = sheet.createRow(0);
    int totalColNum = 24;
    //?
    HSSFCell[] firstCell = new HSSFCell[totalColNum];
    //??string
    String[] colNames = new String[totalColNum];

    colNames[0] = "??";
    colNames[1] = "????";
    colNames[2] = "ID";
    colNames[3] = "?";
    colNames[4] = "???";
    colNames[5] = "?";
    colNames[6] = "?";
    colNames[7] = "??";
    colNames[8] = "?/??";
    colNames[9] = "??";
    colNames[10] = "??";
    colNames[11] = "?/???";
    colNames[12] = "??";
    colNames[13] = "?/????";
    colNames[14] = "???";
    colNames[15] = "??";
    colNames[16] = "?";
    colNames[17] = "???";
    colNames[18] = "";
    colNames[19] = "?";
    colNames[20] = "???";
    colNames[21] = "??";
    colNames[22] = "?";
    colNames[23] = "?";

    //??
    for (int i = 0; i < totalColNum; i++) {
        //?
        firstCell[i] = firstRow.createCell(i);
        //? ?? new HSSFRichTextString(colNames[i]) ?
        firstCell[i].setCellValue(new HSSFRichTextString(colNames[i]));
    }

    //???excel
    //j1 ?rs
    int j = 1;

    for (Map m : ckztjgList) {
        // 
        HSSFRow row = sheet.createRow(j);
        for (int i = 0; i < totalColNum; i++) {
            //??
            HSSFCell cell = row.createCell(i);
            //? ?new HSSFRichTextString()?? 
            //rs.getString(i+1)1??
            if (i == 0) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER")));
            }
            if (i == 1) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("NEWTRANSSERIALNUMBER")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("JSJG")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALNUMBER")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("TELNUMBER")));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALTYPE")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CARDOPERATORCREDENTIALTYPE")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTSUBJECTNAME")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("RESIDENTADDRESS")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CARDOPERATORNAME")));
            }
            if (i == 12) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("WORKCOMPANYNAME")));
            }
            if (i == 13) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("CARDOPERATORCREDENTIALNUMBER")));
            }
            if (i == 14) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("WORKTELNUMBER")));
            }
            if (i == 15) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("RESIDENTTELNUMBER")));
            }
            if (i == 16) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("EMAILADDRESS")));
            }
            if (i == 17) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("WORKADDRESS")));
            }
            if (i == 18) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ARTIFICIALPERSONREP")));
            }

            if (i == 19) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ARTIFICIALPERSONREPCREDENTIALTYPE")));
            }

            if (i == 20) {
                cell.setCellValue(
                        new HSSFRichTextString((String) m.get("ARTIFICIALPERSONREPCREDENTIALNUMBER")));
            }
            if (i == 21) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("BUSINESSLICENSENUMBER")));
            }
            if (i == 22) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("STATETAXSERIAL")));
            }
            if (i == 23) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("LOCALTAXSERIAL")));
            }

        }
        //
        j++;
    }
    //?
    OutputStream out = new FileOutputStream(filePath);
    //?excel?
    wk.write(out);
    //?
    out.close();

    return new File(filePath);

}