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

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

Introduction

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

Prototype

void setCellStyle(CellStyle style);

Source Link

Document

Set the style for the cell.

Usage

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   ww w  .  j  a v a2 s  . 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 va 2  s .  c o  m
    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//from w w  w.ja v a  2 s .  c  o 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);
}

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

License:Apache License

private void writeLanguageInfo(Workbook p_workbook, Sheet sheet, String srcLang, String trgLang)
        throws Exception {
    Row localeRow = getRow(sheet, 4);/*w  w  w  . j  a v a  2s  . co m*/
    Cell cell_A = getCell(localeRow, 0);
    cell_A.setCellValue(srcLang);
    cell_A.setCellStyle(getContentStyle(p_workbook));
    Cell cell_B = getCell(localeRow, 1);
    cell_B.setCellValue(trgLang);
    cell_B.setCellStyle(getContentStyle(p_workbook));
}

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

License:Apache License

/**
 * add pages in a job//from w  ww . j a va  2 s  .com
 * 
 * @param sheet
 * @param job
 * @param row
 * @param paramSourceLocales
 * @param paramTargetLocales
 * @throws Exception
 */
private void addJobPages(Workbook p_workbook, Sheet p_sheet, Job job, IntHolder row,
        String[] paramSourceLocales, String[] paramTargetLocales) throws Exception {
    // return if source locale are not selected
    GlobalSightLocale gsl = job.getSourceLocale();
    if (!(Long.toString(gsl.getId())).equals(paramSourceLocales[0]))
        return;

    // get basic parameters
    String jobName = job.getJobName();
    long jobId = job.getId();
    Workflow selectedWF = null;
    String tLocale = paramTargetLocales[0];
    for (Workflow wf : job.getWorkflows()) {
        String wfLocale = Long.toString(wf.getTargetLocale().getId());
        if (wfLocale.equals(tLocale)) {
            selectedWF = wf;
            break;
        }
    }

    if (selectedWF != null) {
        Vector<TargetPage> targetPages = selectedWF.getTargetPages();
        for (TargetPage tp : targetPages) {
            int c = 1;
            // 8.2 Job id
            Row tehRow = getRow(p_sheet, row.value);
            Cell cell_B = getCell(tehRow, c++);
            cell_B.setCellValue(jobId);
            cell_B.setCellStyle(getContentStyle(p_workbook));
            // 8.2 job name
            Cell cell_C = getCell(tehRow, c++);
            cell_C.setCellValue(jobName);
            cell_C.setCellStyle(getContentStyle(p_workbook));
            // 8.3 document name
            String fileName = tp.getSourcePage().getExternalPageId();
            // fileName = SourcePage.filtSpecialFile(fileName);
            Cell cell_D = getCell(tehRow, c++);
            cell_D.setCellValue(fileName);
            cell_D.setCellStyle(getContentStyle(p_workbook));
            // 8.4 total translated text
            double p = SegmentTuvUtil.getTranslatedPercentageForTargetPage(tp.getId()) / 100.0;
            Cell cell_E = getCell(tehRow, c++);
            cell_E.setCellValue(p);
            cell_E.setCellStyle(getPercentStyle(p_workbook));
            row.inc();
        }
    }
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.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("Arial");
    titleFont.setFontHeightInPoints((short) 14);
    titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
    titleFont.setColor(IndexedColors.BLACK.getIndex());
    CellStyle titleStyle = p_workbook.createCellStyle();
    titleStyle.setWrapText(false);/*w  w w.  j a v a2  s  . c o m*/
    titleStyle.setFont(titleFont);

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

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

License:Apache License

/**
 * Adds the table header for the Dell Matches sheet
 * //from  w  w  w .  j a  v a 2 s  . c o  m
 */
private void addHeaderForDellMatches(Workbook p_workbook, MyData p_data) throws Exception {
    Sheet theSheet = p_data.dellSheet;
    int c = 0;
    Row thirRow = getRow(theSheet, 2);
    Row fourRow = getRow(theSheet, 3);

    Cell cell_A = getCell(thirRow, 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));
    c++;
    Cell cell_B = getCell(thirRow, c);
    cell_B.setCellValue(bundle.getString("lb_job"));
    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));
    c++;
    Cell cell_C = getCell(thirRow, c);
    cell_C.setCellValue(bundle.getString("lb_po_number_report"));
    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, 15 * 256);
    c++;
    Cell cell_D = getCell(thirRow, c);
    cell_D.setCellValue(bundle.getString("lb_description"));
    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, 15 * 256);
    c++;
    Cell cell_E = getCell(thirRow, c);
    cell_E.setCellValue(bundle.getString("lb_creation_date"));
    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));
    c++;
    Cell cell_F = getCell(thirRow, c);
    cell_F.setCellValue(bundle.getString("lb_lang"));
    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));
    c++;
    Cell cell_G_Header = getCell(thirRow, c);
    cell_G_Header.setCellValue(bundle.getString("lb_word_counts"));
    cell_G_Header.setCellStyle(getHeaderStyle(p_workbook));

    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 5));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 5), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 4));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 4), getHeaderStyle(p_workbook));
    }

    Cell cell_G = getCell(fourRow, c++);
    cell_G.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.internalreps"));
    cell_G.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_H = getCell(fourRow, c++);
    cell_H.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.exactmatches"));
    cell_H.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.incontextmatches"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }
    Cell cell_FuzzyMatches = getCell(fourRow, c++);
    cell_FuzzyMatches.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.fuzzymatches"));
    cell_FuzzyMatches.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Newwords = getCell(fourRow, c++);
    cell_Newwords.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.newwords"));
    cell_Newwords.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Total = getCell(fourRow, c++);
    cell_Total.setCellValue(bundle.getString("lb_total"));
    cell_Total.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Invoice = getCell(thirRow, c);
    cell_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice"));
    cell_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 5));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 5), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 4));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 4), getHeaderStyle(p_workbook));
    }

    Cell cell_InternalReps = getCell(fourRow, c++);
    cell_InternalReps.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.internalreps"));
    cell_InternalReps.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_ExactMatches = getCell(fourRow, c++);
    cell_ExactMatches.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.exactmatches"));
    cell_ExactMatches.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.incontextmatches"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }

    Cell cell_FuzzyMatches_Invoice = getCell(fourRow, c++);
    cell_FuzzyMatches_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.fuzzymatches"));
    cell_FuzzyMatches_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_NewWords_Invoice = getCell(fourRow, c++);
    cell_NewWords_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.newwords"));
    cell_NewWords_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Total_Invoice = getCell(fourRow, c++);
    cell_Total_Invoice.setCellValue(bundle.getString("lb_total"));
    cell_Total_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getContentStyle(p_workbook));
}

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

