Example usage for org.apache.poi.hssf.usermodel HSSFSheet createRow

List of usage examples for org.apache.poi.hssf.usermodel HSSFSheet createRow

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFSheet
  6. createRow

Introduction

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

Prototype

@Override
public HSSFRow createRow(int rownum)

Source Link

Document

Create a new row within the sheet and return the high level representation

Usage

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");
    // //  w w  w.  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");
    // /*from w w w. j a v a  2  s  .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");
    // //w  w  w .j  av a  2  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");
    // //from  ww  w .ja  v  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);

}

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

public File makeQzhqqExcel(List<Map> qzhqqList, String filePath) throws IOException {

    HSSFWorkbook wk = new HSSFWorkbook();
    HSSFSheet sheet = wk.createSheet("qzhqq");
    // /*from w  ww  . j  av a  2 s  .  c  om*/
    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] = "????";
    //??
    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 : qzhqqList) {
        // 
        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("BANKNAME")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("BANKID")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString(
                        "2".equals(((String) m.get("SUBJECTTYPE"))) ? "" : ""));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALTYPE")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALNUMBER")));
            }
            if (i == 12) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTSUBJECTNAME")));
            }
            if (i == 13) {
                cell.setCellValue(new HSSFRichTextString(
                        "02".equals(((String) m.get("INQUIRYMODE"))) ? "?" : "?"));
            }
            if (i == 14) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("REASON")));
            }
            if (i == 15) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("REMARK")));
            }
            if (i == 16) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONTIME")));
            }
            if (i == 17) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGID")));
            }
            if (i == 18) {
                cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGNAME")));
            }

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

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

        }
        //
        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 makeQzhjgExcel(List<Map> qzhzhxxList, List<Map> qzhdjList, String filePath) throws IOException {
    HSSFWorkbook wk = new HSSFWorkbook();
    HSSFSheet sheet1 = wk.createSheet("zhxx");
    HSSFSheet sheet2 = wk.createSheet("djxx");
    // /*from   w w w .  j a  v  a 2  s .  co 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] = "????";
    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] = "?";

    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] = "";

    //??
    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 : qzhzhxxList) {
        // 
        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("TRANSSERIALNUMBER")));
            }
            if (i == 1) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("NEWTRANSSERIALNUMBER")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNAME")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDNUMBER")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCH")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCHCODE")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTOPENTIME")));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONTIME")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONBRANCH")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("REMARK")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNUMBER")));
            }
            if (i == 11) {
                cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSERIAL")));
            }
            if (i == 12) {

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

        }
        //
        j++;
    }

    int k = 1;

    for (Map m2 : qzhdjList) {
        // 
        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("NEWTRANSSERIALNUMBER")));
            }
            if (i == 2) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZESERIAL")));
            }
            if (i == 3) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("ACCOUNTNUMBER")));
            }
            if (i == 4) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("CARDNUMBER")));
            }
            if (i == 5) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZESTARTTIME")));
            }
            if (i == 6) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZEENDTIME")));
            }
            if (i == 7) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZEDEPTNAME")));
            }
            if (i == 8) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("CURRENCY")));
            }
            if (i == 9) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZEBALANCE")));
            }
            if (i == 10) {
                cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZETYPE")));
            }

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

    return new File(filePath);
}

From source file:com.yyl.common.utils.excel.ExcelTools.java

public static void writeToXLS(ExcelRow heads, ExcelData data, String sheetName, ByteArrayOutputStream out)
        throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet(sheetName);
    HSSFRow row = sheet1.createRow(0);
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    HSSFCell cell;// w  w  w  .  j av  a 2s . co m

    for (int i = 0; i < heads.size(); i++) {
        cell = row.createCell(i);
        cell.setCellValue(heads.get(i));
        cell.setCellStyle(style);
    }
    if (data != null && data.size() != 0) {
        for (int n = 0; n < data.size(); n++) {
            row = sheet1.createRow(n + 1);
            ExcelRow datarow = data.get(n);
            for (int m = 0; m < datarow.size(); m++) {
                cell = row.createCell(m);
                cell.setCellValue(datarow.get(m));
                cell.setCellStyle(style);
            }
        }
    }
    wb.write(out);
}

From source file:com.zb.app.common.file.ExcelUtils.java

License:Open Source License

/**
 * excelrow?T??title?T/*from  w  w  w.  jav a2s  .  com*/
 * 
 * @param response
 * @param list
 * @param xlsName
 * @param headTitle
 * @return
 */
