Example usage for org.apache.poi.hssf.usermodel HSSFCell setCellValue

Introduction

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

Prototype

@SuppressWarnings("fallthrough")
public void setCellValue(boolean value) 

Source Link

Document

set a boolean value for the cell

Usage

From source file:com.smi.travel.migration.MainMigrate.java

public static void ExportARReport(List<MainMigrateModel> listAR) {
    UtilityExcelFunction excelFunction = new UtilityExcelFunction();
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFCellStyle styleC1 = wb.createCellStyle();
    // Set align Text
    HSSFCellStyle styleC21 = wb.createCellStyle();
    styleC21.setAlignment(styleC21.ALIGN_RIGHT);
    HSSFCellStyle styleC22 = wb.createCellStyle();
    styleC22.setAlignment(styleC22.ALIGN_LEFT);
    // Header Table
    HSSFCellStyle styleC3Center = wb.createCellStyle();
    styleC3Center.setFont(excelFunction.getHeaderTable(wb.createFont()));
    styleC3Center.setAlignment(styleC3Center.ALIGN_CENTER);
    styleC3Center.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
    styleC3Center.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);

    HSSFDataFormat currency = wb.createDataFormat();
    HSSFCellStyle styleC23 = wb.createCellStyle();
    styleC23.setAlignment(styleC23.ALIGN_CENTER);
    styleC23.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC23.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC24 = wb.createCellStyle();
    styleC24.setAlignment(styleC24.ALIGN_LEFT);
    HSSFCellStyle styleC25 = wb.createCellStyle();
    styleC25.setAlignment(styleC25.ALIGN_RIGHT);
    styleC25.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC25.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC25.setDataFormat(currency.getFormat("#,##0.00"));

    String datetemp = "";
    if (listAR != null) {
        //            HSSFSheet sheet = wb.createSheet(listAR.get(0).getInvdate().substring(3,10).replaceAll("-", ""));
        HSSFSheet sheet = wb.createSheet("ARReport");
        int count = 1;
        for (int i = 0; i < listAR.size(); i++) {
            MainMigrateModel data = (MainMigrateModel) listAR.get(i);
            if (!"".equalsIgnoreCase(datetemp)
                    && !datetemp.equalsIgnoreCase(data.getInvdate().substring(3, 10))) {
                sheet = wb.createSheet(data.getInvdate().substring(3, 10).replaceAll("-", ""));
                HSSFRow row2 = sheet.createRow(0);
                HSSFCell cell20 = row2.createCell(0);
                cell20.setCellValue("CODE");
                cell20.setCellStyle(styleC3Center);
                HSSFCell cell21 = row2.createCell(1);
                cell21.setCellValue("INV NAME");
                cell21.setCellStyle(styleC3Center);
                HSSFCell cell22 = row2.createCell(2);
                cell22.setCellValue("INV NO");
                cell22.setCellStyle(styleC3Center);
                HSSFCell cell23 = row2.createCell(3);
                cell23.setCellValue("INV DATE");
                cell23.setCellStyle(styleC3Center);
                HSSFCell cell24 = row2.createCell(4);
                cell24.setCellValue("TAX NO");
                cell24.setCellStyle(styleC3Center);
                HSSFCell cell25 = row2.createCell(5);
                cell25.setCellValue("BRANCH");
                cell25.setCellStyle(styleC3Center);
                HSSFCell cell26 = row2.createCell(6);
                cell26.setCellValue("BRANCH NO");
                cell26.setCellStyle(styleC3Center);

                count = 1;/*from  w w  w. ja v a 2 s .  co m*/
                sheet.setColumnWidth(0, 256 * 15);
                sheet.setColumnWidth(1, 256 * 25);
                sheet.setColumnWidth(2, 256 * 15);
                sheet.setColumnWidth(3, 256 * 15);
                sheet.setColumnWidth(4, 256 * 15);
                sheet.setColumnWidth(5, 256 * 15);
                sheet.setColumnWidth(6, 256 * 15);
            } else if ("".equalsIgnoreCase(datetemp)) {
                HSSFRow row2 = sheet.createRow(0);
                HSSFCell cell20 = row2.createCell(0);
                cell20.setCellValue("CODE");
                cell20.setCellStyle(styleC3Center);
                HSSFCell cell21 = row2.createCell(1);
                cell21.setCellValue("INV NAME");
                cell21.setCellStyle(styleC3Center);
                HSSFCell cell22 = row2.createCell(2);
                cell22.setCellValue("INV NO");
                cell22.setCellStyle(styleC3Center);
                HSSFCell cell23 = row2.createCell(3);
                cell23.setCellValue("INV DATE");
                cell23.setCellStyle(styleC3Center);
                HSSFCell cell24 = row2.createCell(4);
                cell24.setCellValue("TAX NO");
                cell24.setCellStyle(styleC3Center);
                HSSFCell cell25 = row2.createCell(5);
                cell25.setCellValue("BRANCH");
                cell25.setCellStyle(styleC3Center);
                HSSFCell cell26 = row2.createCell(6);
                cell26.setCellValue("BRANCH NO");
                cell26.setCellStyle(styleC3Center);

                sheet.setColumnWidth(0, 256 * 15);
                sheet.setColumnWidth(1, 256 * 25);
                sheet.setColumnWidth(2, 256 * 15);
                sheet.setColumnWidth(3, 256 * 15);
                sheet.setColumnWidth(4, 256 * 15);
                sheet.setColumnWidth(5, 256 * 15);
                sheet.setColumnWidth(6, 256 * 15);
            }

            HSSFRow row = sheet.createRow(count);
            HSSFCell cell0 = row.createCell(0);
            cell0.setCellValue(data.getCode());
            cell0.setCellStyle(styleC24);
            HSSFCell cell1 = row.createCell(1);
            cell1.setCellValue(data.getInvname());
            cell1.setCellStyle(styleC24);
            HSSFCell cell13 = row.createCell(2);
            cell13.setCellValue(data.getInvno());
            cell13.setCellStyle(styleC24);
            HSSFCell cell2 = row.createCell(3);
            cell2.setCellValue(String.valueOf(data.getInvdate()));
            cell2.setCellStyle(styleC24);
            HSSFCell cell3 = row.createCell(4);
            cell3.setCellValue(data.getTaxno());
            cell3.setCellStyle(styleC24);
            HSSFCell cell4 = row.createCell(5);
            cell4.setCellValue(data.getBranch());
            cell4.setCellStyle(styleC24);
            HSSFCell cell5 = row.createCell(6);
            cell5.setCellValue(data.getBranchno());
            cell5.setCellStyle(styleC24);

            //                    datetemp = data.getInvdate().substring(3,10);
            count++;
        }
    }
    exportFileExcel("ARReport", wb);
}

