List of usage examples for org.apache.poi.xssf.usermodel XSSFHyperlink setAddress
@Override public void setAddress(String address)
From source file:com.anritsu.mcrepositorymanager.utils.GenerateRSS.java
public String getRSS() { FileInputStream file = null;//from ww w . j av a 2 s .com String rssFileName = rssTemplateFileName.replaceAll("template", mcVersion); try { file = new FileInputStream( new File(Configuration.getInstance().getRssTemplatePath() + rssTemplateFileName)); XSSFWorkbook workbook = new XSSFWorkbook(file); workbook.setSheetName(workbook.getSheetIndex("MC X.X.X"), "MC " + mcVersion); XSSFSheet sheet = workbook.getSheet("MC " + mcVersion); CreationHelper createHelper = workbook.getCreationHelper(); Cell cell = null; // Update the sheet title cell = sheet.getRow(0).getCell(0); cell.setCellValue(cell.getStringCellValue().replaceAll("template", mcVersion)); XSSFCellStyle cellStyle = workbook.createCellStyle(); cellStyle.setBorderBottom(XSSFCellStyle.BORDER_THIN); cellStyle.setBorderTop(XSSFCellStyle.BORDER_THIN); cellStyle.setBorderRight(XSSFCellStyle.BORDER_THIN); cellStyle.setBorderLeft(XSSFCellStyle.BORDER_THIN); XSSFCellStyle hlinkstyle = workbook.createCellStyle(); XSSFFont hlinkfont = workbook.createFont(); hlinkfont.setUnderline(XSSFFont.U_SINGLE); hlinkfont.setColor(HSSFColor.BLUE.index); hlinkstyle.setFont(hlinkfont); hlinkstyle.setBorderBottom(XSSFCellStyle.BORDER_THIN); hlinkstyle.setBorderTop(XSSFCellStyle.BORDER_THIN); hlinkstyle.setBorderRight(XSSFCellStyle.BORDER_THIN); hlinkstyle.setBorderLeft(XSSFCellStyle.BORDER_THIN); XSSFCellStyle dateCellStyle = workbook.createCellStyle(); dateCellStyle.setDataFormat(createHelper.createDataFormat().getFormat("dd-MMMM-yyyy")); dateCellStyle.setBorderBottom(XSSFCellStyle.BORDER_THIN); dateCellStyle.setBorderTop(XSSFCellStyle.BORDER_THIN); dateCellStyle.setBorderRight(XSSFCellStyle.BORDER_THIN); dateCellStyle.setBorderLeft(XSSFCellStyle.BORDER_THIN); // Populate the table int rowCount = 1; for (RecommendedMcPackage rmcp : sortedMcPackages) { if (rmcp.getRecommendedVersion() != null && rmcp.isShowInTable()) { Row row = sheet.createRow(rowCount + 1); rowCount++; cell = row.createCell(0); cell.setCellValue(rmcp.getTier().replaceAll("Anritsu/MasterClaw/", "")); cell.setCellStyle(cellStyle); cell = row.createCell(1); cell.setCellValue(rmcp.getGroup()); cell.setCellStyle(cellStyle); cell = row.createCell(2); cell.setCellValue(rmcp.getPackageName()); UrlValidator defaultValidator = new UrlValidator(UrlValidator.ALLOW_LOCAL_URLS); if (rmcp.getRecommendedVersion().getReleaseNote() != null && defaultValidator.isValid(rmcp.getRecommendedVersion().getReleaseNote())) { XSSFHyperlink releaseNotelink = (XSSFHyperlink) createHelper .createHyperlink(Hyperlink.LINK_URL); releaseNotelink.setAddress(rmcp.getRecommendedVersion().getReleaseNote()); //System.out.println("Inside(if) RN: " + rmcp.getRecommendedVersion().getReleaseNote() + " Valid: " + defaultValidator.isValid(rmcp.getRecommendedVersion().getReleaseNote())); cell.setHyperlink(releaseNotelink); } cell.setCellStyle(hlinkstyle); cell = row.createCell(3); cell.setCellValue(rmcp.getRecommendedVersion().getPackageVersion()); cell.setCellStyle(cellStyle); cell = row.createCell(4); cell.setCellValue(rmcp.getAvailability()); cell.setCellStyle(cellStyle); cell = row.createCell(5); String customers = Arrays.asList(rmcp.getRecommendedVersion().getCustomerList().toArray()) .toString(); if (customers.equalsIgnoreCase("[All]")) { customers = ""; } cell.setCellValue(customers); cell.setCellStyle(cellStyle); cell = row.createCell(6); cell.setCellValue(rmcp.getRecommendedVersion().getRisk()); cell.setCellStyle(cellStyle); cell = row.createCell(7); cell.setCellValue(rmcp.getPackageName()); XSSFHyperlink link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(rmcp.getRecommendedVersion().getDownloadLinks().iterator().next()); cell.setHyperlink((XSSFHyperlink) link); cell.setCellStyle(hlinkstyle); cell = row.createCell(8); cell.setCellValue((rmcp.getRecommendedVersion() != null && rmcp.getRecommendedVersion().isLessRecommended()) ? "#" : ""); cell.setCellStyle(cellStyle); cell = row.createCell(9); cell.setCellValue(rmcp.getRecommendedVersion().getNotes()); cell.setCellStyle(cellStyle); StringBuilder newFeatures = new StringBuilder(); for (MCPackageActivities mcpa : rmcp.getRecommendedVersion().getActivities()) { if (!mcpa.getActivityType().equalsIgnoreCase("epr")) { newFeatures.append(mcpa.getActivityType() + " " + mcpa.getActivityId() + "; "); } } cell = row.createCell(10); cell.setCellValue(newFeatures.toString()); cell.setCellStyle(cellStyle); cell = row.createCell(11); cell.setCellValue(rmcp.getRecommendedVersion().getReleaseDate()); cell.setCellStyle(dateCellStyle); } sheet.autoSizeColumn(0); sheet.autoSizeColumn(1); sheet.autoSizeColumn(2); sheet.autoSizeColumn(3); sheet.autoSizeColumn(4); sheet.autoSizeColumn(6); sheet.autoSizeColumn(7); sheet.autoSizeColumn(8); sheet.autoSizeColumn(11); } FileOutputStream outFile = new FileOutputStream( new File(Configuration.getInstance().getRssTemplatePath() + rssFileName)); workbook.write(outFile); outFile.close(); return Configuration.getInstance().getRssTemplatePath() + rssFileName; } catch (FileNotFoundException ex) { Logger.getLogger(GenerateRSS.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(GenerateRSS.class.getName()).log(Level.SEVERE, null, ex); } finally { try { file.close(); } catch (IOException ex) { Logger.getLogger(GenerateRSS.class.getName()).log(Level.SEVERE, null, ex); } } return ""; }
From source file:com.github.igor_kudryashov.utils.excel.ExcelWriter.java
License:Apache License
/** * //from w ww. ja v a 2 s . c om * Adds a hyperlink into a cell. The contents of the cell remains * peronachalnoe. Do not forget to fill in the contents of the cell before * add a hyperlinks. If a row already has been flushed, this method not * work! * * @param sheet * Sheet * @param rownum * number of row * @param colnum * number of column * @param url * hyperlink */ public void createHyperlink(Sheet sheet, int rownum, int colnum, String url) { Row row = sheet.getRow(rownum); if (url != null && !"".equals(url)) { Cell cell = row.getCell(colnum); CreationHelper createHelper = workbook.getCreationHelper(); XSSFHyperlink hyperlink = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); hyperlink.setAddress(url); cell.setHyperlink(hyperlink); cell.setCellStyle(getHyperlinkCellStyle(rownum, url)); } }
From source file:gov.nih.nci.evs.app.neopl.CSVtoExcel.java
License:Open Source License
public void runXSSF(String inputfile) { int size = checkSpecialCharacters(inputfile); int n = inputfile.lastIndexOf("."); //String outputfile = inputfile.substring(0, n) + ".xlsx"; String outputfile = getOutputFile(inputfile, ".xlsx"); try {//from w ww . ja v a2 s. co m XSSFWorkbook wb = new XSSFWorkbook(); XSSFCreationHelper helper = null; XSSFCellStyle cellStyle = wb.createCellStyle(); XSSFFont font = wb.createFont(); font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD); cellStyle.setFont(font); XSSFCellStyle linkCellStyle = wb.createCellStyle(); XSSFFont linkfont = wb.createFont(); //XSSFColor color = new XSSFColor(Color.LIGHT_BLUE); XSSFColor color = new XSSFColor(Color.BLUE); linkfont.setColor(color); //linkfont.setColor(XSSFColor.LIGHT_BLUE.index); linkCellStyle.setFont(linkfont); CSVReader reader = new CSVReader(new FileReader(inputfile));//CSV file String[] line; int r = 0; Cell cell = null; XSSFHyperlink url_link = null; XSSFSheet sheet = null; int page_num = 1; Row row = null; int lcv = 0; int row_count = 0; try { while ((line = reader.readNext()) != null) { if (lcv % PAGE_SIZE == 0) { r = 0; String sheetLabel = SHEET_LABEL; if (size > PAGE_SIZE) { sheetLabel = sheetLabel + " (Page " + page_num + ")"; } //System.out.println("Creating " + sheetLabel); sheet = wb.createSheet(sheetLabel); helper = sheet.getWorkbook().getCreationHelper(); url_link = helper.createHyperlink(XSSFHyperlink.LINK_URL); row = sheet.createRow((short) r); for (int i = 0; i < HEADINGS.length; i++) { String heading = HEADINGS[i]; cell = row.createCell(i); cell.setCellValue(heading); cell.setCellStyle(cellStyle); } page_num++; } else { String s4 = (String) line[4]; s4 = s4.trim(); r++; row = sheet.createRow((short) r); row_count++; cell = row.createCell(0); String ncit_code = line[0]; cell.setCellValue(ncit_code); if (NCIT_LINK) { url_link = helper.createHyperlink(XSSFHyperlink.LINK_URL); url_link.setAddress(getNCItHyperlink(ncit_code)); cell.setHyperlink(url_link); cell.setCellStyle(linkCellStyle); } cell = row.createCell(1); String name = line[1]; cell.setCellValue(line[1]); cell = row.createCell(2); cell.setCellValue(line[2]); if (NCIM_LINK) { String s2 = line[2]; s2 = s2.trim(); if (s2.length() > 0) { url_link = helper.createHyperlink(XSSFHyperlink.LINK_URL); url_link.setAddress(getNCImHyperlink(s2)); cell.setHyperlink(url_link); cell.setCellStyle(linkCellStyle); } } cell = row.createCell(3); String ncim_name = line[3]; cell.setCellValue(line[3]); cell = row.createCell(4); cell.setCellValue(line[4]); cell = row.createCell(5); String atom_name = (String) line[5]; cell.setCellValue(line[5]); cell = row.createCell(6); cell.setCellValue(line[6]); if (SOURCE_LINK) { if (s4.length() > 0) { String s6 = (String) line[6]; if (localNameMap.containsKey(s4)) { url_link = helper.createHyperlink(XSSFHyperlink.LINK_URL); s4 = (String) localNameMap.get(s4); url_link.setAddress(getSourceHyperlink(s4, s6)); cell.setHyperlink(url_link); cell.setCellStyle(linkCellStyle); } } } cell = row.createCell(7); cell.setCellValue(line[7]); } lcv++; } } catch (Exception ex) { ex.printStackTrace(); } // Write the output to a file FileOutputStream fileOut = new FileOutputStream(outputfile); wb.write(fileOut); fileOut.close(); System.out.println("Output file " + outputfile + " generated."); System.out.println("row_count: " + row_count); } catch (Exception ex) { ex.printStackTrace(); } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.BudgetByMOGSummaryXLS.java
License:Open Source License
/** * This method is used to add an institution being a project leader * //from w w w .j a va 2 s . com * @param projectLeadingInstitutions is the list of institutions to be added * @param projectList is the list with the projects related to each institution */ private void addContent(List<Map<String, Object>> informationListMapPOWB, Sheet sheet, int indexSheet, XSSFWorkbook workbook) { CreationHelper createHelper = workbook.getCreationHelper(); XSSFHyperlink link; Map<String, Object> mapObject; StringBuilder stringBuilder; String valueOne, valueTwo; int projectID; // Iterating all the projects if (indexSheet == 0) { for (int a = 0; a < informationListMapPOWB.size(); a++) { mapObject = informationListMapPOWB.get(a); // Iterating all the partners // Outcome stringBuilder = new StringBuilder(); valueOne = (String) mapObject.get("outcome_flagship"); valueTwo = (String) mapObject.get("outcome_description"); if (valueOne != null && valueTwo != null) { stringBuilder.append(valueOne); stringBuilder.append(" - "); stringBuilder.append(valueTwo); } else { stringBuilder.append(""); } xls.writeString(sheet, stringBuilder.toString()); xls.nextColumn(); // MOG description stringBuilder = new StringBuilder(); valueOne = (String) mapObject.get("mog_flagship"); valueTwo = (String) mapObject.get("mog_description"); if (valueOne != null && valueTwo != null) { stringBuilder.append(valueOne); stringBuilder.append(" - "); stringBuilder.append(valueTwo); } else { stringBuilder.append(""); } xls.writeString(sheet, stringBuilder.toString()); xls.nextColumn(); // budget_W1_W2 xls.writeBudget(sheet, (double) mapObject.get("budget_W1_W2")); xls.nextColumn(); // gender_W1_W2 xls.writeBudget(sheet, (double) mapObject.get("gender_W1_W2")); xls.nextColumn(); // budget_W3_Bilateral xls.writeBudget(sheet, (double) mapObject.get("budget_W3_Bilateral")); xls.nextColumn(); // gender_W3_Bilateral xls.writeBudget(sheet, (double) mapObject.get("gender_W3_Bilateral")); xls.nextRow(); } } else if (indexSheet == 1) { for (int a = 0; a < informationListMapPOWB.size(); a++) { mapObject = informationListMapPOWB.get(a); // Iterating all the partners projectID = (int) mapObject.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); // Title xls.writeString(sheet, (String) mapObject.get("project_title")); xls.nextColumn(); // project Type xls.writeString(sheet, ((String) mapObject.get("project_type")).replace("_", " ")); xls.nextColumn(); // MOG description stringBuilder = new StringBuilder(); valueOne = (String) mapObject.get("flagship"); valueTwo = (String) mapObject.get("mog_description"); if (valueOne != null && valueTwo != null) { stringBuilder.append(valueOne); stringBuilder.append(" - "); stringBuilder.append(valueTwo); } else { stringBuilder.append(""); } xls.writeString(sheet, stringBuilder.toString()); xls.nextColumn(); // Annual description xls.writeString(sheet, (String) mapObject.get("anual_contribution")); xls.nextColumn(); // Gender description xls.writeString(sheet, (String) mapObject.get("gender_contribution")); xls.nextColumn(); // budget_W1_W2 xls.writeBudget(sheet, (double) mapObject.get("budget_W1_W2")); xls.nextColumn(); // gender_W1_W2 xls.writeBudget(sheet, (double) mapObject.get("gender_W1_W2")); xls.nextColumn(); // budget_W3_Bilateral xls.writeBudget(sheet, (double) mapObject.get("budget_W3_Bilateral")); xls.nextColumn(); // gender_W3_Bilateral xls.writeBudget(sheet, (double) mapObject.get("gender_W3_Bilateral")); xls.nextColumn(); xls.nextRow(); } } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.BudgetPerPartnersSummaryXLS.java
License:Open Source License
/** * This method is used to add an institution being a project leader * // w w w . j a v a 2 s. c o m * @param projectLeadingInstitutions is the list of institutions to be added * @param projectList is the list with the projects related to each institution */ private void addContent(List<Map<String, Object>> informationBudgetByPartnerList, Sheet sheet) { CreationHelper createHelper = sheet.getWorkbook().getCreationHelper(); XSSFHyperlink link; Map<String, Object> mapObject; int projectID; // Iterating all the projects for (int a = 0; a < informationBudgetByPartnerList.size(); a++) { mapObject = informationBudgetByPartnerList.get(a); // Iterating all the partners projectID = (int) mapObject.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); // Title xls.writeString(sheet, (String) mapObject.get("project_title")); xls.nextColumn(); // Partner xls.writeString(sheet, (String) mapObject.get("partner")); xls.nextColumn(); // budget_W1_W2 xls.writeBudget(sheet, (double) mapObject.get("budget_W1_W2")); xls.nextColumn(); // gender_W1_W2 xls.writeBudget(sheet, (double) mapObject.get("gender_W1_W2")); xls.nextColumn(); // budget_W3_Bilateral xls.writeBudget(sheet, (double) mapObject.get("budget_W3_Bilateral")); xls.nextColumn(); // gender_W3_Bilateral xls.writeBudget(sheet, (double) mapObject.get("gender_W3_Bilateral")); xls.nextColumn(); xls.nextRow(); } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.DeliverablePlanningSummaryXLS.java
License:Open Source License
/** * This method is used to add an institution being a project leader * //www. ja v a 2 s . c o m * @param projectLeadingInstitutions is the list of institutions to be added * @param projectList is the list with the projects related to each institution */ private void addContent(List<Map<String, Object>> deliverableList, XSSFWorkbook workbook) { XSSFHyperlink link; Sheet sheet = workbook.getSheetAt(0); CreationHelper createHelper = workbook.getCreationHelper(); Map<String, Object> deliverableMap; int projectID; // Main Type StringBuilder stringBuilder; // Iterating all the projects for (int a = 0; a < deliverableList.size(); a++) { deliverableMap = deliverableList.get(a); projectID = (int) deliverableMap.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); // Title xls.writeString(sheet, (String) deliverableMap.get("project_title")); xls.nextColumn(); // Flashig xls.writeString(sheet, (String) deliverableMap.get("flagships")); xls.nextColumn(); // Region xls.writeString(sheet, (String) deliverableMap.get("regions")); xls.nextColumn(); // Title xls.writeString(sheet, this.messageReturn((String) deliverableMap.get("deliverable_title"))); xls.nextColumn(); // MOG xls.writeString(sheet, this.messageReturn((String) deliverableMap.get("mog"))); xls.nextColumn(); // Year xls.writeInteger(sheet, (int) deliverableMap.get("year")); xls.nextColumn(); // Main type xls.writeString(sheet, this.messageReturn((String) deliverableMap.get("deliverable_type"))); xls.nextColumn(); // Sub Type int deliverableTypeId = (int) deliverableMap.get("deliverable_type_id"); stringBuilder = new StringBuilder(); if (deliverableTypeId == 38) { stringBuilder.append("Other: ("); stringBuilder.append(this.messageReturn((String) deliverableMap.get("other_type"))); stringBuilder.append(")"); } else { stringBuilder.append(this.messageReturn((String) deliverableMap.get("deliverable_sub_type"))); } xls.writeString(sheet, stringBuilder.toString()); xls.nextColumn(); // Partner Responsible xls.writeString(sheet, (String) deliverableMap.get("partner_responsible")); xls.nextColumn(); // Other Partner xls.writeString(sheet, (String) deliverableMap.get("other_responsibles")); xls.nextColumn(); xls.nextRow(); } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.ImpactPathwayContributionsSummaryXLS.java
License:Open Source License
/** * This method is used to add a project with its corresponding gender contribution * //ww w .j a v a2 s .co m * @param sheet is the workbook sheet where the information is going to be presented * @param projectMapInformation is the list with the projects related to each institution */ private void addContent(List<Map<String, Object>> projectMapInformation, Sheet sheet) { Map<String, Object> projectMap; int projectID; CreationHelper createHelper = sheet.getWorkbook().getCreationHelper(); XSSFHyperlink link; // ************************* Project Level Gender Contribution *********************** for (int i = 0; i < projectMapInformation.size(); i++) { projectMap = projectMapInformation.get(i); projectID = (int) projectMap.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); // Project title xls.writeString(sheet, (String) projectMap.get("project_title")); xls.nextColumn(); // Flagship xls.writeString(sheet, (String) projectMap.get("flagship")); xls.nextColumn(); // Outcome 2019 xls.writeString(sheet, (String) projectMap.get("outcome_2019")); xls.nextColumn(); // indicator xls.writeString(sheet, (String) projectMap.get("indicator")); xls.nextColumn(); // target xls.writeString(sheet, (String) projectMap.get("target")); xls.nextColumn(); // target narrative xls.writeString(sheet, (String) projectMap.get("target_narrative")); xls.nextColumn(); // target gender xls.writeString(sheet, (String) projectMap.get("target_gender")); xls.nextRow(); } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.LeadProjectPartnersSummaryXLS.java
License:Open Source License
/** * This method is used to add an institution being a project leader * /*from ww w. j a va 2 s . c o m*/ * @param projectLeadingInstitutions is the list of institutions to be added * @param projectList is the list with the projects related to each institution */ private void addContent(Sheet sheet, List<Map<String, Object>> projectList) { XSSFHyperlink link; CreationHelper createHelper = sheet.getWorkbook().getCreationHelper(); Map<String, Object> projectPartnerLeader; String projectId; for (int i = 0; i < projectList.size(); i++) { projectPartnerLeader = projectList.get(i); projectId = projectPartnerLeader.get("project_id").toString(); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectId); xls.writeHyperlink(sheet, "P" + projectId, link); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("start_date")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("end_date")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("project_title")); xls.nextColumn(); xls.writeString(sheet, projectPartnerLeader.get("project_type").toString().replace("_", " ")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("project_summary")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("flagships")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("regions")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("lead_institution")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("project_leader")); xls.nextColumn(); xls.writeString(sheet, (String) projectPartnerLeader.get("project_coordinator")); xls.nextColumn(); xls.writeBudget(sheet, (double) projectPartnerLeader.get("budget_w1w2")); xls.nextColumn(); xls.writeBudget(sheet, (double) projectPartnerLeader.get("budget_w3bilateral")); xls.nextRow(); } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.ProjectsNotModifiedSummaryXLS.java
License:Open Source License
/** * This method is used to add a project with its corresponding gender contribution * //w ww. ja v a 2 s . c o m * @param sheet is the workbook sheet where the information is going to be presented * @param informationList is the list with the projects related to each institution */ private void addContent(List<Map<String, Object>> informationList, Sheet sheet) { int projectID; CreationHelper createHelper = sheet.getWorkbook().getCreationHelper(); Map<String, Object> projectMap; XSSFHyperlink link; // ************************* Project Level Submission Project *********************** for (int i = 0; i < informationList.size(); i++) { projectMap = informationList.get(i); projectID = (int) projectMap.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); xls.writeString(sheet, (String) projectMap.get("project_title")); xls.nextColumn(); xls.writeString(sheet, (String) projectMap.get("project_summary")); xls.nextColumn(); xls.writeString(sheet, ((String) projectMap.get("project_type")).replace("_", " ")); xls.nextRow(); } }
From source file:org.cgiar.ccafs.ap.summaries.projects.xlsx.SearchTermsSummaryXLS.java
License:Open Source License
/** * This method is used to add a project with its corresponding gender contribution * //w ww . ja v a 2 s.c om * @param sheet is the workbook sheet where the information is going to be presented * @param informationList is the list with the projects related to each institution */ private void addContent(List<Map<String, Object>> informationList, Sheet sheet, int sheetIndex, String[] terms) { Map<String, Object> projectContribution, activityContribution, deliverableContribution; for (int counter = 0; counter < terms.length; counter++) { terms[counter] = terms[counter].toLowerCase(); } int projectID, deliverableID; CreationHelper createHelper = sheet.getWorkbook().getCreationHelper(); XSSFHyperlink link; // = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); if (sheetIndex == 0) { // ************************* Project Level Gender Contribution *********************** for (int i = 0; i < informationList.size(); i++) { projectContribution = informationList.get(i); projectID = (int) projectContribution.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); xls.writeSearchString(sheet, (String) projectContribution.get("project_title"), terms); xls.nextColumn(); xls.writeSearchString(sheet, (String) projectContribution.get("project_summary"), terms); xls.nextColumn(); xls.writeSearchString(sheet, (String) projectContribution.get("outcome_statement"), terms); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("start_date")); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("end_date")); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("flagships")); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("regions")); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("lead_institution")); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("project_leader")); xls.nextColumn(); xls.writeString(sheet, (String) projectContribution.get("project_coordinator")); xls.nextColumn(); xls.writeBudget(sheet, (double) projectContribution.get("budget_w1w2")); xls.nextColumn(); xls.writeBudget(sheet, (double) projectContribution.get("budget_w3bilateral")); xls.nextColumn(); xls.writeBudget(sheet, (double) projectContribution.get("gender_w1w2")); xls.nextColumn(); xls.writeBudget(sheet, (double) projectContribution.get("gender_w3bilateral")); xls.nextRow(); } } else if (sheetIndex == 1) { // ************************* Activity Level Gender Contribution *********************** for (int i = 0; i < informationList.size(); i++) { activityContribution = informationList.get(i); projectID = (int) activityContribution.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); xls.writeSearchString(sheet, (String) activityContribution.get("project_title"), terms); xls.nextColumn(); // Activity id link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/activities.do?projectID=" + projectID); xls.writeHyperlink(sheet, "P" + String.valueOf(projectID) + "-" + "A" + (int) activityContribution.get("activity_id"), link); xls.nextColumn(); xls.writeSearchString(sheet, (String) activityContribution.get("activity_title"), terms); xls.nextColumn(); xls.writeSearchString(sheet, (String) activityContribution.get("activity_description"), terms); xls.nextColumn(); xls.writeString(sheet, (String) activityContribution.get("activity_startDate")); xls.nextColumn(); xls.writeString(sheet, (String) activityContribution.get("activity_endDate")); xls.nextColumn(); xls.writeString(sheet, (String) activityContribution.get("institution")); xls.nextColumn(); xls.writeString(sheet, (String) activityContribution.get("activity_leader")); xls.nextRow(); } } else if (sheetIndex == 2) { // ************************* Deliverable Level Gender Contribution *********************** for (int i = 0; i < informationList.size(); i++) { deliverableContribution = informationList.get(i); projectID = (int) deliverableContribution.get("project_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(config.getBaseUrl() + "/planning/projects/description.do?projectID=" + projectID); // Project id xls.writeHyperlink(sheet, "P" + String.valueOf(projectID), link); xls.nextColumn(); xls.writeSearchString(sheet, (String) deliverableContribution.get("project_title"), terms); xls.nextColumn(); // Deliverable id deliverableID = (int) deliverableContribution.get("deliverable_id"); link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress( config.getBaseUrl() + "/planning/projects/deliverable.do?deliverableID=" + deliverableID); xls.writeHyperlink(sheet, "P" + String.valueOf(projectID) + "-" + "D" + String.valueOf(deliverableID), link); xls.nextColumn(); xls.writeSearchString(sheet, (String) deliverableContribution.get("deliverable_title"), terms); xls.nextColumn(); xls.writeString(sheet, (String) deliverableContribution.get("deliverable_type")); xls.nextColumn(); xls.writeString(sheet, (String) deliverableContribution.get("deliverable_subtype")); xls.nextColumn(); xls.writeSearchString(sheet, (String) deliverableContribution.get("next_user"), terms); xls.nextColumn(); xls.writeSearchString(sheet, (String) deliverableContribution.get("expected_changes"), terms); xls.nextColumn(); xls.writeSearchString(sheet, (String) deliverableContribution.get("strategies"), terms); xls.nextColumn(); xls.writeString(sheet, (String) deliverableContribution.get("institution")); xls.nextColumn(); xls.writeString(sheet, (String) deliverableContribution.get("deliverable_responsible")); xls.nextRow(); } } }