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

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

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

Introduction

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

Prototype

@Override
public HSSFSheet createSheet(String sheetname)

Source Link

Document

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

Usage

From source file:com.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   w  ww  .  ja  v a 2s.co  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 av  a 2 s.  c om
    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   w  w  w.j  a va  2 s  . c om
    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   w w w.j ava2 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] = "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");
    // // w  ww .j a v  a 2s .  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] = "????";
    //??
    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  ww. j a v a2  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);/*w  w w  .j  ava  2 s.c  o  m*/
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    HSSFCell cell;

    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.zhu.action.CarAction.java

public void exportpeople(ActionMapping mapping, ActionForm form, HttpServletRequest request,
        HttpServletResponse response) {//from   w w w. j  a  v  a 2 s .co m
    CarForm carForm = (CarForm) form;

    // webbookExcel
    HSSFWorkbook wb = new HSSFWorkbook();
    // webbooksheet,Excelsheet
    HSSFSheet sheet = wb.createSheet("?");
    // sheet0,??poiExcel?short
    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);
    // ? ??
    OrderService orderService = new OrderService();
    List<Orderinfo> list = orderService.getOrderCarDetail(carForm.getId());
    System.out.println(list.size());
    for (int i = 0; i < list.size(); i++) {
        row = sheet.createRow(i + 1);
        Orderinfo order = (Orderinfo) list.get(i);
        // ?
        row.createCell(0).setCellValue(order.getN1());
        row.createCell(1).setCellValue(order.getI1());
        row = sheet.createRow(i + list.size() + 1);
        row.createCell(0).setCellValue(order.getN2());
        row.createCell(1).setCellValue(order.getI2());
        row = sheet.createRow(i + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN3());
        row.createCell(1).setCellValue(order.getI3());
        row = sheet.createRow(i + list.size() + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN4());
        row.createCell(1).setCellValue(order.getI4());
        row = sheet.createRow(i + list.size() + list.size() + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN5());
        row.createCell(1).setCellValue(order.getI5());
        row = sheet.createRow(i + list.size() + list.size() + list.size() + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN6());
        row.createCell(1).setCellValue(order.getI6());
        row = sheet.createRow(
                i + list.size() + list.size() + list.size() + list.size() + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN7());
        row.createCell(1).setCellValue(order.getI7());
        row = sheet.createRow(i + list.size() + list.size() + list.size() + list.size() + list.size()
                + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN8());
        row.createCell(1).setCellValue(order.getI8());
        row = sheet.createRow(i + list.size() + list.size() + list.size() + list.size() + list.size()
                + list.size() + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN9());
        row.createCell(1).setCellValue(order.getI9());
        row = sheet.createRow(i + list.size() + list.size() + list.size() + list.size() + list.size()
                + list.size() + list.size() + list.size() + list.size() + 1);
        row.createCell(0).setCellValue(order.getN10());
        row.createCell(1).setCellValue(order.getI10());
    }
    // ?
    String filePath = "";
    Date dt = new Date();
    DateFormat df = new SimpleDateFormat("yyyyMMddHHmmss");
    String date = df.format(dt).toString();
    filePath = "/Users/Nemo/Documents/carpeople" + date + ".xls";
    File file = new File(filePath);

    try {
        // FileOutputStream fout = new FileOutputStream(
        // "/Users/Nemo/Documents/carpeople.xls");
        // wb.write(fout);
        // fout.close();
        OutputStream out = new FileOutputStream(file);
        wb.write(out);
        out.close();

    } catch (Exception e) {
        e.printStackTrace();
    }
    int key = 0;
    int MaxRowNum = 0, MaxCellNum = 0;
    try {
        FileInputStream in = new FileInputStream(filePath);
        POIFSFileSystem fs = new POIFSFileSystem(in);
        HSSFWorkbook workbook = new HSSFWorkbook(fs);
        FileOutputStream out = new FileOutputStream("/Users/Nemo/Documents/carpeople" + date + ".xls");
        int number = workbook.getNumberOfSheets();
        for (int i = 0; i < number; i++) { // ?sheet
            sheet = workbook.getSheetAt(i); // 14
            System.out.println("" + sheet.getSheetName() + " ? "
                    + (sheet.getLastRowNum() + 1));
            MaxRowNum = 0;
            for (int k = 0; k <= sheet.getLastRowNum(); k++) {
                HSSFRow hRow = sheet.getRow(k);
                // System.out.println((k + 1) + "");
                if (isBlankRow(hRow)) // 
                {
                    int m = 0;
                    for (m = k + 1; m <= sheet.getLastRowNum(); m++) {
                        HSSFRow nhRow = sheet.getRow(m);
                        if (!isBlankRow(nhRow)) {
                            // System.out.println("?" + (m + 1));
                            sheet.shiftRows(m, sheet.getLastRowNum(), k - m);
                            break;
                        }
                    }
                    if (m > sheet.getLastRowNum())
                        break; // ?
                } else { // ?
                    MaxRowNum++;
                    if (MaxCellNum < hRow.getLastCellNum())
                        MaxCellNum = hRow.getLastCellNum();
                }
            }
            workbook.setPrintArea(i, 0, MaxCellNum, 0, MaxRowNum);
            System.out
                    .println("?? " + sheet.getSheetName() + "  " + MaxRowNum);
        }
        workbook.write(out);
        in.close();
        out.close();
    } catch (IOException e) {
        System.out.println(key + " " + e.getMessage() + " ");
        e.printStackTrace();

    }

    System.out.println("??");

}

