Example usage for org.apache.poi.ss.usermodel Cell setCellValue

List of usage examples for org.apache.poi.ss.usermodel Cell setCellValue

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Cell
  6. setCellValue

Introduction

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

Prototype

void setCellValue(boolean value);

Source Link

Document

Set a boolean value for the cell

Usage

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.ReviewerVendorPoXlsReportHelper.java

License:Apache License

private void writeProjectDataForTradosMatches(Workbook p_workbook, HashMap p_projectMap, IntHolder p_row)
        throws Exception {
    Sheet theSheet = data.tradosSheet;/*from w w w .  ja  v a 2 s. c  o  m*/
    ArrayList projects = new ArrayList(p_projectMap.keySet());
    SortUtil.sort(projects);
    Iterator projectIter = projects.iterator();

    while (projectIter.hasNext()) {
        String jobName = (String) projectIter.next();
        boolean isWrongJob = data.wrongJobNames.contains(jobName);
        HashMap localeMap = (HashMap) p_projectMap.get(jobName);
        ArrayList locales = new ArrayList(localeMap.keySet());
        SortUtil.sort(locales);
        HashMap<String, String> jobLocale = new HashMap<String, String>();
        Iterator localeIter = locales.iterator();
        while (localeIter.hasNext()) {
            int row = p_row.getValue();
            int col = 0;
            Row theRow = getRow(theSheet, row);
            String localeName = (String) localeIter.next();
            ProjectWorkflowData data = (ProjectWorkflowData) localeMap.get(localeName);

            if (jobLocale.size() != 0 && jobLocale.get(jobName + data.targetLang) != null) {
                continue;
            } else {
                jobLocale.put(jobName + data.targetLang, jobName + data.targetLang);
            }
            Cell cell_A = getCell(theRow, col++);
            cell_A.setCellValue(data.jobId);
            Cell cell_B = getCell(theRow, col++);
            cell_B.setCellValue(data.jobName);
            if (isWrongJob) {
                cell_A.setCellStyle(getWrongJobStyle(p_workbook));
                cell_B.setCellStyle(getWrongJobStyle(p_workbook));
            } else {
                cell_A.setCellStyle(getContentStyle(p_workbook));
                cell_B.setCellStyle(getContentStyle(p_workbook));
            }
            theSheet.setColumnWidth(col - 2, 5 * 256);
            theSheet.setColumnWidth(col - 1, 50 * 256);
            Cell cell_C = getCell(theRow, col++);// PO number
            cell_C.setCellValue("");
            cell_C.setCellStyle(getContentStyle(p_workbook));

            Cell cell_D = getCell(theRow, col++);
            cell_D.setCellValue(data.projectDesc);
            cell_D.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, 22 * 256);
            /* data.creationDate.toString())); */
            Cell cell_E = getCell(theRow, col++);
            cell_E.setCellValue(data.creationDate);
            cell_E.setCellStyle(getDateStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, 15 * 256);

            Cell cell_F = getCell(theRow, col++);
            cell_F.setCellValue(data.targetLang);
            cell_F.setCellStyle(getContentStyle(p_workbook));

            Cell cell_G = getCell(theRow, col++);
            cell_G.setCellValue(data.trados100WordCount);
            cell_G.setCellStyle(getContentStyle(p_workbook));
            int numwidth = 10;
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_H = getCell(theRow, col++);
            cell_H.setCellValue(data.trados95to99WordCount);
            cell_H.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_I = getCell(theRow, col++);
            cell_I.setCellValue(data.trados85to94WordCount);
            cell_I.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_J = getCell(theRow, col++);
            cell_J.setCellValue(data.trados75to84WordCount);
            cell_J.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_K = getCell(theRow, col++);
            cell_K.setCellValue(data.tradosNoMatchWordCount);
            cell_K.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_L = getCell(theRow, col++);
            cell_L.setCellValue(data.tradosRepsWordCount);
            cell_L.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, numwidth * 256);
            if (this.data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(data.tradosInContextWordCount);
                cell_InContext.setCellStyle(getContentStyle(p_workbook));
                theSheet.setColumnWidth(col - 1, numwidth * 256);
            }

            Cell cell_Total = getCell(theRow, col++);
            cell_Total.setCellValue(data.tradosTotalWordCount);
            cell_Total.setCellStyle(getContentStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            int moneywidth = 12;
            Cell cell_100Cost = getCell(theRow, col++);
            cell_100Cost.setCellValue(asDouble(data.trados100WordCountCost));
            cell_100Cost.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_95_99 = getCell(theRow, col++);
            cell_95_99.setCellValue(asDouble(data.trados95to99WordCountCost));
            cell_95_99.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_85_94 = getCell(theRow, col++);
            cell_85_94.setCellValue(asDouble(data.trados85to94WordCountCost));
            cell_85_94.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_75_84 = getCell(theRow, col++);
            cell_75_84.setCellValue(asDouble(data.trados75to84WordCountCost));
            cell_75_84.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_NoMatch = getCell(theRow, col++);
            cell_NoMatch.setCellValue(asDouble(data.tradosNoMatchWordCountCost));
            cell_NoMatch.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_Reps = getCell(theRow, col++);
            cell_Reps.setCellValue(asDouble(data.tradosRepsWordCountCost));
            cell_Reps.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);
            if (this.data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(asDouble(data.tradosInContextWordCountCost));
                cell_InContext.setCellStyle(getMoneyStyle(p_workbook));
                theSheet.setColumnWidth(col - 1, moneywidth * 256);
            }

            // theSheet.addCell(new
            // Number(col++,row,asDouble(data.tradosTotalWordCountCost),moneyFormat));
            // theSheet.setColumnView(col -1,moneywidth);
            Cell cell_Translation = getCell(theRow, col++);
            cell_Translation.setCellValue(asDouble(data.tradosTotalWordCountCostForTranslation));
            cell_Translation.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_Review = getCell(theRow, col++);
            cell_Review.setCellValue(asDouble(data.tradosTotalWordCountCostForDellReview));
            cell_Review.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_JobTotal = getCell(theRow, col++);
            cell_JobTotal.setCellValue(asDouble(data.tradosTotalWordCountCost));
            cell_JobTotal.setCellStyle(getMoneyStyle(p_workbook));
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            p_row.inc();
        }
    }

    p_row.inc();
    p_row.inc();
    addTotalsForTradosMatches(p_workbook, p_row);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.ReviewerVendorPoXlsReportHelper.java

