Example usage for org.apache.poi.xssf.streaming SXSSFWorkbook SXSSFWorkbook

Introduction

In this page you can find the example usage for org.apache.poi.xssf.streaming SXSSFWorkbook SXSSFWorkbook.

Prototype

public SXSSFWorkbook() 

Source Link

Document

Construct a new workbook with default row window size

Usage

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

License:Apache License

/**
 * Create Reports for download/*from  ww w  . j a va  2 s. c om*/
 * 
 * @param p_jobIDS
 *            Job ID List
 * @param p_targetLocales
 *            Target Locales List
 */
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    if (p_jobIDS == null || p_jobIDS.size() == 0) {
        p_jobIDS = m_jobIDS;
        p_targetLocales = m_targetLocales;
    } else if (m_jobIDS == null || m_jobIDS.size() == 0) {
        m_jobIDS = p_jobIDS;
    }
    List<File> workBooks = new ArrayList<File>();
    int finishedJobNum = 0;
    for (long jobID : m_jobIDS) {
        // Cancel generate reports.
        if (isCancelled())
            return null;

        if (cancel)
            return null;

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

        Job job = ServerProxy.getJobHandler().getJobById(jobID);

        if (job == null)
            continue;

        if (m_userId == null) {
            m_userId = job.getCreateUserId();
        }

        setAllCellStyleNull();

        Workbook workBook = new SXSSFWorkbook();
        createReport(workBook, job, p_targetLocales, m_dateFormat);
        File file = getFile(getReportType(), job, workBook);
        FileOutputStream out = new FileOutputStream(file);
        workBook.write(out);
        out.close();
        ((SXSSFWorkbook) workBook).dispose();

        workBooks.add(file);
    }

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

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

License:Apache License

/**
 * Generates Excel report// www  .  j a  va 2 s  . c o  m
 * 
 * @param p_jobIDS
 *            Job ID List
 * @param p_targetLocales
 *            Target Locales List
 * @param p_companyName
 *            Company Name
 * @throws Exception
 */
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    ArrayList<String> stateList = ReportHelper.getAllJobStatusList();
    stateList.remove(Job.PENDING);

    if (p_jobIDS == null || p_jobIDS.size() == 0) {
        p_jobIDS = m_jobIDS;
        p_targetLocales = m_targetLocales;
    } else if (m_jobIDS == null || m_jobIDS.size() == 0) {
        m_jobIDS = p_jobIDS;
    }

    List<File> workBooks = new ArrayList<File>();
    Workbook workBook = new SXSSFWorkbook();

    createReport(workBook, p_jobIDS, p_targetLocales, stateList);

    File file = getFile(reportType, null, workBook);
    FileOutputStream out = new FileOutputStream(file);
    workBook.write(out);
    out.close();
    ((SXSSFWorkbook) workBook).dispose();
    workBooks.add(file);

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

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 . jav a  2s .  c o  m
 * @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

@Override
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    List<File> workBooks = new ArrayList<File>();
    for (long jobID : p_jobIDS) {
        if (cancel)
            return new File[0];

        Job job = ServerProxy.getJobHandler().getJobById(jobID);
        if (job == null)
            continue;

        Workbook workBook = new SXSSFWorkbook();
        createReport(workBook, job, p_targetLocales, m_dateFormat);
        File file = getFile(getReportType(), job, workBook);
        FileOutputStream out = new FileOutputStream(file);
        workBook.write(out);//from w  w w  .  j a v a  2 s  .c  o  m
        out.close();
        ((SXSSFWorkbook) workBook).dispose();

        workBooks.add(file);
    }

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

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

License:Apache License

private void init() throws Exception {
    initDate();//from   ww  w  .  ja v a 2s  .c om

    workbook = new SXSSFWorkbook();
    sheet = workbook.createSheet(bundle.getString("lb_job_attributes"));
}

---

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 2s .c  om*/

    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();
}

---

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

License:Apache License

/**
 * Generates Excel report//  ww  w  .  j a  va2 s  .co  m
 * 
 * @throws Exception
 */