---

From source file:com.smi.travel.migration.MainMigrate.java

public static void ExportTaxinvoiceReport(List reptax) {
    UtilityExcelFunction excelFunction = new UtilityExcelFunction();
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("TaxInvoice");

    HSSFCellStyle styleC1 = wb.createCellStyle();
    // Set align Text
    HSSFCellStyle styleC21 = wb.createCellStyle();
    styleC21.setAlignment(styleC21.ALIGN_RIGHT);
    HSSFCellStyle styleC22 = wb.createCellStyle();
    styleC22.setAlignment(styleC22.ALIGN_LEFT);

    HSSFRow row1 = sheet.createRow(0);/*from   ww w  .  j av  a 2 s  .c  o  m*/
    HSSFCell cellStart = row1.createCell(0);
    cellStart.setCellValue("Tax Invoice Report");
    styleC1.setFont(excelFunction.getHeaderFont(wb.createFont()));
    cellStart.setCellStyle(styleC1);
    sheet.addMergedRegion(CellRangeAddress.valueOf("A1:F1"));

    // Header Table
    HSSFCellStyle styleC3Center = wb.createCellStyle();
    styleC3Center.setFont(excelFunction.getHeaderTable(wb.createFont()));
    styleC3Center.setAlignment(styleC3Center.ALIGN_CENTER);
    styleC3Center.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderTop(HSSFCellStyle.BORDER_THIN);

    HSSFRow row2 = sheet.createRow(2);
    HSSFCell cell20 = row2.createCell(0);
    cell20.setCellValue("ID");
    cell20.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(0);
    HSSFCell cell21 = row2.createCell(1);
    cell21.setCellValue("TAX ID");
    cell21.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(1);
    HSSFCell cell22 = row2.createCell(2);
    cell22.setCellValue("TAX NO");
    cell22.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(2);
    HSSFCell cell23 = row2.createCell(3);
    cell23.setCellValue("TAX DATE");
    cell23.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(3);
    HSSFCell cell24 = row2.createCell(4);
    cell24.setCellValue("CODE AP");
    cell24.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(4);
    HSSFCell cell25 = row2.createCell(5);
    cell25.setCellValue("DESCRIPTION");
    cell25.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(5);
    HSSFCell cell26 = row2.createCell(6);
    cell26.setCellValue("GROSS AMOUNT");
    cell26.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(6);
    HSSFCell cell27 = row2.createCell(7);
    cell27.setCellValue("VAT AMOUNT");
    cell27.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(7);
    HSSFCell cell28 = row2.createCell(8);
    cell28.setCellValue("AMOUNT");
    cell28.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(8);
    HSSFCell cell29 = row2.createCell(9);
    cell29.setCellValue("FLAG TYPE");
    cell29.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(9);
    HSSFCell cell30 = row2.createCell(10);
    cell30.setCellValue("INVOICE TYPE");
    cell30.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(10);
    HSSFCell cell31 = row2.createCell(11);
    cell31.setCellValue("TAX NO 1");
    cell31.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(11);
    HSSFCell cell32 = row2.createCell(12);
    cell32.setCellValue("BRANCH");
    cell32.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(12);
    HSSFCell cell33 = row2.createCell(13);
    cell33.setCellValue("BRANCH NO");
    cell33.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(13);

    int count = 3;

    HSSFDataFormat currency = wb.createDataFormat();
    HSSFCellStyle styleC23 = wb.createCellStyle();
    styleC23.setAlignment(styleC23.ALIGN_CENTER);
    styleC23.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC23.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC24 = wb.createCellStyle();
    styleC24.setAlignment(styleC24.ALIGN_LEFT);
    styleC24.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC24.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC25 = wb.createCellStyle();
    styleC25.setAlignment(styleC25.ALIGN_RIGHT);
    styleC25.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC25.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC25.setDataFormat(currency.getFormat("#,##0.00"));

    for (int i = 0; i < reptax.size(); i++) {
        ReportTaxInvoice data = (ReportTaxInvoice) reptax.get(i);
        HSSFRow row = sheet.createRow(count + i);
        HSSFCell cell0 = row.createCell(0);
        cell0.setCellValue(data.getId());
        cell0.setCellStyle(styleC23);
        HSSFCell cell1 = row.createCell(1);
        cell1.setCellValue(data.getTaxid());
        cell1.setCellStyle(styleC23);
        HSSFCell cell13 = row.createCell(2);
        cell13.setCellValue(data.getTaxno());
        cell13.setCellStyle(styleC23);
        HSSFCell cell2 = row.createCell(3);
        cell2.setCellValue(String.valueOf(data.getTaxdate()));
        cell2.setCellStyle(styleC23);
        HSSFCell cell3 = row.createCell(4);
        cell3.setCellValue(data.getCodeap());
        cell3.setCellStyle(styleC24);
        HSSFCell cell4 = row.createCell(5);
        cell4.setCellValue(data.getDescription().trim());
        cell4.setCellStyle(styleC24);
        HSSFCell cell5 = row.createCell(6);
        cell5.setCellValue(!"null".equalsIgnoreCase(String.valueOf(data.getGrossamount()))
                ? (data.getGrossamount()).doubleValue()
                : 0);
        cell5.setCellStyle(styleC25);
        HSSFCell cell6 = row.createCell(7);
        cell6.setCellValue(!"null".equalsIgnoreCase(String.valueOf(data.getVatamount()))
                ? (data.getVatamount()).doubleValue()
                : 0);
        cell6.setCellStyle(styleC25);
        HSSFCell cell7 = row.createCell(8);
        cell7.setCellValue(
                !"null".equalsIgnoreCase(String.valueOf(data.getAmount())) ? (data.getAmount()).doubleValue()
                        : 0);
        cell7.setCellStyle(styleC25);
        HSSFCell cell8 = row.createCell(9);
        cell8.setCellValue(data.getFlagtype());
        cell8.setCellStyle(styleC23);
        HSSFCell cell9 = row.createCell(10);
        cell9.setCellValue(data.getInvoicetype());
        cell9.setCellStyle(styleC24);
        HSSFCell cell10 = row.createCell(11);
        cell10.setCellValue(data.getTaxno1());
        cell10.setCellStyle(styleC24);
        HSSFCell cell11 = row.createCell(12);
        cell11.setCellValue(data.getBranch());
        cell11.setCellStyle(styleC24);
        HSSFCell cell12 = row.createCell(13);
        cell12.setCellValue(data.getBranchno());
        cell12.setCellStyle(styleC23);

    }
    for (int j = 0; j < 15; j++) {
        sheet.autoSizeColumn(j);
    }
    sheet.setColumnWidth(5, 256 * 40);//27
    exportFileExcel("TaxInvoiceReport", wb);
}