License:Apache License

/** Adds the totals and sub-total formulas */
private void addTotalsForTradosMatches(Workbook p_workbook, IntHolder p_row) throws Exception {
    Sheet theSheet = data.tradosSheet;/*  w  ww. j av a2 s  .  c o  m*/
    int row = p_row.getValue() + 1; // skip a row
    String title = bundle.getString("lb_totals");

    Row totalRow = getRow(theSheet, row);
    Cell cell_A = getCell(totalRow, 0);
    cell_A.setCellValue(title);
    cell_A.setCellStyle(getSubTotalStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(row, row, 0, 5));
    setRegionStyle(theSheet, new CellRangeAddress(row, row, 0, 5), getSubTotalStyle(p_workbook));
    int lastRow = p_row.getValue() - 2;

    // add in word count totals
    int c = 6;
    // word counts
    if (data.headers[0] != null) {
        Cell cell_G = getCell(totalRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_H = getCell(totalRow, c++);
        cell_H.setCellFormula("SUM(H5:H" + lastRow + ")");
        cell_H.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_I = getCell(totalRow, c++);
        cell_I.setCellFormula("SUM(I5:I" + lastRow + ")");
        cell_I.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_J = getCell(totalRow, c++);
        cell_J.setCellFormula("SUM(J5:J" + lastRow + ")");
        cell_J.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_K = getCell(totalRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_L = getCell(totalRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_M = getCell(totalRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_N = getCell(totalRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_O = getCell(totalRow, c++);
        cell_O.setCellFormula("SUM(O5:O" + lastRow + ")");
        cell_O.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_P = getCell(totalRow, c++);
        cell_P.setCellFormula("SUM(P5:P" + lastRow + ")");
        cell_P.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_Q = getCell(totalRow, c++);
        cell_Q.setCellFormula("SUM(Q5:Q" + lastRow + ")");
        cell_Q.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_R = getCell(totalRow, c++);
        cell_R.setCellFormula("SUM(R5:R" + lastRow + ")");
        cell_R.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_S = getCell(totalRow, c++);
        cell_S.setCellFormula("SUM(S5:S" + lastRow + ")");
        cell_S.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_T = getCell(totalRow, c++);
        cell_T.setCellFormula("SUM(T5:T" + lastRow + ")");
        cell_T.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_U = getCell(totalRow, c++);
        cell_U.setCellFormula("SUM(U5:U" + lastRow + ")");
        cell_U.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_V = getCell(totalRow, c++);
        cell_V.setCellFormula("SUM(V5:V" + lastRow + ")");
        cell_V.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_W = getCell(totalRow, c++);
        cell_W.setCellFormula("SUM(W5:W" + lastRow + ")");
        cell_W.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_X = getCell(totalRow, c++);
        cell_X.setCellFormula("SUM(X5:X" + lastRow + ")");
        cell_X.setCellStyle(getTotalMoneyStyle(p_workbook));
    } else {
        Cell cell_G = getCell(totalRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_H = getCell(totalRow, c++);
        cell_H.setCellFormula("SUM(H5:H" + lastRow + ")");
        cell_H.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_I = getCell(totalRow, c++);
        cell_I.setCellFormula("SUM(I5:I" + lastRow + ")");
        cell_I.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_J = getCell(totalRow, c++);
        cell_J.setCellFormula("SUM(J5:J" + lastRow + ")");
        cell_J.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_K = getCell(totalRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_L = getCell(totalRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_M = getCell(totalRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_N = getCell(totalRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_O = getCell(totalRow, c++);
        cell_O.setCellFormula("SUM(O5:O" + lastRow + ")");
        cell_O.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_P = getCell(totalRow, c++);
        cell_P.setCellFormula("SUM(P5:P" + lastRow + ")");
        cell_P.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_Q = getCell(totalRow, c++);
        cell_Q.setCellFormula("SUM(Q5:Q" + lastRow + ")");
        cell_Q.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_R = getCell(totalRow, c++);
        cell_R.setCellFormula("SUM(R5:R" + lastRow + ")");
        cell_R.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_S = getCell(totalRow, c++);
        cell_S.setCellFormula("SUM(S5:S" + lastRow + ")");
        cell_S.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_T = getCell(totalRow, c++);
        cell_T.setCellFormula("SUM(T5:T" + lastRow + ")");
        cell_T.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_U = getCell(totalRow, c++);
        cell_U.setCellFormula("SUM(U5:U" + lastRow + ")");
        cell_U.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_V = getCell(totalRow, c++);
        cell_V.setCellFormula("SUM(V5:V" + lastRow + ")");
        cell_V.setCellStyle(getTotalMoneyStyle(p_workbook));
    }

    // add an extra column for Dell Tracking Use
    Cell cell_Last = getCell(totalRow, c++);
    cell_Last.setCellValue("");
    cell_Last.setCellStyle(getTotalMoneyStyle(p_workbook));
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.ReviewerVendorPoXlsReportHelper.java

License:Apache License

private void writeParamsSheet(Workbook p_workbook, Sheet paramsSheet) throws Exception {
    Row firRow = getRow(paramsSheet, 0);
    Row secRow = getRow(paramsSheet, 1);
    Row thirRow = getRow(paramsSheet, 2);

    Cell cell_A_Title = getCell(firRow, 0);
    cell_A_Title.setCellValue(bundle.getString("lb_report_criteria"));
    cell_A_Title.setCellStyle(getContentStyle(p_workbook));
    paramsSheet.setColumnWidth(0, 50 * 256);

    Cell cell_A_Header = getCell(secRow, 0);
    if (data.wantsAllProjects) {
        cell_A_Header.setCellValue(bundle.getString("lb_selected_projects") + " " + bundle.getString("all"));
        cell_A_Header.setCellStyle(getContentStyle(p_workbook));
    } else {/*ww  w.j  a  va2s. c  o m*/
        cell_A_Header.setCellValue(bundle.getString("lb_selected_projects"));
        cell_A_Header.setCellStyle(getContentStyle(p_workbook));
        Iterator iter = data.projectIdList.iterator();
        int r = 2;
        while (iter.hasNext()) {
            Long pid = (Long) iter.next();
            String projectName = "??";

            try {
                Project p = ServerProxy.getProjectHandler().getProjectById(pid.longValue());
                projectName = p.getName();
            } catch (Exception e) {
                s_logger.error("Failed to get project." + e);
            }

            Row theRow = getRow(paramsSheet, r);
            String v = projectName + " (" + bundle.getString("lb_report_id") + "=" + pid.toString() + ")";
            Cell cell_A = getCell(theRow, 0);
            cell_A.setCellValue(v);
            cell_A.setCellStyle(getContentStyle(p_workbook));
            r++;
        }
    }
    // add the date criteria
    String fromMsg = request.getParameter(JobSearchConstants.CREATION_START);
    String untilMsg = request.getParameter(JobSearchConstants.CREATION_END);

    Cell cell_B_Header = getCell(secRow, 1);
    cell_B_Header.setCellValue(bundle.getString("lb_from") + ":");
    cell_B_Header.setCellStyle(getContentStyle(p_workbook));

    Cell cell_B = getCell(thirRow, 1);
    cell_B.setCellValue(fromMsg);
    cell_B.setCellStyle(getContentStyle(p_workbook));
    paramsSheet.setColumnWidth(1, 20 * 256);

    Cell cell_C_Header = getCell(secRow, 2);
    cell_C_Header.setCellValue(bundle.getString("lb_until") + ":");
    cell_C_Header.setCellStyle(getContentStyle(p_workbook));

    Cell cell_C = getCell(thirRow, 2);
    cell_C.setCellValue(untilMsg);
    cell_C.setCellStyle(getContentStyle(p_workbook));
    paramsSheet.setColumnWidth(2, 20 * 256);

    // add the target lang criteria
    paramsSheet.setColumnWidth(3, 20 * 256);
    Cell cell_D_Header = getCell(secRow, 3);
    if (data.wantsAllTargetLangs) {
        cell_D_Header.setCellValue(bundle.getString("lb_selected_langs") + " " + bundle.getString("all"));
        cell_D_Header.setCellStyle(getContentStyle(p_workbook));
    } else {
        cell_D_Header.setCellValue(bundle.getString("lb_selected_langs"));
        cell_D_Header.setCellStyle(getContentStyle(p_workbook));
        Iterator iter = data.targetLangList.iterator();
        int r = 2;
        LocaleManagerLocal manager = new LocaleManagerLocal();
        while (iter.hasNext()) {
            String lang = (String) iter.next();
            Row theRow = getRow(paramsSheet, r++);
            Cell cell_D = getCell(theRow, 3);
            cell_D.setCellValue(manager.getLocaleById(Long.valueOf(lang)).toString());
            cell_D.setCellStyle(getContentStyle(p_workbook));
        }
    }
    paramsSheet.setColumnWidth(4, 20 * 256);
    Cell cell_E_Header = getCell(secRow, 4);
    if (data.allJobStatus) {
        cell_E_Header.setCellValue(bundle.getString("lb_job_status") + ": " + bundle.getString("all"));
        cell_E_Header.setCellStyle(getContentStyle(p_workbook));
    } else {
        cell_E_Header.setCellValue(bundle.getString("lb_job_status") + ": ");
        cell_E_Header.setCellStyle(getContentStyle(p_workbook));
        Iterator iter = data.jobStatusList.iterator();
        int r = 2;
        while (iter.hasNext()) {
            String jobStatus = (String) iter.next();
            Row theRow = getRow(paramsSheet, r);
            Cell cell_E = getCell(theRow, 4);
            cell_E.setCellValue(jobStatus);
            cell_E.setCellStyle(getContentStyle(p_workbook));
            r++;
        }
    }
    paramsSheet.setColumnWidth(5, 30 * 256);
    Cell cell_F_Header = getCell(secRow, 5);
    if (data.allActivities) {
        cell_F_Header.setCellValue(bundle.getString("lb_activity_name") + ": " + bundle.getString("all"));
        cell_F_Header.setCellStyle(getContentStyle(p_workbook));
    } else {
        cell_F_Header.setCellValue(bundle.getString("lb_activity_name") + ": ");
        cell_F_Header.setCellStyle(getContentStyle(p_workbook));
        Iterator iter = data.activityNameList.iterator();
        int r = 2;
        while (iter.hasNext()) {
            String activityName = (String) iter.next();
            Activity activity = (Activity) ServerProxy.getJobHandler().getActivity(activityName);
            Row theRow = getRow(paramsSheet, r);
            Cell cell_F = getCell(theRow, 5);
            cell_F.setCellValue(activity.getDisplayName());
            cell_F.setCellStyle(getContentStyle(p_workbook));
            r++;
        }
    }
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.SlaXlsReportHelper.java

License:Apache License

private void addTitle(Workbook p_workbook) throws Exception {
    Sheet theSheet = data.generalSheet;// w ww.ja va  2s .c o  m
    // title font is black bold on white
    Font titleFont = p_workbook.createFont();
    titleFont.setUnderline(Font.U_NONE);
    titleFont.setFontName("Arial");
    titleFont.setFontHeightInPoints((short) 14);
    titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
    titleFont.setColor(IndexedColors.BLACK.getIndex());
    CellStyle titleStyle = p_workbook.createCellStyle();
    titleStyle.setWrapText(false);
    titleStyle.setFont(titleFont);

    Cell titleCell = getCell(getRow(theSheet, 0), 0);
    titleCell.setCellValue(bundle.getString("translation_sla_performance"));
    titleCell.setCellStyle(titleStyle);
    theSheet.setColumnWidth(0, 20 * 256);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.SlaXlsReportHelper.java

License:Apache License

/**
 * Adds the table header for the Dell Matches sheet
 * // w ww  . ja  v  a  2s  .  c om
 */
private void addHeader(Workbook p_workbook) throws Exception {
    Sheet theSheet = data.generalSheet;
    int c = 0;
    Row headerRow = getRow(theSheet, 2);
    Cell cell_A = getCell(headerRow, c);
    cell_A.setCellValue(bundle.getString("lb_job_id"));
    cell_A.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 7 * 256);
    c++;
    Cell cell_B = getCell(headerRow, c);
    cell_B.setCellValue(bundle.getString("lb_job_name"));
    cell_B.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 40 * 256);
    c++;
    Cell cell_C = getCell(headerRow, c);
    cell_C.setCellValue(bundle.getString("lb_workflow"));
    cell_C.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 25 * 256);
    c++;
    Cell cell_D = getCell(headerRow, c);
    cell_D.setCellValue(bundle.getString("lb_language"));
    cell_D.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 12 * 256);
    c++;
    Cell cell_E = getCell(headerRow, c);
    cell_E.setCellValue(bundle.getString("lb_word_count"));
    cell_E.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 7 * 256);
    c++;
    Cell cell_F = getCell(headerRow, c);
    cell_F.setCellValue(bundle.getString("lb_current_activity"));
    cell_F.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 14 * 256);
    c++;
    Cell cell_G = getCell(headerRow, c);
    cell_G.setCellValue(bundle.getString("lb_translation_start_date"));
    cell_G.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 28 * 256);
    c++;
    Cell cell_H = getCell(headerRow, c);
    cell_H.setCellValue(bundle.getString("lb_translation_due_date"));
    cell_H.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 28 * 256);
    c++;
    Cell cell_I = getCell(headerRow, c);
    cell_I.setCellValue(bundle.getString("lb_translation_finish_date"));
    cell_I.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 28 * 256);
    c++;
    Cell cell_J = getCell(headerRow, c);
    cell_J.setCellValue(bundle.getString("lb_on_time"));
    cell_J.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 28 * 256);
    c++;
    Cell cell_K = getCell(headerRow, c);
    cell_K.setCellValue(bundle.getString("lb_leadtime"));
    cell_K.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 12 * 256);
    c++;
    Cell cell_L = getCell(headerRow, c);
    cell_L.setCellValue(bundle.getString("lb_actual_performance"));
    cell_L.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 14 * 256);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.SlaXlsReportHelper.java

License:Apache License

private void writeProjectData(Workbook p_workbook, HashMap p_projectMap, IntHolder p_row) throws Exception {
    Sheet theSheet = data.generalSheet;//from   w ww  .  j  a va 2 s  . co  m
    ArrayList projects = new ArrayList(p_projectMap.keySet());
    SortUtil.sort(projects);
    Iterator projectIter = projects.iterator();

    SimpleDateFormat dateFormat = data.dateFormat;

    while (projectIter.hasNext()) {
        String jobName = (String) projectIter.next();
        HashMap localeMap = (HashMap) p_projectMap.get(jobName);
        ArrayList locales = new ArrayList(localeMap.keySet());
        SortUtil.sort(locales);
        Iterator localeIter = locales.iterator();

        while (localeIter.hasNext()) {
            int row = p_row.getValue();
            Row theRow = getRow(theSheet, row);
            int col = 0;
            String localeId = (String) localeIter.next();
            ProjectWorkflowData data = (ProjectWorkflowData) localeMap.get(localeId);

            // Job Id
            Cell cell_A = getCell(theRow, col++);
            cell_A.setCellValue(data.jobId);
            cell_A.setCellStyle(getContentRightStyle(p_workbook));

            // Job Name
            Cell cell_B = getCell(theRow, col++);
            cell_B.setCellValue(data.jobName);
            cell_B.setCellStyle(getContentStyle(p_workbook));

            // Workflow Name
            Cell cell_C = getCell(theRow, col++);
            cell_C.setCellValue(data.workflowName);
            cell_C.setCellStyle(getContentStyle(p_workbook));

            // Lang
            Cell cell_D = getCell(theRow, col++);
            cell_D.setCellValue(data.targetLang);
            cell_D.setCellStyle(getContentStyle(p_workbook));

            // Word Count
            Cell cell_E = getCell(theRow, col++);
            cell_E.setCellValue(data.totalWordCount);
            cell_E.setCellStyle(getContentRightStyle(p_workbook));

            // Current Activity
            Cell cell_F = getCell(theRow, col++);
            cell_F.setCellValue(data.currentActivityName);
            cell_F.setCellStyle(getContentStyle(p_workbook));

            // Translation Start Date
            Cell cell_G = getCell(theRow, col++);
            cell_G.setCellValue(dateFormat.format(data.creationDate));
            cell_G.setCellStyle(getContentStyle(p_workbook));

            // Translation Due Date
            Cell cell_H = getCell(theRow, col++);
            if (data.estimatedTranslateCompletionDate == null) {
                cell_H.setCellValue(bundle.getString("lb_no_translation"));
                cell_H.setCellStyle(getContentStyle(p_workbook));
            } else {
                cell_H.setCellValue(dateFormat.format(data.estimatedTranslateCompletionDate));
                cell_H.setCellStyle(getContentStyle(p_workbook));
            }

            // Translation Finish Date
            Cell cell_I = getCell(theRow, col++);
            if (data.actualTranslateCompletionDate == null) {
                cell_I.setCellValue("");
                cell_I.setCellStyle(getContentStyle(p_workbook));
            } else {
                cell_I.setCellValue(dateFormat.format(data.actualTranslateCompletionDate));
                cell_I.setCellStyle(getContentStyle(p_workbook));
            }

            // On Time
            Cell cell_J = getCell(theRow, col++);
            if (data.actualTranslateCompletionDate == null) {
                cell_J.setCellValue("");
                cell_J.setCellStyle(getContentStyle(p_workbook));
            } else if (data.actualTranslateCompletionDate.before(data.estimatedTranslateCompletionDate)) {
                cell_J.setCellValue(bundle.getString("lb_yes"));
                cell_J.setCellStyle(getContentStyle(p_workbook));
            } else {
                cell_J.setCellValue(bundle.getString("lb_no"));
                cell_J.setCellStyle(getContentStyle(p_workbook));
            }

            // Leadtime
            if ((data.leadtime == null) || ("".equals(data.leadtime))) {
                // keep blank if "No translation"
                col++;
            } else {
                Cell cell_K = getCell(theRow, col++);
                cell_K.setCellValue(data.leadtime);
                cell_K.setCellStyle(getContentStyle(p_workbook));
            }

            // Actual Performance
            Cell cell_L = getCell(theRow, col++);
            if ((data.actualPerformance == null) || ("".equals(data.actualPerformance))) {
                cell_L.setCellValue(bundle.getString("lb_not_completed"));
                cell_L.setCellStyle(getContentStyle(p_workbook));
            } else {
                cell_L.setCellValue(data.actualPerformance);
                cell_L.setCellStyle(getContentStyle(p_workbook));
            }

            p_row.inc();
        }
    }

    p_row.inc();
    p_row.inc();
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.TranslationProgressReportHelper.java

License:Apache License

/**
 * Gets the jobs and outputs tasks information.
 * /* w  w w. j ava2  s .c o  m*/
 * @exception Exception
 */
private void addJobs(Workbook p_workbook, HttpServletRequest p_request, HttpServletResponse p_response)
        throws Exception {
    bundle = PageHandler.getBundle(p_request.getSession());
    // print out the request parameters
    String[] paramJobId = p_request.getParameterValues(JOB_ID);
    String[] paramTargetLocales = p_request.getParameterValues(TARGET_LOCALES);
    String[] paramSourceLocales = p_request.getParameterValues(SOURCE_LOCALES);
    Sheet sheet = p_workbook.createSheet(bundle.getString("lb_lisa_qa"));

    addTitle(p_workbook, sheet);

    addLanguageHeader(p_workbook, sheet);

    addSegmentHeader(p_workbook, sheet);

    Locale uiLocale = (Locale) p_request.getSession().getAttribute(WebAppConstants.UILOCALE);
    String srcLang = m_sourceLocale.getDisplayName(uiLocale);
    String trgLang = m_targetLocale.getDisplayName(uiLocale);
    writeLanguageInfo(p_workbook, sheet, srcLang, trgLang);

    // get jobs
    ArrayList<Job> jobs = new ArrayList<Job>();
    if (paramJobId != null && "*".equals(paramJobId[0])) {
        JobSearchParameters searchParams = getSearchParams(p_request);
        jobs.addAll(ServerProxy.getJobHandler().getJobs(searchParams));
    } else {
        for (int i = 0; i < paramJobId.length; i++) {
            if ("*".equals(paramJobId[i]) == false) {
                long jobId = Long.parseLong(paramJobId[i]);
                Job j = ServerProxy.getJobHandler().getJobById(jobId);
                jobs.add(j);
            }
        }
    }

    m_jobIDS = ReportHelper.getJobIDS(jobs);
    // Cancel Duplicate Request
    if (ReportHelper.checkReportsDataInProgressStatus(userId, m_jobIDS, getReportType())) {
        p_workbook = null;
        p_response.sendError(HttpServletResponse.SC_NO_CONTENT);
        return;
    }
    // Set ReportsData.
    ReportHelper.setReportsData(userId, m_jobIDS, getReportType(), 0, ReportsData.STATUS_INPROGRESS);

    // Separate jobs by Division
    Hashtable<String, List<Job>> projects = new Hashtable<String, List<Job>>();
    String tLocale = paramTargetLocales[0];
    for (Job job : jobs) {
        if (isCancelled()) {
            return;
        }
        boolean containTarLocale = false;
        for (Workflow wf : job.getWorkflows()) {
            String wfLocale = Long.toString(wf.getTargetLocale().getId());
            if (wfLocale.equals(tLocale)) {
                containTarLocale = true;
                break;
            }
        }
        if (!containTarLocale) {
            continue;
        }

        String projectName = job.getL10nProfile().getProject().getName();
        List<Job> jobList = null;
        if (projects.containsKey(projectName)) {
            jobList = projects.get(projectName);
        } else {
            jobList = new ArrayList<Job>();
            projects.put(projectName, jobList);
        }
        jobList.add(job);
    }

    // add jobs into sheet
    IntHolder row = new IntHolder(7);
    for (Enumeration<String> e = projects.keys(); e.hasMoreElements();) {
        String projectName = (String) e.nextElement();
        Cell cell_A_ProjectName = getCell(getRow(sheet, row.value), 0);
        cell_A_ProjectName.setCellValue(projectName);
        cell_A_ProjectName.setCellStyle(getContentStyle(p_workbook));
        List<Job> jobList = projects.get(projectName);
        for (Job job : jobList) {
            if (isCancelled()) {
                p_workbook = null;
                return;
            }
            addJobPages(p_workbook, sheet, job, row, paramSourceLocales, paramTargetLocales);
        }
    }

    // Set ReportsData.
    ReportHelper.setReportsData(userId, m_jobIDS, getReportType(), 100, ReportsData.STATUS_FINISHED);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.TranslationProgressReportHelper.java

License:Apache License

private void addTitle(Workbook p_workbook, Sheet p_sheet) throws Exception {
    // title font is black bold on white
    // String EMEA = CompanyWrapper.getCurrentCompanyName();
    Font titleFont = p_workbook.createFont();
    titleFont.setUnderline(Font.U_NONE);
    titleFont.setFontName("Times");
    titleFont.setFontHeightInPoints((short) 14);
    titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
    titleFont.setColor(IndexedColors.BLACK.getIndex());
    CellStyle titleStyle = p_workbook.createCellStyle();
    titleStyle.setWrapText(false);/*from   www. java  2s  .c o m*/
    titleStyle.setFont(titleFont);

    Row titleRow = getRow(p_sheet, 0);
    Cell cell_A_Title = getCell(titleRow, 0);
    cell_A_Title.setCellValue(bundle.getString("review_translation_progress_report"));
    cell_A_Title.setCellStyle(titleStyle);
    p_sheet.setColumnWidth(0, 22 * 256);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.TranslationProgressReportHelper.java

License:Apache License

private void addLanguageHeader(Workbook p_workbook, Sheet p_sheet) throws Exception {
    int col = 0;/*from   w w  w .j  a v  a2  s .c om*/
    int row = 3;
    Row headerRow = getRow(p_sheet, row);
    Cell cell_SourceLang = getCell(headerRow, col++);
    cell_SourceLang.setCellValue(bundle.getString("lb_source_language"));
    cell_SourceLang.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 27 * 256);

    Cell cell_TargetLang = getCell(headerRow, col++);
    cell_TargetLang.setCellValue(bundle.getString("lb_target_language"));
    cell_TargetLang.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 27 * 256);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.TranslationProgressReportHelper.java

License:Apache License

/**
* Adds the table header to the sheet/*w  w w. j a v  a 2s .  co  m*/
* 
* @param p_sheet
*/
private void addSegmentHeader(Workbook p_workbook, Sheet p_sheet) throws Exception {
    int col = 0;
    int row = 6;
    Row secHeaderRow = getRow(p_sheet, row);
    Cell cell_A = getCell(secHeaderRow, col++);
    cell_A.setCellValue(bundle.getString("lb_project"));
    cell_A.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 27 * 256);

    Cell cell_B = getCell(secHeaderRow, col++);
    cell_B.setCellValue(bundle.getString("lb_job_id_report"));
    cell_B.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 27 * 256);

    Cell cell_C = getCell(secHeaderRow, col++);
    cell_C.setCellValue(bundle.getString("lb_job_name"));
    cell_C.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 30 * 256);

    Cell cell_D = getCell(secHeaderRow, col++);
    cell_D.setCellValue(bundle.getString("lb_document_name"));
    cell_D.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 40 * 256);

    Cell cell_E = getCell(secHeaderRow, col++);
    cell_E.setCellValue(bundle.getString("lb_total_translated_text"));
    cell_E.setCellStyle(getHeaderStyle(p_workbook));
    p_sheet.setColumnWidth(col - 1, 20 * 256);
}