Example usage for org.apache.poi.ss.usermodel Workbook createSheet

List of usage examples for org.apache.poi.ss.usermodel Workbook createSheet

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Workbook
  6. createSheet

Introduction

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

Prototype

Sheet createSheet(String sheetname);

Source Link

Document

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

Usage

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

License:Apache License

/**
 * Generates the Excel report as a temp file and returns the temp file. The
 * report consists of all jobs for the given PM, this year, on a month by
 * month basis.//from w ww  . j  a v a  2s.  com
 * 
 * @return File
 * @exception Exception
 */
private File[] generateReport(HttpServletRequest p_request) throws Exception {
    String[] months = getMonths();
    File file = ReportHelper.getXLSReportFile(getReportType(), null);
    Workbook p_workbook = new SXSSFWorkbook();
    int currentMonth = m_calendar.get(Calendar.MONTH);
    int year;
    if (p_request.getParameter("year") != null) {
        year = Integer.parseInt(p_request.getParameter("year"));
    } else {
        year = m_calendar.get(Calendar.YEAR);
    }
    if (year != m_calendar.get(Calendar.YEAR))
        currentMonth = 11;

    boolean wroteSomething = false;
    boolean recalculateFinishedWorkflow = false;
    String recalcParam = p_request.getParameter("recalc");
    if (recalcParam != null && recalcParam.length() > 0) {
        recalculateFinishedWorkflow = java.lang.Boolean.valueOf(recalcParam).booleanValue();
    }

    // For "Dell Review Report Issue"
    // Gets the tag that marks whether needs to separates "Dell_Review" or
    // not.
    // Default value is "false".
    boolean includeExReview = false;

    String reviewParam = p_request.getParameter("review");
    if ((reviewParam != null) && (reviewParam.length() > 0)) {
        includeExReview = java.lang.Boolean.valueOf(reviewParam).booleanValue();
    }

    // For "Add Job Id into online job report" issue
    isJobIdVisible = isJobIdVisible(p_request);
    String isReportForYear = p_request.getParameter("reportForThisYear");
    String isReportForDetail = p_request.getParameter("reportForDetail");
    // Generate Report By Year
    if (isReportForYear != null && isReportForYear.equals("on")) {
        int i = 0;
        for (i = 0; i <= currentMonth; i++) {
            // For "Dell Review Report Issue"
            // Add new parameter "includeExReview" to the signature.
            HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = getProjectDataForMonth(p_request,
                    i, recalculateFinishedWorkflow, includeExReview);

            // Cancel the report.
            if (isCancelled())
                return new File[0];

            if (projectMap.size() > 0) {
                // This sheets array has two elements.
                // sheets[MONTH_SHEET], the original monthSheet.
                // sheets[MONTH_REVIEW_SHEET], new monthly Dell_Review
                // sheet.
                Sheet[] sheets = new Sheet[2];
                IntHolder[] rows = new IntHolder[2];

                String sheetTitle = months[i] + " " + year;
                sheets[MONTH_SHEET] = p_workbook.createSheet(sheetTitle);
                if (m_data.isTradosStyle()) {
                    addTitle(p_workbook, sheets[MONTH_SHEET]);
                    addHeaderTradosStyle(p_workbook, sheets[MONTH_SHEET], MONTH_SHEET);
                } else {
                    addTitle(p_workbook, sheets[MONTH_SHEET]);
                    addHeader(p_workbook, sheets[MONTH_SHEET], MONTH_SHEET);
                }

                rows[MONTH_SHEET] = new IntHolder(4);

                if (includeExReview) {
                    String sheetReviewTitle = m_bundle.getString("lb_review") + " " + months[i] + " " + year;
                    sheets[MONTH_REVIEW_SHEET] = p_workbook.createSheet(sheetReviewTitle);
                    if (m_data.isTradosStyle()) {
                        addTitle(p_workbook, sheets[MONTH_REVIEW_SHEET]);
                        addHeaderTradosStyle(p_workbook, sheets[MONTH_REVIEW_SHEET], MONTH_REVIEW_SHEET);
                    } else {
                        addTitle(p_workbook, sheets[MONTH_REVIEW_SHEET]);
                        addHeader(p_workbook, sheets[MONTH_REVIEW_SHEET], MONTH_REVIEW_SHEET);
                    }
                    rows[MONTH_REVIEW_SHEET] = new IntHolder(4);
                }

                if (m_data.isTradosStyle()) {
                    writeProjectDataTradosStyle(projectMap, p_workbook, sheets, includeExReview, rows);
                } else {
                    writeProjectData(projectMap, p_workbook, sheets, includeExReview, rows);
                }
                wroteSomething = true;
            }
        }

        if (!wroteSomething) {
            // just write out the first sheet to avoid Excel problems
            i = 0;
            String sheetTitle = months[currentMonth] + " " + year;
            Sheet monthSheet = p_workbook.createSheet(sheetTitle);
            if (m_data.isTradosStyle()) {
                addTitle(p_workbook, monthSheet);
                addHeaderTradosStyle(p_workbook, monthSheet, MONTH_SHEET);
            } else {
                addTitle(p_workbook, monthSheet);
                addHeader(p_workbook, monthSheet, MONTH_SHEET);
            }

            if (includeExReview) {
                String sheetReviewTitle = "Review " + months[currentMonth] + " " + year;
                Sheet monthReviewSheet = p_workbook.createSheet(sheetReviewTitle);
                if (m_data.isTradosStyle()) {
                    addTitle(p_workbook, monthReviewSheet);
                    addHeaderTradosStyle(p_workbook, monthReviewSheet, MONTH_REVIEW_SHEET);
                } else {
                    addTitle(p_workbook, monthReviewSheet);
                    addHeader(p_workbook, monthReviewSheet, MONTH_REVIEW_SHEET);
                }
            }
        }

        // Create "Criteria" Sheet
        addParamsSheet(p_workbook, (String) p_request.getParameter("year"), recalculateFinishedWorkflow);

        FileOutputStream out = new FileOutputStream(file);
        p_workbook.write(out);
        out.close();
        ((SXSSFWorkbook) p_workbook).dispose();
    }
    // Generate Report by Creation Date Range.
    else if (isReportForDetail != null && isReportForDetail.endsWith("on")) {
        // For "Dell Review Report Issue"
        // Add new parameter "includeExReview" to the signature.
        HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = getProjectDataForMonth(p_request, 0,
                recalculateFinishedWorkflow, includeExReview);

        // Cancel the report.
        if (isCancelled())
            return new File[0];

        // Create sheets in Workbook.
        createSheets(p_workbook, projectMap, includeExReview);

        // Create "Criteria" Sheet
        addParamsSheet(p_workbook, (String) p_request.getParameter("year"), recalculateFinishedWorkflow);

        FileOutputStream out = new FileOutputStream(file);
        p_workbook.write(out);
        out.close();
        ((SXSSFWorkbook) p_workbook).dispose();
    }

    List<File> workBooks = new ArrayList<File>();
    workBooks.add(file);
    return ReportHelper.moveReports(workBooks, m_userId);
}

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