public void generateReport() throws Exception {
    bundle = PageHandler.getBundle(request.getSession());

    Workbook workbook = new SXSSFWorkbook();
    String dateFormat = request.getParameter(WebAppConstants.DATE_FORMAT);
    if (dateFormat == null) {
        dateFormat = DEFAULT_DATE_FORMAT;
    }

    createReport(workbook, dateFormat);

    ServletOutputStream out = response.getOutputStream();
    workbook.write(out);
    out.close();
    ((SXSSFWorkbook) workbook).dispose();
}

---

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

License:Apache License

/**
 * Generates the Excel report as a temp file and returns the temp file.
 * /*from  ww  w  .j  a va  2 s . c o  m*/
 * @return File
 * @exception Exception
 */
public void generateReport() throws Exception {
    bundle = PageHandler.getBundle(request.getSession());

    Workbook p_workbook = new SXSSFWorkbook();

    HashMap projectMap = data.projectMap;

    data.dellSheet = p_workbook.createSheet(bundle.getString("lb_globalsight_matches"));
    data.tradosSheet = p_workbook.createSheet(bundle.getString("jobinfo.tradosmatches"));

    addTitle(p_workbook, data.dellSheet);
    addHeaderForDellMatches(p_workbook);
    addTitle(p_workbook, data.tradosSheet);
    addHeaderForTradosMatches(p_workbook);

    IntHolder row = new IntHolder(4);
    writeProjectDataForDellMatches(p_workbook, projectMap, row);
    row = new IntHolder(4);
    writeProjectDataForTradosMatches(p_workbook, projectMap, row);

    Sheet paramsSheet = p_workbook.createSheet(bundle.getString("lb_criteria"));
    writeParamsSheet(p_workbook, paramsSheet);
    List<Long> reportJobIDS = new ArrayList(data.jobIdList);
    // Cancel Duplicate Request
    if (ReportHelper.checkReportsDataInProgressStatus(userId, reportJobIDS, getReportType())) {
        String message = "Cancle Review Vendor Report: " + userId + ", " + reportJobIDS;
        s_logger.info(message);
        response.sendError(response.SC_NO_CONTENT);
        return;
    }
    // Set ReportsData.
    ReportHelper.setReportsData(userId, reportJobIDS, getReportType(), 0, ReportsData.STATUS_INPROGRESS);

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

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

---

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

License:Apache License

/**
 * Generates the Excel report as a temp file and returns the temp file.
 * //from www .  j  a v a2s .  c o m
 * @return File
 * @exception Exception
 */
public void generateReport() throws Exception {
    userId = (String) request.getSession(false).getAttribute(WebAppConstants.USER_NAME);
    List<Long> reportJobIDS = new ArrayList<Long>(data.jobIdList);
    // Cancel Duplicate Request
    if (ReportHelper.checkReportsDataInProgressStatus(userId, reportJobIDS, getReportType())) {
        response.sendError(response.SC_NO_CONTENT);
        return;
    }
    // Set ReportsData.
    ReportHelper.setReportsData(userId, reportJobIDS, getReportType(), 0, ReportsData.STATUS_INPROGRESS);

    Workbook workbook = new SXSSFWorkbook();

    HashMap projectMap = data.projectMap;

    data.generalSheet = workbook.createSheet(bundle.getString("lb_sheet") + "1");

    addTitle(workbook);

    addHeader(workbook);

    IntHolder row = new IntHolder(4);
    writeProjectData(workbook, projectMap, row);

    ServletOutputStream out = response.getOutputStream();
    workbook.write(out);
    out.close();
    ((SXSSFWorkbook) workbook).dispose();

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

---

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

License:Apache License

/**
 * Generates the Excel report and spits it to the outputstream The report
 * consists of all in progress tasks/*w  w w. ja  v  a  2  s.c o  m*/
 * 
 * @return File
 * @exception Exception
 */
public void generateReport(HttpServletRequest p_request, HttpServletResponse p_response) throws Exception {
    String companyName = UserUtil.getCurrentCompanyName(p_request);
    CompanyThreadLocal.getInstance().setValue(companyName);

    setLocale(p_request);

    p_request.setCharacterEncoding("UTF-8");
    HttpSession session = p_request.getSession(false);
    userId = (String) session.getAttribute(WebAppConstants.USER_NAME);
    percent = NumberFormat.getPercentInstance((Locale) session.getAttribute(WebAppConstants.UILOCALE));

    Workbook p_workbook = new SXSSFWorkbook();
    addJobs(p_workbook, 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();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• »