---

From source file:com.smi.travel.migration.MainMigrate.java

public static void ExportAgentReport(List repAgent) {
    UtilityExcelFunction excelFunction = new UtilityExcelFunction();
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Agent");

    HSSFCellStyle styleC1 = wb.createCellStyle();
    // Set align Text
    HSSFCellStyle styleC21 = wb.createCellStyle();
    styleC21.setAlignment(styleC21.ALIGN_RIGHT);
    HSSFCellStyle styleC22 = wb.createCellStyle();
    styleC22.setAlignment(styleC22.ALIGN_LEFT);

    HSSFRow row1 = sheet.createRow(0);/* w ww. j  a va  2 s  . com*/
    HSSFCell cellStart = row1.createCell(0);
    cellStart.setCellValue("Agent Report");
    styleC1.setFont(excelFunction.getHeaderFont(wb.createFont()));
    cellStart.setCellStyle(styleC1);
    sheet.addMergedRegion(CellRangeAddress.valueOf("A1:F1"));

    // Header Table
    HSSFCellStyle styleC3Center = wb.createCellStyle();
    styleC3Center.setFont(excelFunction.getHeaderTable(wb.createFont()));
    styleC3Center.setAlignment(styleC3Center.ALIGN_CENTER);
    styleC3Center.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderTop(HSSFCellStyle.BORDER_THIN);

    HSSFRow row2 = sheet.createRow(2);
    HSSFCell cell20 = row2.createCell(0);
    cell20.setCellValue("ID");
    cell20.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(0);
    HSSFCell cell21 = row2.createCell(1);
    cell21.setCellValue("SYSTEM DATE");
    cell21.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(1);
    HSSFCell cell22 = row2.createCell(2);
    cell22.setCellValue("SYSTEM STAFF");
    cell22.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(2);
    HSSFCell cell23 = row2.createCell(3);
    cell23.setCellValue("CODE");
    cell23.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(3);
    HSSFCell cell24 = row2.createCell(4);
    cell24.setCellValue("NAME");
    cell24.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(4);
    HSSFCell cell25 = row2.createCell(5);
    cell25.setCellValue("ADDRESS");
    cell25.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(5);
    HSSFCell cell26 = row2.createCell(6);
    cell26.setCellValue("TEL");
    cell26.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(6);
    HSSFCell cell27 = row2.createCell(7);
    cell27.setCellValue("FAX");
    cell27.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(7);
    HSSFCell cell28 = row2.createCell(8);
    cell28.setCellValue("DESCRIPTION");
    cell28.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(8);
    HSSFCell cell29 = row2.createCell(9);
    cell29.setCellValue("NAME T");
    cell29.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(9);
    HSSFCell cell30 = row2.createCell(10);
    cell30.setCellValue("DESCRIPTION T");
    cell30.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(10);
    HSSFCell cell31 = row2.createCell(11);
    cell31.setCellValue("ADDRESS T");
    cell31.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(11);
    HSSFCell cell32 = row2.createCell(12);
    cell32.setCellValue("EMAIL");
    cell32.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(12);
    HSSFCell cell33 = row2.createCell(13);
    cell33.setCellValue("WEB");
    cell33.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(13);
    HSSFCell cell34 = row2.createCell(14);
    cell34.setCellValue("REMARKS");
    cell34.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(14);
    HSSFCell cell35 = row2.createCell(15);
    cell35.setCellValue("WARNING");
    cell35.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(15);
    HSSFCell cell36 = row2.createCell(16);
    cell36.setCellValue("REF ID");
    cell36.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(16);
    HSSFCell cell37 = row2.createCell(17);
    cell37.setCellValue("BRANCH");
    cell37.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(17);
    HSSFCell cell38 = row2.createCell(18);
    cell38.setCellValue("BRANCH NO");
    cell38.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(18);
    HSSFCell cell39 = row2.createCell(19);
    cell39.setCellValue("TAX NO");
    cell39.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(19);

    int count = 3;

    HSSFDataFormat currency = wb.createDataFormat();
    HSSFCellStyle styleC23 = wb.createCellStyle();
    styleC23.setAlignment(styleC23.ALIGN_CENTER);
    styleC23.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC23.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC24 = wb.createCellStyle();
    styleC24.setAlignment(styleC24.ALIGN_LEFT);
    styleC24.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC24.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC25 = wb.createCellStyle();
    styleC25.setAlignment(styleC25.ALIGN_RIGHT);
    styleC25.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC25.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC25.setDataFormat(currency.getFormat("#,##0.00"));

    for (int i = 0; i < repAgent.size(); i++) {
        ReportAgent data = (ReportAgent) repAgent.get(i);
        HSSFRow row = sheet.createRow(count + i);
        HSSFCell cell0 = row.createCell(0);
        cell0.setCellValue(data.getId());
        cell0.setCellStyle(styleC23);
        HSSFCell cell1 = row.createCell(1);
        cell1.setCellValue(String.valueOf(data.getSystemdate()));
        cell1.setCellStyle(styleC23);
        HSSFCell cell13 = row.createCell(2);
        cell13.setCellValue(data.getSystemstaff());
        cell13.setCellStyle(styleC24);
        HSSFCell cell2 = row.createCell(3);
        cell2.setCellValue(data.getCode());
        cell2.setCellStyle(styleC24);
        HSSFCell cell3 = row.createCell(4);
        cell3.setCellValue(data.getName());
        cell3.setCellStyle(styleC24);
        HSSFCell cell4 = row.createCell(5);
        cell4.setCellValue(data.getAddress().trim());
        cell4.setCellStyle(styleC24);
        HSSFCell cell5 = row.createCell(6);
        cell5.setCellValue(data.getTel());
        cell5.setCellStyle(styleC24);
        HSSFCell cell6 = row.createCell(7);
        cell6.setCellValue(data.getFax());
        cell6.setCellStyle(styleC24);
        HSSFCell cell7 = row.createCell(8);
        cell7.setCellValue(data.getDescription().trim());
        cell7.setCellStyle(styleC24);
        HSSFCell cell8 = row.createCell(9);
        cell8.setCellValue(data.getNameT());
        cell8.setCellStyle(styleC24);
        HSSFCell cell9 = row.createCell(10);
        cell9.setCellValue(data.getDescriptionT().trim());
        cell9.setCellStyle(styleC24);
        HSSFCell cell10 = row.createCell(11);
        cell10.setCellValue(data.getAddressT().trim());
        cell10.setCellStyle(styleC24);
        HSSFCell cell11 = row.createCell(12);
        cell11.setCellValue(data.getEmail());
        cell11.setCellStyle(styleC24);
        HSSFCell cell12 = row.createCell(13);
        cell12.setCellValue(data.getWeb());
        cell12.setCellStyle(styleC24);
        HSSFCell cell14 = row.createCell(14);
        cell14.setCellValue(data.getRemarks());
        cell14.setCellStyle(styleC24);
        HSSFCell cell15 = row.createCell(15);
        cell15.setCellValue(data.getWarning());
        cell15.setCellStyle(styleC24);
        HSSFCell cell16 = row.createCell(16);
        cell16.setCellValue(data.getRefid());
        cell16.setCellStyle(styleC24);
        HSSFCell cell17 = row.createCell(17);
        cell17.setCellValue(data.getBranch());
        cell17.setCellStyle(styleC24);
        HSSFCell cell18 = row.createCell(18);
        cell18.setCellValue(data.getBranchno());
        cell18.setCellStyle(styleC24);
        HSSFCell cell19 = row.createCell(19);
        cell19.setCellValue(data.getTaxno());
        cell19.setCellStyle(styleC23);
    }

    for (int j = 0; j < 20; j++) {
        sheet.autoSizeColumn(j);
    }

    for (int k = 4; k < 21; k++) {
        if (k != 6 && k != 7 && k != 12 && k != 13 && k < 16) {
            sheet.setColumnWidth(k, 256 * 35);//27
        } else {
            sheet.setColumnWidth(k, 256 * 20);//27
        }
    }
    exportFileExcel("AgentReport", wb);
}