License:Apache License

/**
 * Create the report// w  ww  .j  a va 2s . co  m
 * 
 * @throws Exception
 */
private void createReport(Workbook p_workbook, Job p_job, List<GlobalSightLocale> p_targetLocales,
        String p_dateFormat) throws Exception {
    // Till now, only support one target locale.
    GlobalSightLocale trgLocale = p_targetLocales.get(0);

    // Create Sheet
    Sheet sheet = p_workbook.createSheet(trgLocale.toString());
    sheet.protectSheet("");

    // Add Title
    addTitle(p_workbook, sheet);

    // Add hidden info "PRR_taskID" for uploading.
    addHidenInfoForUpload(p_workbook, sheet, p_job, trgLocale);

    // Add Locale Pair Header
    addLanguageHeader(p_workbook, sheet);

    // Add Quality Assessment
    addQuaAssessment(p_workbook, sheet);

    // Add Suitability for Market
    addSuitMarket(p_workbook, sheet);

    // Add Reviewer Comment
    addReviwerCommet(p_workbook, sheet);

    // Add Segment Header
    addSegmentHeader(p_workbook, sheet);

    // Create Name Areas for drop down list.
    createCategoryFailureNameArea(p_workbook);

    createQualityAssessmentNameArea(p_workbook);

    createMarketSuitabilityNameArea(p_workbook);

    // Insert Data into Report
    String srcLang = p_job.getSourceLocale().getDisplayName(m_uiLocale);
    String trgLang = trgLocale.getDisplayName(m_uiLocale);
    writeLanguageInfo(p_workbook, sheet, srcLang, trgLang);
    writeQualityAssessmentInfo(p_workbook, sheet, p_job, trgLocale);
    writeMarketSuitabilityInfo(p_workbook, sheet, p_job, trgLocale);
    writeReviewerComment(p_workbook, sheet);

    writeSegmentInfo(p_workbook, sheet, p_job, trgLocale, "", p_dateFormat, SEGMENT_START_ROW);

    addQualityAssessmentValidation(sheet, 6, 6, 1, 1);
    addMarketSuitabilityValidation(sheet, 7, 7, 1, 1);
}

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