From source file:com.zhu.action.CarAction.java

public void export(ActionMapping mapping, ActionForm form, HttpServletRequest request,
        HttpServletResponse response) {//from  w  w w  . ja  va2s .com
    // webbookExcel
    HSSFWorkbook wb = new HSSFWorkbook();
    // webbooksheet,Excelsheet
    HSSFSheet sheet = wb.createSheet("?");
    // sheet0,??poiExcel?short
    HSSFRow row = sheet.createRow((int) 0);
    // ? 
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ?
    HSSFCell cell = row.createCell(0);
    cell.setCellValue("id");
    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("");
    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);
    // ? ??
    CarService carService = new CarService();
    List<Car> list = carService.getCar();

    for (int i = 0; i < list.size(); i++) {
        row = sheet.createRow((int) i + 1);
        Car car = (Car) list.get(i);
        // ?
        row.createCell(0).setCellValue(car.getId());
        row.createCell(1).setCellValue(car.getCarid());
        row.createCell(2).setCellValue(car.getLicense());
        row.createCell(3).setCellValue(car.getNumber());
        row.createCell(4).setCellValue(car.getPeople());
        row.createCell(5).setCellValue(car.getRoute());
        row.createCell(6).setCellValue(car.getStartdate());
        row.createCell(7).setCellValue(car.getEnddate());
        if (car.getStatus() == 0) {
            row.createCell(8).setCellValue("");
        } else if (car.getStatus() == 1) {
            row.createCell(8).setCellValue("");
        } else {
            row.createCell(8).setCellValue("");
        }
        // cell = row.createCell((short) 3);
    }
    // ?
    String filePath = "";
    Date dt = new Date();
    DateFormat df = new SimpleDateFormat("yyyyMMddHHmmss");
    String date = df.format(dt).toString();
    filePath = "/Users/Nemo/Documents/car" + date + ".xls";
    File file = new File(filePath);
    try {
        FileOutputStream fout = new FileOutputStream(file);
        wb.write(fout);
        fout.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

From source file:com.zrx.authority.util.ObjectExcelView.java

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    // TODO Auto-generated method stub
    Date date = new Date();
    String filename = Tools.date2Str(date, "yyyyMMddHHmmss");
    HSSFSheet sheet;//from w  w w  . j  av  a 2  s .c  o m
    HSSFCell cell;
    response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
    sheet = workbook.createSheet("sheet1");

    List<String> titles = (List<String>) model.get("titles");
    int len = titles.size();
    HSSFCellStyle headerStyle = workbook.createCellStyle(); //?
    headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
    HSSFFont headerFont = workbook.createFont(); //
    headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
    headerFont.setFontHeightInPoints((short) 11);
    headerStyle.setFont(headerFont);
    short width = 20, height = 25 * 20;
    sheet.setDefaultColumnWidth(width);
    for (int i = 0; i < len; i++) { //
        String title = titles.get(i);
        cell = getCell(sheet, 0, i);
        cell.setCellStyle(headerStyle);
        setText(cell, title);
    }
    sheet.getRow(0).setHeight(height);

    HSSFCellStyle contentStyle = workbook.createCellStyle(); //?
    contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    List<PageData> varList = (List<PageData>) model.get("varList");
    int varCount = varList.size();
    for (int i = 0; i < varCount; i++) {
        PageData vpd = varList.get(i);
        for (int j = 0; j < len; j++) {
            String varstr = vpd.getString("var" + (j + 1)) != null ? vpd.getString("var" + (j + 1)) : "";
            cell = getCell(sheet, i + 1, j);
            cell.setCellStyle(contentStyle);
            setText(cell, varstr);
        }

    }

}