License:Apache License

/**
 * Adds the table header for the Trados Matches sheet
 * //  w ww.  j  a  v  a 2 s .  c  o m
 */
private void addHeaderForTradosMatches(Workbook p_workbook, MyData p_data) throws Exception {
    Sheet theSheet = p_data.tradosSheet;
    int c = 0;
    Row secRow = getRow(theSheet, 1);
    Row thirRow = getRow(theSheet, 2);
    Row fourRow = getRow(theSheet, 3);

    Cell cell_Ldfl = getCell(secRow, c);
    cell_Ldfl.setCellValue(bundle.getString("lb_desp_file_list"));
    cell_Ldfl.setCellStyle(getContentStyle(p_workbook));

    Cell cell_A = getCell(thirRow, 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));
    c++;
    Cell cell_B = getCell(thirRow, c);
    cell_B.setCellValue(bundle.getString("lb_job"));
    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));
    c++;
    Cell cell_C = getCell(thirRow, c);
    cell_C.setCellValue(bundle.getString("lb_po_number_report"));
    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));
    c++;
    Cell cell_D = getCell(thirRow, c);
    cell_D.setCellValue(bundle.getString("reportDesc"));
    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, 15 * 256);
    c++;
    Cell cell_E = getCell(thirRow, c);
    cell_E.setCellValue(bundle.getString("lb_creation_date"));
    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));
    c++;
    Cell cell_F = getCell(thirRow, c);
    cell_F.setCellValue(bundle.getString("lb_lang"));
    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));
    c++;
    Cell cell_G_Header = getCell(thirRow, c);
    cell_G_Header.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts"));
    cell_G_Header.setCellStyle(getHeaderStyle(p_workbook));

    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 7));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 7), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 6));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 6), getHeaderStyle(p_workbook));
    }

    Cell cell_G = getCell(fourRow, c++);
    cell_G.setCellValue(bundle.getString("jobinfo.tradosmatches.invoice.per100matches"));
    cell_G.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_H = getCell(fourRow, c++);
    cell_H.setCellValue(bundle.getString("lb_95_99"));
    cell_H.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_I = getCell(fourRow, c++);
    cell_I.setCellValue(bundle.getString("lb_85_94"));
    cell_I.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_J = getCell(fourRow, c++);
    cell_J.setCellValue(bundle.getString("lb_75_84") + "*");
    cell_J.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_K = getCell(fourRow, c++);
    cell_K.setCellValue(bundle.getString("lb_no_match"));
    cell_K.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_L = getCell(fourRow, c++);
    cell_L.setCellValue(bundle.getString("lb_repetition_word_cnt"));
    cell_L.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("lb_in_context_tm"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }
    Cell cell_Total = getCell(fourRow, c++);
    cell_Total.setCellValue(bundle.getString("lb_total"));
    cell_Total.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Invoice = getCell(thirRow, c);
    cell_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice"));
    cell_Invoice.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 7));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 7), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 6));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 6), getHeaderStyle(p_workbook));
    }

    Cell cell_Per100Matches = getCell(fourRow, c++);
    cell_Per100Matches.setCellValue(bundle.getString("jobinfo.tradosmatches.invoice.per100matches"));
    cell_Per100Matches.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_95_99 = getCell(fourRow, c++);
    cell_95_99.setCellValue(bundle.getString("lb_95_99"));
    cell_95_99.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_85_94 = getCell(fourRow, c++);
    cell_85_94.setCellValue(bundle.getString("lb_85_94"));
    cell_85_94.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_75_84 = getCell(fourRow, c++);
    cell_75_84.setCellValue(bundle.getString("lb_75_84") + "*");
    cell_75_84.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_NoMatch = getCell(fourRow, c++);
    cell_NoMatch.setCellValue(bundle.getString("lb_no_match"));
    cell_NoMatch.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Repetition = getCell(fourRow, c++);
    cell_Repetition.setCellValue(bundle.getString("lb_repetition_word_cnt"));
    cell_Repetition.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("lb_in_context_match"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }
    Cell cell_Total_Invoice = getCell(fourRow, c++);
    cell_Total_Invoice.setCellValue(bundle.getString("lb_total"));
    cell_Total_Invoice.setCellStyle(getHeaderStyle(p_workbook));
}

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