License:Apache License

/**
 * Create the report/*from  ww  w.  j  ava2s.c o  m*/
 * 
 * @throws Exception
 */
private void createReport(Workbook p_workbook, Job p_job, List<GlobalSightLocale> p_targetLocales,
        String p_dateFormat) throws Exception {
    boolean categoryFailureDropDownAdded = false;
    List<GlobalSightLocale> jobTL = ReportHelper.getTargetLocals(p_job);
    for (GlobalSightLocale trgLocale : p_targetLocales) {
        if (!jobTL.contains(trgLocale))
            continue;

        if (cancel)
            return;

        // Create Report Template
        Sheet sheet = p_workbook.createSheet(trgLocale.toString());
        sheet.protectSheet("");

        // Add Title
        addTitle(p_workbook, sheet);

        // Add hidden info "RCR_taskID" for uploading.
        addHidenInfoForUpload(p_workbook, sheet, p_job, trgLocale);

        // Add Locale Pair Header
        addLanguageHeader(p_workbook, sheet);

        // Add Segment Header
        addSegmentHeader(p_workbook, sheet);

        // Create Name Areas for drop down list.
        if (!categoryFailureDropDownAdded) {
            createCategoryFailureNameArea(p_workbook);
            categoryFailureDropDownAdded = true;
        }

        // Insert Language Data
        String srcLang = p_job.getSourceLocale().getDisplayName(m_uiLocale);
        String trgLang = trgLocale.getDisplayName(m_uiLocale);
        writeLanguageInfo(p_workbook, sheet, srcLang, trgLang);

        // Insert Segment Data
        writeSegmentInfo(p_workbook, sheet, p_job, trgLocale, SEGMENT_START_ROW);
    }
}

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

License:Apache License

/**
 * Create the report/*from   www . j a  va 2s .  co  m*/
 * 
 * @throws Exception
 */