public static <T> HSSFWorkbook defBuildExcel(List<T> list, String xlsName, String... headTitle) {

    return buildExcel(list, xlsName, new IExcel<T>() {

        @Override
        public void initHSSRow(List<T> list, HSSFSheet sheet) {
            HSSFCell cell;
            for (int j = 0; j < list.size(); j++) {
                T row = list.get(j);
                if (row == null) {
                    continue;
                }
                HSSFRow hssrow = sheet.createRow(j + 1);
                Map<String, String> fieldValMap = BeanUtils.getFieldValueMap(row);

                int i = 0;
                for (Entry<String, String> entry : fieldValMap.entrySet()) {
                    Object value = entry.getValue();
                    cell = hssrow.createCell(i++);
                    cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                    cell.setCellValue(value == null ? StringUtils.EMPTY : value + StringUtils.EMPTY);
                }
            }
        }
    }, headTitle);
}

From source file:com.zdtx.ifms.specific.service.monitor.IpCamManager.java

@SuppressWarnings("unchecked")
public InputStream getExcel(String title) {
    List<Camera> data = new ArrayList<Camera>();
    Page<Camera> page_export = (Page<Camera>) Utils.getSession().getAttribute("page_export");
    DetachedCriteria criteria_export = (DetachedCriteria) Utils.getSession().getAttribute("criteria_export");
    List<Order> orderList_export = (List<Order>) Utils.getSession().getAttribute("orderList_export");
    page_export.setPageSize(page_export.getTotalCount());
    Page<Camera> pageResult = dao.getBatch(page_export, criteria_export.getExecutableCriteria(dao.getSession()),
            orderList_export);/*from  ww  w  .  j a v a2s.c  o m*/
    if (null != pageResult) {
        if (0 != pageResult.getResult().size()) {
            data = pageResult.getResult();

        }
    }
    ExportExcel ee = new ExportExcel() {

        @Override
        protected HSSFWorkbook disposeData(HSSFWorkbook wb, Object[] total, List<?> data) throws IOException {
            HSSFSheet sheet = wb.getSheetAt(0);
            sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6));
            HSSFRow rowss = sheet.createRow(0);
            rowss.setHeightInPoints(20);
            HSSFCell hssfCell = rowss.createCell(0);
            hssfCell = this.createCell(wb, hssfCell, total[0].toString());
            HSSFCellStyle style = this.createStyle(wb);
            HSSFRow row2 = sheet.createRow(1);
            HSSFCell cellrow01 = row2.createCell(0);
            cellrow01.setCellStyle(style);
            HSSFCell cellrow02 = row2.createCell(1);
            cellrow02.setCellStyle(style);
            HSSFCell cellrow03 = row2.createCell(2);
            cellrow03.setCellStyle(style);
            HSSFCell cellrow04 = row2.createCell(3);
            cellrow04.setCellStyle(style);
            HSSFCell cellrow05 = row2.createCell(4);
            cellrow05.setCellStyle(style);
            HSSFCell cellrow06 = row2.createCell(5);
            cellrow06.setCellStyle(style);
            HSSFCell cellrow07 = row2.createCell(6);
            cellrow07.setCellStyle(style);

            cellrow01.setCellValue("No.");
            cellrow02.setCellValue("Camera Name");
            cellrow03.setCellValue("Department");
            cellrow04.setCellValue("Camera Model");
            cellrow05.setCellValue("IP");
            cellrow06.setCellValue("Login Username");
            cellrow07.setCellValue("Login Password");

            if (null != data && 0 != data.size()) {

                for (int i = 0; i < data.size(); i++) {
                    Object[] o = (Object[]) data.get(i);
                    CamModel cm = (CamModel) o[0];
                    Camera a = (Camera) o[1];

                    HSSFRow row = sheet.createRow(i + 2);
                    HSSFCell cell001 = row.createCell(0);
                    cell001.setCellStyle(style);
                    cell001.setCellValue(i + 1);
                    HSSFCell cell002 = row.createCell(1);
                    cell002.setCellStyle(style);
                    cell002.setCellValue(a.getCameraName());
                    HSSFCell cell003 = row.createCell(2);
                    cell003.setCellStyle(style);
                    cell003.setCellValue(a.getDeptname());
                    HSSFCell cell004 = row.createCell(3);
                    cell004.setCellStyle(style);
                    cell004.setCellValue(cm.getModelName());

                    HSSFCell cell005 = row.createCell(4);
                    cell005.setCellStyle(style);
                    cell005.setCellValue(a.getIpAddress());

                    HSSFCell cell006 = row.createCell(5);
                    cell006.setCellStyle(style);
                    cell006.setCellValue(a.getAdminName());
                    HSSFCell cell007 = row.createCell(6);
                    cell007.setCellStyle(style);
                    cell007.setCellValue(a.getAdminPass());

                }
            }

            return wb;
        }
    };

    Object[] total = new Object[1];
    total[0] = title;
    String str = title;
    return ee.export(total, data, str);
}