---

From source file:com.smi.travel.migration.MainMigrate.java

public static void ExportStaffReport(List repStaff) {
    UtilityExcelFunction excelFunction = new UtilityExcelFunction();
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Staff");

    HSSFCellStyle styleC1 = wb.createCellStyle();
    // Set align Text
    HSSFCellStyle styleC21 = wb.createCellStyle();
    styleC21.setAlignment(styleC21.ALIGN_RIGHT);
    HSSFCellStyle styleC22 = wb.createCellStyle();
    styleC22.setAlignment(styleC22.ALIGN_LEFT);

    HSSFRow row1 = sheet.createRow(0);/* www  . j av a  2  s  .  co m*/
    HSSFCell cellStart = row1.createCell(0);
    cellStart.setCellValue("Staff Report");
    styleC1.setFont(excelFunction.getHeaderFont(wb.createFont()));
    cellStart.setCellStyle(styleC1);
    sheet.addMergedRegion(CellRangeAddress.valueOf("A1:F1"));

    // Header Table
    HSSFCellStyle styleC3Center = wb.createCellStyle();
    styleC3Center.setFont(excelFunction.getHeaderTable(wb.createFont()));
    styleC3Center.setAlignment(styleC3Center.ALIGN_CENTER);
    styleC3Center.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC3Center.setBorderTop(HSSFCellStyle.BORDER_THIN);

    HSSFRow row2 = sheet.createRow(2);
    HSSFCell cell20 = row2.createCell(0);
    cell20.setCellValue("ID");
    cell20.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(0);
    HSSFCell cell21 = row2.createCell(1);
    cell21.setCellValue("SYSTEM DATE");
    cell21.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(1);
    HSSFCell cell22 = row2.createCell(2);
    cell22.setCellValue("SYSTEM STAFF");
    cell22.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(2);
    HSSFCell cell23 = row2.createCell(3);
    cell23.setCellValue("CODE");
    cell23.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(3);
    HSSFCell cell24 = row2.createCell(4);
    cell24.setCellValue("NAME");
    cell24.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(4);
    HSSFCell cell25 = row2.createCell(5);
    cell25.setCellValue("PASSWD");
    cell25.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(5);
    HSSFCell cell26 = row2.createCell(6);
    cell26.setCellValue("POSITION");
    cell26.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(6);
    HSSFCell cell27 = row2.createCell(7);
    cell27.setCellValue("DEPARTMENT ID");
    cell27.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(7);
    HSSFCell cell28 = row2.createCell(8);
    cell28.setCellValue("TEL");
    cell28.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(8);
    HSSFCell cell29 = row2.createCell(9);
    cell29.setCellValue("CAR");
    cell29.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(9);
    HSSFCell cell30 = row2.createCell(10);
    cell30.setCellValue("STATUS");
    cell30.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(10);
    HSSFCell cell31 = row2.createCell(11);
    cell31.setCellValue("SIGNATURE");
    cell31.setCellStyle(styleC3Center);
    sheet.autoSizeColumn(11);
    int count = 3;

    HSSFDataFormat currency = wb.createDataFormat();
    HSSFCellStyle styleC23 = wb.createCellStyle();
    styleC23.setAlignment(styleC23.ALIGN_CENTER);
    styleC23.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC23.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC24 = wb.createCellStyle();
    styleC24.setAlignment(styleC24.ALIGN_LEFT);
    styleC24.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC24.setBorderRight(HSSFCellStyle.BORDER_THIN);
    HSSFCellStyle styleC25 = wb.createCellStyle();
    styleC25.setAlignment(styleC25.ALIGN_RIGHT);
    styleC25.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    styleC25.setBorderRight(HSSFCellStyle.BORDER_THIN);
    styleC25.setDataFormat(currency.getFormat("#,##0.00"));

    for (int i = 0; i < repStaff.size(); i++) {
        ReportStaff data = (ReportStaff) repStaff.get(i);
        HSSFRow row = sheet.createRow(count + i);
        HSSFCell cell0 = row.createCell(0);
        cell0.setCellValue(data.getId());
        cell0.setCellStyle(styleC23);
        HSSFCell cell1 = row.createCell(1);
        cell1.setCellValue(String.valueOf(data.getSystemdate()));
        cell1.setCellStyle(styleC23);
        HSSFCell cell13 = row.createCell(2);
        cell13.setCellValue(data.getSystemstaff());
        cell13.setCellStyle(styleC24);
        HSSFCell cell2 = row.createCell(3);
        cell2.setCellValue(data.getCode());
        cell2.setCellStyle(styleC24);
        HSSFCell cell3 = row.createCell(4);
        cell3.setCellValue(data.getName());
        cell3.setCellStyle(styleC24);
        HSSFCell cell4 = row.createCell(5);
        cell4.setCellValue(data.getPasswd());
        cell4.setCellStyle(styleC24);
        HSSFCell cell5 = row.createCell(6);
        cell5.setCellValue(data.getPosition());
        cell5.setCellStyle(styleC24);
        HSSFCell cell6 = row.createCell(7);
        cell6.setCellValue(data.getDepartmentid());
        cell6.setCellStyle(styleC24);
        HSSFCell cell7 = row.createCell(8);
        cell7.setCellValue(data.getTel());
        cell7.setCellStyle(styleC24);
        HSSFCell cell8 = row.createCell(9);
        cell8.setCellValue(data.getCar());
        cell8.setCellStyle(styleC24);
        HSSFCell cell9 = row.createCell(10);
        cell9.setCellValue(data.getStatus());
        cell9.setCellStyle(styleC24);
        HSSFCell cell10 = row.createCell(11);
        cell10.setCellValue(data.getSignature());
        cell10.setCellStyle(styleC24);
    }
    for (int j = 0; j < 12; j++) {
        sheet.autoSizeColumn(j);
    }
    //        sheet.setColumnWidth(8, 256*40);//27
    //        sheet.setColumnWidth(10, 256*40);//27
    exportFileExcel("StaffReport", wb);
}