private void createReport(Workbook p_workbook, Job p_job, List<GlobalSightLocale> p_targetLocales,
        String p_dateFormat) throws Exception {
    boolean categoryFailureDropDownAdded = false;
    List<GlobalSightLocale> jobTL = ReportHelper.getTargetLocals(p_job);
    for (GlobalSightLocale trgLocale : p_targetLocales) {
        if (!jobTL.contains(trgLocale))
            continue;

        if (cancel)
            return;

        // Create Report Template
        Sheet sheet = p_workbook.createSheet(trgLocale.toString());
        sheet.protectSheet("");

        // Add Title
        addTitle(p_workbook, sheet);

        // Add hidden info "RCSR_taskID" for uploading.
        addHidenInfoForUpload(p_workbook, sheet, p_job, trgLocale);

        // Add Locale Pair Header
        addLanguageHeader(p_workbook, sheet);

        // Add Segment Header
        addSegmentHeader(p_workbook, sheet);

        // Create Name Areas for drop down list.
        if (!categoryFailureDropDownAdded) {
            createCategoryFailureNameArea(p_workbook);
            categoryFailureDropDownAdded = true;
        }

        // Insert Language Data
        String srcLang = p_job.getSourceLocale().getDisplayName(m_uiLocale);
        String trgLang = trgLocale.getDisplayName(m_uiLocale);
        writeLanguageInfo(p_workbook, sheet, srcLang, trgLang);

        // Insert Segment Data
        writeSegmentInfo(p_workbook, sheet, p_job, trgLocale, SEGMENT_START_ROW);
    }
}

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

License:Apache License

/**
 * Create the report sheets/* w  w  w  .j  a  v a  2  s .  c om*/
 * 
 * @throws Exception
 */
private void createReport(Workbook p_workbook, List<Long> p_jobIds, List<GlobalSightLocale> p_targetLocales,
        ArrayList<String> stateList) throws Exception {
    Sheet sheet = p_workbook.createSheet("Scorecard");
    // Add Title
    addTitle(p_workbook, sheet);
    // Add Segment Header
    addSegmentHeader(p_workbook, sheet);

    HashMap<String, HashMap<String, Integer>> socreSum = new HashMap<String, HashMap<String, Integer>>();
    HashMap<String, HashMap<String, Integer>> socreNum = new HashMap<String, HashMap<String, Integer>>();
    List<GlobalSightLocale> sortLocales = sortLocales(p_targetLocales);
    for (GlobalSightLocale locale : sortLocales) {
        HashMap<String, Integer> localeSum = new HashMap<String, Integer>();
        HashMap<String, Integer> localeNum = new HashMap<String, Integer>();
        for (Select category : categoryList) {
            localeSum.put(category.getValue(), 0);
            localeNum.put(category.getValue(), 0);
        }
        socreSum.put(locale.toString(), localeSum);
        socreNum.put(locale.toString(), localeNum);
    }
    Set<GlobalSightLocale> tempLocaleSet = new HashSet<GlobalSightLocale>();

    // Insert score Data
    int finishedJobNum = 0;
    int row = SEGMENT_START_ROW;
    DecimalFormat numFormat = new DecimalFormat("#.00");
    for (long jobId : p_jobIds) {
        // Cancel generate reports.
        if (isCancelled())
            return;

        Job job = ServerProxy.getJobHandler().getJobById(jobId);
        if (job == null || !stateList.contains(job.getState()))
            continue;

        List<GlobalSightLocale> jobTL = ReportHelper.getTargetLocals(job);
        for (GlobalSightLocale trgLocale : sortLocales) {
            if (!jobTL.contains(trgLocale))
                continue;

            for (Workflow workflow : job.getWorkflows()) {
                if (workflow.getTargetLocale().equals(trgLocale)) {
                    row = writeSegmentInfo(p_workbook, sheet, job, workflow, row, numFormat, trgLocale,
                            socreSum, socreNum, tempLocaleSet);
                }
            }
        }

        // Sets Reports Percent.
        setPercent(++finishedJobNum);
    }

    addStatisticsSheet(p_workbook, socreSum, socreNum, tempLocaleSet, numFormat);
}

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

License:Apache License