License:Apache License

public void writeProjectDataForDellMatches(Workbook p_workbook, HashMap p_projectMap, IntHolder p_row,
        MyData p_data) throws Exception {
    Sheet theSheet = p_data.dellSheet;/* w  w  w .j av 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 = p_data.wrongJobNames.contains(jobName);
        HashMap localeMap = (HashMap) p_projectMap.get(jobName);
        ArrayList locales = new ArrayList(localeMap.keySet());
        SortUtil.sort(locales);
        Iterator localeIter = locales.iterator();
        BigDecimal projectTotalWordCountCost = new BigDecimal(BIG_DECIMAL_ZERO_STRING);
        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);
            CellStyle temp_dateStyle = getDateStyle(p_workbook);
            CellStyle temp_moneyStyle = getMoneyStyle(p_workbook);
            CellStyle temp_normalStyle = getContentStyle(p_workbook);
            // WritableCellFormat temp_wordCountValueRightFormat =
            // wordCountValueRightFormat;
            if (data.wasExportFailed) {
                temp_dateStyle = getFailedDateStyle(p_workbook);
                temp_moneyStyle = getFailedMoneyStyle(p_workbook);
                temp_normalStyle = getRedCellStyle(p_workbook);

            }
            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(temp_normalStyle);
                cell_B.setCellStyle(temp_normalStyle);
            }
            theSheet.setColumnWidth(col - 2, 5 * 256);
            theSheet.setColumnWidth(col - 1, 50 * 256);
            Cell cell_C = getCell(theRow, col++);
            cell_C.setCellValue(data.poNumber);
            cell_C.setCellStyle(temp_normalStyle); // PO number

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

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

            Cell cell_G = getCell(theRow, col++);
            cell_G.setCellValue(data.dellInternalRepsWordCount);
            cell_G.setCellStyle(temp_normalStyle);
            int numwidth = 10;
            theSheet.setColumnWidth(col - 1, numwidth * 256);
            Cell cell_H = getCell(theRow, col++);
            cell_H.setCellValue(data.dellExactMatchWordCount);
            cell_H.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            if (p_data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(data.dellInContextMatchWordCount);
                cell_InContext.setCellStyle(temp_normalStyle);
                theSheet.setColumnWidth(col - 1, numwidth * 256);
            }

            Cell cell_FuzzyMatch = getCell(theRow, col++);
            cell_FuzzyMatch.setCellValue(data.dellFuzzyMatchWordCount);
            cell_FuzzyMatch.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_NewWords = getCell(theRow, col++);
            cell_NewWords.setCellValue(data.dellNewWordsWordCount);
            cell_NewWords.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

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

            int moneywidth = 12;
            Cell cell_InternalReps = getCell(theRow, col++);
            cell_InternalReps.setCellValue(asDouble(data.dellInternalRepsWordCountCost));
            cell_InternalReps.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_ExactMatch = getCell(theRow, col++);
            cell_ExactMatch.setCellValue(asDouble(data.dellExactMatchWordCountCost));
            cell_ExactMatch.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            if (p_data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(asDouble(data.dellInContextMatchWordCountCost));
                cell_InContext.setCellStyle(temp_moneyStyle);
                theSheet.setColumnWidth(col - 1, moneywidth * 256);
            }

            Cell cell_FuzzyMatch_Invoice = getCell(theRow, col++);
            cell_FuzzyMatch_Invoice.setCellValue(asDouble(data.dellFuzzyMatchWordCountCost));
            cell_FuzzyMatch_Invoice.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_NewWords_Invoice = getCell(theRow, col++);
            cell_NewWords_Invoice.setCellValue(asDouble(data.dellNewWordsWordCountCost));
            cell_NewWords_Invoice.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_Total_Invoice = getCell(theRow, col++);
            cell_Total_Invoice.setCellValue(asDouble(data.dellTotalWordCountCost));
            cell_Total_Invoice.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            p_row.inc();
        }
    }

    p_row.inc();
    p_row.inc();
    addTotalsForDellMatches(p_workbook, p_data, p_row, bundle);

}

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

License:Apache License

/** Adds the totals and sub-total formulas */
private void addTotalsForDellMatches(Workbook p_workbook, MyData p_data, IntHolder p_row, ResourceBundle bundle)
        throws Exception {
    Sheet theSheet = p_data.dellSheet;/*from www  .j  a  v  a 2  s.  c  o  m*/
    int row = p_row.getValue() + 1; // skip a row

    String title = bundle.getString("lb_totals");
    Row theRow = getRow(theSheet, row);
    Cell cell_A = getCell(theRow, 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;
    if (p_data.headers[0] != null) {
        // word counts
        Cell cell_G = getCell(theRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

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

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

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

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

        Cell cell_L = getCell(theRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_M = getCell(theRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_N = getCell(theRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getTotalMoneyStyle(p_workbook));

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

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

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

        Cell cell_R = getCell(theRow, c++);
        cell_R.setCellFormula("SUM(R5:R" + lastRow + ")");
        cell_R.setCellStyle(getTotalMoneyStyle(p_workbook));
    } else {
        // word counts
        Cell cell_G = getCell(theRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

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

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

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

        Cell cell_K = getCell(theRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_L = getCell(theRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getTotalMoneyStyle(p_workbook));

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

        Cell cell_N = getCell(theRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getTotalMoneyStyle(p_workbook));

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

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