---

From source file:com.softtek.mdm.web.admin.IndexController.java

private void exportExcel(String sheetName, String[] headNames, List<OrganizationModel> lists,
        HttpServletResponse response) {//w  ww  .j  a  va 2s.  co m

    OutputStream out = null;
    try {
        HSSFWorkbook workbook = new HSSFWorkbook(); //   
        HSSFSheet sheet = workbook.createSheet(sheetName); //   
        //   
        HSSFRow rowm = sheet.createRow(0);
        HSSFCell cellTiltle = rowm.createCell(0);
        //sheet??getColumnTopStyle()/getStyle()? - ?  - ?  
        HSSFCellStyle columnTopStyle = CommUtil.getColumnTopStyle(workbook);//??  
        sheet.addMergedRegion(new CellRangeAddress(0, 1, 0, (headNames.length - 1)));
        cellTiltle.setCellStyle(columnTopStyle);
        cellTiltle.setCellValue(sheetName);
        //   
        int columnNum = headNames.length;
        HSSFRow rowRowName = sheet.createRow(2); // 2?()  
        // sheet?  
        for (int n = 0; n < columnNum; n++) {
            HSSFCell cellRowName = rowRowName.createCell(n); //?  
            cellRowName.setCellType(HSSFCell.CELL_TYPE_STRING); //??  
            HSSFRichTextString text = new HSSFRichTextString(headNames[n]);
            cellRowName.setCellValue(text); //?  
            cellRowName.setCellStyle(columnTopStyle); //??  
        }
        //?sheet?  
        HSSFDataFormat format = workbook.createDataFormat();
        short formatDate = format.getFormat("yyyy-MM-dd hh:mm:ss");
        for (int i = 0; i < lists.size(); i++) {
            HSSFRow row = sheet.createRow(i + 3);//  
            OrganizationModel obj = lists.get(i);//???  
            /*row.createCell(0).setCellValue(obj.getOrgType());*/
            row.createCell(0).setCellValue(obj.getName());
            row.createCell(1).setCellValue(obj.getCreateName());
            row.createCell(2).setCellValue(obj.getTotalUsers() == null ? 0 : obj.getTotalUsers());
            row.createCell(3).setCellValue(obj.getTotalDevices() == null ? 0 : obj.getTotalDevices());
            row.createCell(4).setCellValue(obj.getLicenseCount() == null ? 0 : obj.getLicenseCount());
            row.createCell(5).setCellValue(obj.getUseUsers() == null ? 0 : obj.getUseUsers());
            HSSFCell cell = row.createCell(6);
            cell.setCellValue(obj.getCreateTime());
            HSSFCellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setDataFormat(formatDate);
            cell.setCellStyle(cellStyle);
        }
        //??  
        for (int colNum = 0; colNum < columnNum; colNum++) {
            int columnWidth = sheet.getColumnWidth(colNum) / 256;
            for (int rowNum = 0; rowNum < sheet.getLastRowNum(); rowNum++) {
                HSSFRow currentRow;
                //?  
                currentRow = (sheet.getRow(rowNum) == null) ? sheet.createRow(rowNum) : sheet.getRow(rowNum);
                if (currentRow.getCell(colNum) != null) {
                    HSSFCell currentCell = currentRow.getCell(colNum);
                    if (currentCell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
                        int length = currentCell.getStringCellValue().getBytes().length;
                        if (columnWidth < length) {
                            columnWidth = length;
                        }
                    }
                }
            }
            sheet.setColumnWidth(colNum, (colNum == 0) ? (columnWidth * 256) : ((columnWidth + 10) * 256));
        }
        if (workbook != null) {
            try {
                String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13)
                        + ".xls";
                String headStr = "attachment; filename=\"" + fileName + "\"";
                response.setContentType("application/octet-stream");
                response.setHeader("Content-Disposition", headStr);
                out = response.getOutputStream();
                workbook.write(out);
            } catch (IOException e) {
                logger.error(e.getMessage());
            } finally {
                if (out != null) {
                    out.close();
                }
            }
        }
    } catch (Exception e) {
        logger.error(e.getMessage());
    }
}