private void addStatisticsSheet(Workbook p_workbook, HashMap<String, HashMap<String, Integer>> socreSum,
        HashMap<String, HashMap<String, Integer>> socreNum, Set<GlobalSightLocale> p_targetLocales,
        DecimalFormat numFormat) throws Exception {
    Sheet statisticsSheet = p_workbook.createSheet("Statistics");
    int row = 0;/*from  w  w w .j a va2  s  .c  o  m*/
    int col = 0;
    //header
    Row headerRow = getRow(statisticsSheet, row);

    CellStyle headerStyle = getHeaderStyle(p_workbook);
    Cell localeHeaderCell = getCell(headerRow, col);
    localeHeaderCell.setCellValue(bundle.getString("lb_target_locale"));
    localeHeaderCell.setCellStyle(headerStyle);
    statisticsSheet.setColumnWidth(col, 14 * 256);
    col++;

    for (Select category : categoryList) {
        Cell categoryCell = getCell(headerRow, col);
        categoryCell.setCellValue(category.getValue());
        categoryCell.setCellStyle(headerStyle);
        statisticsSheet.setColumnWidth(col, 21 * 256);
        col++;
    }

    Cell avgHeaderCell = getCell(headerRow, col);
    avgHeaderCell.setCellValue(bundle.getString("lb_avg_score"));
    avgHeaderCell.setCellStyle(headerStyle);
    statisticsSheet.setColumnWidth(col, 13 * 256);

    HashMap<String, Integer> categoyAvgSum = new HashMap<String, Integer>();
    HashMap<String, Integer> categoyAvgNum = new HashMap<String, Integer>();
    int totalSum = 0;
    int totalNum = 0;
    List<GlobalSightLocale> scortLocales = sortLocales(new ArrayList<GlobalSightLocale>(p_targetLocales));
    //segment
    for (GlobalSightLocale locale : scortLocales) {
        col = 0;
        row++;
        String tl = locale.toString();

        Row scoreRow = getRow(statisticsSheet, row);
        Cell localeCell = getCell(scoreRow, col);
        localeCell.setCellValue(tl);
        localeCell.setCellStyle(contentStyle);
        col++;

        int avgSum = 0;
        int avgNum = 0;
        for (Select category : categoryList) {
            String cv = category.getValue();
            if (socreSum.get(tl).get(cv) != 0) {
                Cell scoreCell = getCell(scoreRow, col);
                double avgScore = (double) socreSum.get(tl).get(cv) / socreNum.get(tl).get(cv);
                scoreCell.setCellValue(Double.parseDouble(numFormat.format(avgScore)));
                scoreCell.setCellStyle(getScoreCellStyle(p_workbook, avgScore));
                col++;
                //Statistics for locale
                avgSum = avgSum + socreSum.get(tl).get(cv);
                avgNum = avgNum + socreNum.get(tl).get(cv);

                //Statistics for category
                if (categoyAvgSum.get(cv) != null) {
                    categoyAvgSum.put(cv, categoyAvgSum.get(cv) + socreSum.get(tl).get(cv));
                    categoyAvgNum.put(cv, categoyAvgNum.get(cv) + socreNum.get(tl).get(cv));
                } else {
                    categoyAvgSum.put(cv, socreSum.get(tl).get(cv));
                    categoyAvgNum.put(cv, socreNum.get(tl).get(cv));
                }

                //Statistics for total
                totalSum = totalSum + socreSum.get(tl).get(cv);
                totalNum = totalNum + socreNum.get(tl).get(cv);
            } else {
                Cell scoreCell = getCell(scoreRow, col);
                scoreCell.setCellValue("");
                scoreCell.setCellStyle(contentStyle);
                col++;
            }
        }

        Cell avgCell = getCell(scoreRow, col);
        if (avgNum > 0) {
            double avgScore = (double) avgSum / avgNum;
            avgCell.setCellValue(Double.parseDouble(numFormat.format(avgScore)));
            avgCell.setCellStyle(getScoreCellStyle(p_workbook, avgScore));
        } else {
            avgCell.setCellValue("");
            avgCell.setCellStyle(contentStyle);
        }
        col++;
    }

    // avg 
    row++;
    col = 0;
    Row avgRow = getRow(statisticsSheet, row);

    Cell avgCell = getCell(avgRow, col);
    if (totalNum != 0) {
        avgCell.setCellValue(bundle.getString("lb_avg_score"));
        avgCell.setCellStyle(contentStyle);
    }
    col++;

    for (Select category : categoryList) {
        Cell categoryAvgCell = getCell(avgRow, col);
        if (categoyAvgSum.get(category.getValue()) != null) {
            double avgScore = (double) categoyAvgSum.get(category.getValue())
                    / categoyAvgNum.get(category.getValue());
            categoryAvgCell.setCellValue(Double.parseDouble(numFormat.format(avgScore)));
            categoryAvgCell.setCellStyle(getScoreCellStyle(p_workbook, avgScore));
        }
        col++;
    }

    Cell totalAvgCell = getCell(avgRow, col);
    double avgScore = 0;
    if (totalNum != 0) {
        avgScore = (double) totalSum / totalNum;
        totalAvgCell.setCellValue(Double.parseDouble(numFormat.format(avgScore)));
        totalAvgCell.setCellStyle(getScoreCellStyle(p_workbook, avgScore));
    }
}

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