---

From source file:com.square.core.util.poi.DocumentXls.java

License:Open Source License

/**
 * Ajoute une ligne au document.// w ww .j  av a 2 s. co m
 * @param donnees les donnes de la ligne
 * @param style le style  mettre sur les cellules de la ligne
 */
public void ajouterLigne(String[] donnees, HSSFCellStyle style) {
    // Rcupration de la page
    final HSSFSheet page = recupererPage();
    // Rcupration d'une ligne
    final HSSFRow ligne = recupererLigne(page);

    int col = 0;
    for (String donnee : donnees) {
        // Dclaration d'une cellule
        final HSSFCell cellule = ligne.createCell(col++);
        final HSSFRichTextString rtsValue = new HSSFRichTextString(donnee);
        cellule.setCellValue(rtsValue);
        if (style != null) {
            cellule.setCellStyle(style);
        }
    }
}

---

From source file:com.ssic.education.provider.controller.ProSupplierController.java

@RequestMapping(value = "/excel")
@ResponseBody//from w  w w. ja  va  2  s.co m
public ModelAndView exportExcel(SupplierDto supplierDto, HttpServletRequest request,
        HttpServletResponse response) {
    SessionInfo info = (SessionInfo) request.getSession().getAttribute(ConfigUtil.SESSIONINFONAME);
    if (info == null) {
        return null;
    }
    supplierDto.setReceiverId(info.getSupplierId());
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy.M.d");
    Date date = new Date();
    String filename = Tools.date2Str(date, "yyyyMMddHHmmss");
    HSSFSheet sheet;
    HSSFCell cell;
    response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
    Workbook workbook = new HSSFWorkbook();
    sheet = (HSSFSheet) workbook.createSheet("");
    try {
        List<String> titles = new ArrayList<String>();
        titles.add("????");
        titles.add("???");
        //         titles.add("????");
        //         titles.add("??????");
        titles.add("????");
        titles.add("???");
        //         titles.add("?");
        //         titles.add("???");
        titles.add("?");
        titles.add("?");
        int len = titles.size();
        HSSFCellStyle headerStyle = (HSSFCellStyle) workbook.createCellStyle(); // ?
        headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        HSSFFont headerFont = (HSSFFont) workbook.createFont(); // 
        headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        headerFont.setFontHeightInPoints((short) 11);
        headerStyle.setFont(headerFont);
        short width = 20, height = 25 * 20;
        sheet.setDefaultColumnWidth(width);
        HSSFRow sheetRow = sheet.createRow(0);
        for (int i = 0; i < len; i++) { // 
            String title = titles.get(i);
            cell = sheetRow.createCell(i);
            cell.setCellStyle(headerStyle);
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
            cell.setCellValue(title);
        }
        sheet.getRow(0).setHeight(height);
        HSSFCellStyle contentStyle = (HSSFCellStyle) workbook.createCellStyle(); // ?
        contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        DataGrid dg = supplierService.findProSupplier(supplierDto, null);
        List<SupplierDto> expList = dg.getRows();
        List<PageData> varList = new ArrayList<PageData>();
        if (!CollectionUtils.isEmpty(expList)) {
            for (int i = 0; i < expList.size(); i++) {
                PageData vpd = new PageData();
                vpd.put("var1", expList.get(i).getSupplierName());
                vpd.put("var2", expList.get(i).getAddress());
                //               vpd.put("var3", expList.get(i).getFoodServiceCode());
                //               vpd.put("var4", expList.get(i).getFoodBusinessCode());
                vpd.put("var3", expList.get(i).getFoodCirculationCode());
                vpd.put("var4", expList.get(i).getFoodProduceCode());
                //               vpd.put("var7", expList.get(i).getBusinessLicense());
                //               vpd.put("var8", expList.get(i).getSupplierCode());
                vpd.put("var5", expList.get(i).getCorporation());
                vpd.put("var6", expList.get(i).getContactWay());
                varList.add(vpd);
            }
        }
        for (int i = 0; i < varList.size(); i++) {
            HSSFRow row = sheet.createRow(i + 1);
            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 = row.createCell(j);
                HSSFCellStyle cellStyle2 = (HSSFCellStyle) workbook.createCellStyle();
                HSSFDataFormat format = (HSSFDataFormat) workbook.createDataFormat();
                cellStyle2.setDataFormat(format.getFormat("@"));
                cell.setCellStyle(cellStyle2);
                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                cell.setCellValue(varstr);

            }

        }
        OutputStream os = response.getOutputStream();
        workbook.write(os);
        os.flush();
        os.close();
    } catch (Exception e) {

    }
    return null;
}