License:Apache License

/**
 * Generates the Excel report as a temp file and returns the temp file.
 * /*from w ww  .ja v a2s  . com*/
 * @return File
 * @exception Exception
 */
public File[] generateReports(ReportSearchOptions p_searchOptions) throws Exception {
    bundle = p_searchOptions.getBundle();
    moneyFormatString = ReportUtil.getCurrencySymbol(p_searchOptions.getCurrency()) + MONEY_FORMAT;
    File file = ReportHelper.getXLSReportFile(getReportType(), null);
    Workbook workbook = new SXSSFWorkbook();
    String monthlySheetName = bundle.getString("lb_monthly");
    String leveragingSheetName = bundle.getString("lb_state_leveraging");
    String costsSheetName = bundle.getString("lb_costs");
    String criteriaSheetName = bundle.getString("lb_criteria");

    // Generates Summary Word Count Data.
    Map<String, ReportWordCount> summaryWordCount = getSummaryWordCount(p_searchOptions);

    // Create Monthly Sheet
    Sheet monthlySheet = workbook.createSheet(monthlySheetName);
    createMonthlySheet(workbook, monthlySheet, p_searchOptions, summaryWordCount);

    // Create Leveraging Sheet
    Sheet leveragingSheet = workbook.createSheet(leveragingSheetName);
    createLeveragingSheet(workbook, leveragingSheet, summaryWordCount);

    // Create Costs Sheet
    Sheet costsSheet = workbook.createSheet(costsSheetName);
    createLeveragingSheet(workbook, costsSheet, summaryWordCount);
    createCostsSheet(workbook, costsSheet, p_searchOptions, summaryWordCount);
    costsSheet.setZoom(9, 10);

    // Create Criteria Sheet
    Sheet criteriaSheet = workbook.createSheet(criteriaSheetName);
    createCriteriaSheet(workbook, criteriaSheet, p_searchOptions, summaryWordCount);

    FileOutputStream out = new FileOutputStream(file);
    workbook.write(out);
    out.close();
    ((SXSSFWorkbook) workbook).dispose();

    List<File> workBooks = new ArrayList<File>();
    workBooks.add(file);
    return ReportHelper.moveReports(workBooks, p_searchOptions.getUserId());
}

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

License:Apache License

/**
 * Create the report//from w w  w  . ja  v  a 2 s. c om
 * 
 * @throws Exception
 */