---

From source file:com.ssic.education.provider.controller.WaresController.java

@RequestMapping(value = "/excel")
@ResponseBody//from   ww w. java 2  s.  c  o m
public ModelAndView exportExcel(ProWaresDto proWaresDto, HttpServletRequest request,
        HttpServletResponse response) {
    SessionInfo info = (SessionInfo) request.getSession().getAttribute(ConfigUtil.SESSIONINFONAME);
    if (info == null) {
        return null;
    }
    proWaresDto.setSupplierId(info.getSupplierId());
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy.M.d");
    Date date = new Date();
    String filename = Tools.date2Str(date, "yyyyMMddHHmmss");
    HSSFSheet sheet;
    HSSFCell cell;
    response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
    Workbook workbook = new HSSFWorkbook();
    sheet = (HSSFSheet) workbook.createSheet("");
    try {
        List<String> titles = new ArrayList<String>();
        titles.add("??");
        titles.add("???");
        titles.add("");
        titles.add("?");
        titles.add("?");
        //         titles.add("??");
        //         titles.add("???");
        //         titles.add("??");
        titles.add("?");
        titles.add("???");
        titles.add("");
        int len = titles.size();
        HSSFCellStyle headerStyle = (HSSFCellStyle) workbook.createCellStyle(); // ?
        headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        HSSFFont headerFont = (HSSFFont) workbook.createFont(); // 
        headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        headerFont.setFontHeightInPoints((short) 11);
        headerStyle.setFont(headerFont);
        short width = 20, height = 25 * 20;
        sheet.setDefaultColumnWidth(width);
        HSSFRow sheetRow = sheet.createRow(0);
        for (int i = 0; i < len; i++) { // 
            String title = titles.get(i);
            cell = sheetRow.createCell(i);
            cell.setCellStyle(headerStyle);
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
            cell.setCellValue(title);
        }
        sheet.getRow(0).setHeight(height);
        HSSFCellStyle contentStyle = (HSSFCellStyle) workbook.createCellStyle(); // ?
        contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        List<ProWaresDto> expList = waresService.findAllWares(proWaresDto, null);
        List<PageData> varList = new ArrayList<PageData>();
        if (!CollectionUtils.isEmpty(expList)) {
            for (int i = 0; i < expList.size(); i++) {
                PageData vpd = new PageData();
                vpd.put("var1", expList.get(i).getWaresName());
                vpd.put("var2", expList.get(i).getAmountUnit());
                vpd.put("var3", expList.get(i).getSpec());
                vpd.put("var4", ProductClass.getName(expList.get(i).getWaresType()));
                vpd.put("var5", expList.get(i).getManufacturer());
                //               vpd.put("var5", expList.get(i).getEnName());
                //               vpd.put("var6", expList.get(i).getBarCode());
                //               vpd.put("var7", expList.get(i).getCustomCode());
                vpd.put("var6", expList.get(i).getShelfLife());
                vpd.put("var7", expList.get(i).getUnit());
                vpd.put("var8", expList.get(i).getPlace());
                varList.add(vpd);
            }
        }
        for (int i = 0; i < varList.size(); i++) {
            HSSFRow row = sheet.createRow(i + 1);
            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 = row.createCell(j);
                HSSFCellStyle cellStyle2 = (HSSFCellStyle) workbook.createCellStyle();
                HSSFDataFormat format = (HSSFDataFormat) workbook.createDataFormat();
                cellStyle2.setDataFormat(format.getFormat("@"));
                cell.setCellStyle(cellStyle2);
                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                cell.setCellValue(varstr);

            }

        }
        OutputStream os = response.getOutputStream();
        workbook.write(os);
        os.flush();
        os.close();
    } catch (Exception e) {

    }
    return null;
}

---

From source file:com.sx.finance.OldYahooFinanceJFrame.java