private void createReport(Workbook p_workbook, Job p_job, List<GlobalSightLocale> p_targetLocales,
        String p_dateFormat) throws Exception {
    // Till now, only support one target locale.
    GlobalSightLocale trgLocale = p_targetLocales.get(0);

    // Create Sheet
    Sheet sheet = p_workbook.createSheet(trgLocale.toString());
    sheet.protectSheet("");

    // Add Title
    addTitle(p_workbook, sheet);

    // Add hidden info "TER_taskID" for uploading.
    addHidenInfoForUpload(p_workbook, sheet, p_job, trgLocale);

    // Add Locale Pair Header
    addLanguageHeader(p_workbook, sheet);

    // Add Segment Header
    addSegmentHeader(p_workbook, sheet);

    // Create Name Areas for drop down list.
    createCategoryFailureNameArea(p_workbook);

    // Insert Data into Report
    String srcLang = p_job.getSourceLocale().getDisplayName(m_uiLocale);
    String trgLang = trgLocale.getDisplayName(m_uiLocale);
    writeLanguageInfo(p_workbook, sheet, srcLang, trgLang);

    writeSegmentInfo(p_workbook, sheet, p_job, trgLocale, "", p_dateFormat, SEGMENT_START_ROW);
}

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

License:Apache License

/**
 * Create the report//from w  w w  .  jav a  2 s  .c  o m
 * 
 * @throws Exception
 */
private void createReport(Workbook p_workbook, Job p_job, List<GlobalSightLocale> p_targetLocales,
        String p_dateFormat) throws Exception {
    // Till now, only support one target locale.
    GlobalSightLocale trgLocale = p_targetLocales.get(0);

    // Create Sheet
    Sheet sheet = p_workbook.createSheet(trgLocale.toString());
    sheet.protectSheet("");

    // Add Title
    addTitle(p_workbook, sheet);

    // Add hidden info "TVR_taskID" for uploading.
    addHidenInfoForUpload(p_workbook, sheet, p_job, trgLocale);

    // Add Locale Pair Header
    addLanguageHeader(p_workbook, sheet);

    // Add Segment Header
    addSegmentHeader(p_workbook, sheet);

    // Create Name Areas for drop down list.
    createCategoryFailureNameArea(p_workbook);

    // Insert Data into Report
    String srcLang = p_job.getSourceLocale().getDisplayName(m_uiLocale);
    String trgLang = trgLocale.getDisplayName(m_uiLocale);
    writeLanguageInfo(p_workbook, sheet, srcLang, trgLang);

    writeSegmentInfo(p_workbook, sheet, p_job, trgLocale, "", p_dateFormat, SEGMENT_START_ROW);
}

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

License:Apache License

public void generateReport(HttpServletRequest p_request, HttpServletResponse p_response) throws Exception {
    dateFormat = new SimpleDateFormat(p_request.getParameter(PARAM_DATE_FORMAT));
    uiLocale = (Locale) p_request.getSession().getAttribute(WebAppConstants.UILOCALE);
    bundle = PageHandler.getBundle(p_request.getSession());
    userId = (String) p_request.getSession(false).getAttribute(WebAppConstants.USER_NAME);
    String companyName = UserUtil.getCurrentCompanyName(p_request);
    if (!UserUtil.isBlank(companyName)) {
        CompanyThreadLocal.getInstance().setValue(companyName);
    }/*from www.j  a  va 2 s.co  m*/

    Workbook p_workbook = new SXSSFWorkbook();
    Sheet sheet = p_workbook.createSheet(bundle.getString("lb_job_status"));

    // Add Title
    addTitle(p_workbook, sheet);

    // add header
    addHeader(p_workbook, sheet);

    //
    addJobs(p_workbook, sheet, p_request, p_response);

    // Cancelled the report, return nothing.
    if (isCancelled()) {
        p_response.sendError(p_response.SC_NO_CONTENT);
        return;
    }

    ServletOutputStream out = p_response.getOutputStream();
    p_workbook.write(out);
    out.close();
    ((SXSSFWorkbook) p_workbook).dispose();
}