public void writeExcelFile(ArrayList<List<Object>> listDataRaw) {
    // webbookExcel
    HSSFWorkbook wb = new HSSFWorkbook();
    // webbooksheet,Excelsheet
    HSSFSheet sheet = wb.createSheet("Data");
    // sheet0,poiExcelshort
    HSSFRow row = sheet.createRow((int) 0);
    //  /*from  ww w.  java  2  s.co  m*/
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 

    for (int i = 0; i < title.length; i++) {
        HSSFCell cell = row.createCell(i);
        cell.setCellValue(title[i]);
        cell.setCellStyle(style);
    }

    for (int i = 0; i < listDataRaw.size(); i++) {
        row = sheet.createRow(i + 1);
        for (int j = 0; j < listDataRaw.get(i).size(); j++) {
            Object cellData = listDataRaw.get(i).get(j);
            if (cellData instanceof Long) {
                row.createCell(j).setCellValue(((Long) cellData).longValue());
            } else if (cellData instanceof Double) {
                row.createCell(j).setCellValue(((Double) cellData).doubleValue());
            } else if (cellData instanceof Date) {
                row.createCell(j).setCellValue((Date) cellData);
            } else if (cellData instanceof Integer) {
                row.createCell(j).setCellValue(((Integer) cellData).intValue());
            } else {
                row.createCell(j).setCellValue((String) cellData);
            }
        }
    }
    try {
        FileOutputStream fout = new FileOutputStream("D:/work/myprojects/yahooFinance/output/data.xls");
        wb.write(fout);
        fout.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

---

From source file:com.synct.report.cm40101.java

public void printPageBody() throws IOException {
    try {//from www.jav  a  2s  . c o  m
        //HSSFRow row = sheet.getRow(rowno);
        //HSSFCell cell1 =null;
        System.out.println("Start to write excel");
        //System.out.println(data.get(0));
        System.out.println(data.get(1));
        System.out.println(data.get(2));
        System.out.println(data.get(3));

        CellReference cellReference = new CellReference("G3");
        HSSFRow row = sheet.getRow(cellReference.getRow());
        HSSFCell cell = row.getCell(cellReference.getCol()); //  
        setBig5CellValue(data.get(1), cell);
        //cell.setCellValue( data.get(1) );

        cellReference = new CellReference("G63");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(1), cell);

        cellReference = new CellReference("G123");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(1), cell);

        cellReference = new CellReference("G183");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(1), cell);

        cellReference = new CellReference("V3");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("V63");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("V123");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("V183");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM3");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM63");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM123");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM183");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F4");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F64");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F124");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F184");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM4");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM64");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM124");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AM184");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("U6");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("U66");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("U126");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("U186");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        //cell.setCellValue( "\u7f85\u5ef7\u4e2d\u5e25\u54e5" );
        cellReference = new CellReference("U8");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(5));

        cellReference = new CellReference("U68");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(5));

        cellReference = new CellReference("U128");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(5));

        cellReference = new CellReference("U188");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(5));

        cellReference = new CellReference("U10");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(3));

        cellReference = new CellReference("U70");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(3));

        cellReference = new CellReference("U130");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(3));

        cellReference = new CellReference("U190");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(3));

        cellReference = new CellReference("U12");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U72");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U132");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U192");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U14");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U74");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U134");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U194");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U14");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U74");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U134");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U194");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(4));

        cellReference = new CellReference("U16");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(6));

        cellReference = new CellReference("U76");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(6));

        cellReference = new CellReference("U136");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(6));

        cellReference = new CellReference("U196");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(6));

        cellReference = new CellReference("U18");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U78");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U138");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U198");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U20");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U80");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U140");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U200");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U22");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U82");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U142");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U202");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U22");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U82");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U142");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U202");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U26");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U86");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U146");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U206");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U30");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U90");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U150");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("U210");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        cell.setCellValue(data.get(8));

        cellReference = new CellReference("AU6");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU66");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU126");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU186");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU7");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU67");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU127");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU187");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AJ8");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AJ68");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AJ128");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AJ188");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU8");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU68");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU128");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU188");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU9");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU69");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU129");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU189");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU10");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU70");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU130");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU190");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG14");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG74");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG134");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG194");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG16");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG76");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG136");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG196");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG18");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG78");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG138");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG198");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG20");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG80");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG140");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AG200");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL22");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL82");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL142");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL202");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL25");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL85");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL145");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL205");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL28");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL88");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL148");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL208");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL31");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL91");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL151");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AL211");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B34");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B94");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B154");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B214");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("M34");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("M94");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("M154");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("M214");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AD34");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AD94");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AD154");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AD214");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H35");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H95");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H155");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H215");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B36");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B96");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B156");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B216");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("G36");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("G96");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("G156");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("G216");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B37");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B97");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B157");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B217");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN37");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN97");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN157");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN217");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS37");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS97");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS157");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS217");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR40");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR100");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR160");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR220");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU41");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU101");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU161");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU221");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B43");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B103");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B163");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B223");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B44");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B104");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B164");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B224");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F44");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F104");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F164");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F224");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H45");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H105");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H165");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("H225");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("Y45");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("Y105");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("Y165");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("Y225");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F46");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F106");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F166");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("F226");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B47");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B107");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B167");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("B227");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN47");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN107");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN167");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AN227");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS47");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS107");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS167");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AS227");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR48");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR108");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR168");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AR228");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU49");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU109");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU169");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        cellReference = new CellReference("AU229");
        row = sheet.getRow(cellReference.getRow());
        cell = row.getCell(cellReference.getCol());
        setBig5CellValue(data.get(2), cell);

        //cell1 = row.getCell((short)(0));

        //setBig5CellValue(data1[0],cell1);
        //cell1 = row.getCell((short)(1));
        //setBig5CellValue(data1[1],cell1);

        //cell1 = row.getCell((short)(31));                                    
        //setBig5CellValue(data1[2],cell1);

    } catch (Exception e) {
        System.err.println("cm40101:printPageBody error is " + e);
    }

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »