List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook createSheet
@Override
public HSSFSheet createSheet()
From source file:edu.corgi.uco.Secretary.java
public void downloadReportData() throws IOException { if (!Students.isEmpty()) { HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(); HSSFRow row0 = sheet.createRow(0); HSSFCell cell0 = row0.createCell(0); cell0.setCellValue("First Name"); HSSFCell cell01 = row0.createCell(1); cell01.setCellValue("Last Name"); HSSFCell cell02 = row0.createCell(2); cell02.setCellValue("Email"); HSSFCell cell03 = row0.createCell(3); cell03.setCellValue("UCO ID"); HSSFCell cell04 = row0.createCell(4); cell04.setCellValue("Appointment Date"); for (int x = 0; x < Students.size(); x++) { HSSFRow row = sheet.createRow(x + 1); HSSFCell cell = row.createCell(0); cell.setCellValue(Students.get(x).getStudentFirstName()); HSSFCell cell1 = row.createCell(1); cell1.setCellValue(Students.get(x).getStudentLastName()); HSSFCell cell2 = row.createCell(2); cell2.setCellValue(Students.get(x).getStudentEmail()); HSSFCell cell3 = row.createCell(3); cell3.setCellValue(Students.get(x).getUcoID()); HSSFCell cell4 = row.createCell(4); cell4.setCellValue(Students.get(x).getMeetingDate().toString()); }/*from ww w. ja v a2 s . co m*/ FacesContext facesContext = FacesContext.getCurrentInstance(); ExternalContext externalContext = facesContext.getExternalContext(); externalContext.setResponseContentType("application/vnd.ms-excel"); externalContext.setResponseHeader("Content-Disposition", "attachment; filename=\"report.xls\""); workbook.write(externalContext.getResponseOutputStream()); facesContext.responseComplete(); } }
From source file:edu.jhu.cvrg.services.nodeDataService.DataStaging.java
License:Open Source License
/** Service to make final destination directories and transfer the file into it, via routeToFolder().<BR/> * Assumes that the file was already transfered to the ftp area. * /*from www . j a va2s . co m*/ * @param param0 OMElement containing the parameters:<BR/> * userId, subjectId, fileName, ftpHost, ftpUser, ftpPassword, bExposure * @return ??? always returns SUCCESS ??? * @throws Exception */ @SuppressWarnings("deprecation") public org.apache.axiom.om.OMElement consolidateCsvs(org.apache.axiom.om.OMElement param0) throws Exception { System.out.println("# consolidateCsvs() #"); OMFactory fac = OMAbstractFactory.getOMFactory(); OMNamespace omNs = fac.createOMNamespace("http://www.cvrgrid.org/nodeDataService/", "nodeDataService"); OMElement stageTransferredDataStatus = fac.createOMElement("stageTransferredData", omNs); Iterator iterator = param0.getChildren(); String userId = ((OMElement) iterator.next()).getText(); String chesSubjectIds = ((OMElement) iterator.next()).getText(); String bergSubjectIds = ((OMElement) iterator.next()).getText(); String chesFileNames = ((OMElement) iterator.next()).getText(); String bergFileNames = ((OMElement) iterator.next()).getText(); Boolean isPublic = new Boolean(((OMElement) iterator.next()).getText()).booleanValue(); String ftpHost = ((OMElement) iterator.next()).getText(); String ftpUser = ((OMElement) iterator.next()).getText(); String ftpPassword = ((OMElement) iterator.next()).getText(); String service = ((OMElement) iterator.next()).getText(); long logindatetime = new Long(((OMElement) iterator.next()).getText()).longValue(); String qrsScoreSubjectIds = ((OMElement) iterator.next()).getText(); String qrsScoreFileNames = ((OMElement) iterator.next()).getText(); try { verbose = new Boolean(((OMElement) iterator.next()).getText()).booleanValue(); } catch (NoSuchElementException nseEx) { System.out.println( "'iteration has no more elements' Exception while parsing 'verbose' in consolidateCsvs()"); } String publicOrPrivate = null; if (isPublic) { publicOrPrivate = "public"; } else { publicOrPrivate = "private"; } debugPrintln("userId: \"" + userId + "\""); debugPrintln("chesSubjectIds: \"" + chesSubjectIds + "\""); debugPrintln("bergSubjectIds: \"" + bergSubjectIds + "\""); debugPrintln("chesFileNames: \"" + chesFileNames + "\""); debugPrintln("bergFileNames: \"" + bergFileNames + "\""); debugPrintln("isPublic: \"" + isPublic + "\""); debugPrintln("ftpHost: \"" + ftpHost + "\""); debugPrintln("ftpUser: \"" + ftpUser + "\""); debugPrintln("ftpPassword: \"" + ftpPassword + "\""); debugPrintln("service: \"" + service + "\""); debugPrintln("logindatetime: \"" + logindatetime + "\""); debugPrintln("qrsScoreSubjectIds: \"" + qrsScoreSubjectIds + "\""); debugPrintln("qrsScoreFileNames: \"" + qrsScoreFileNames + "\""); debugPrintln("verbose: \"" + verbose + "\""); String timestamp = utils.generateTimeStamp(); String allResultsFileName = "allResultsFiles_" + userId + "_" + timestamp + ".xls"; String localAllResultsDirectory = findRelativePath("./", localWebPageRoot + sep + downloadDirectory); // put files to be allResults spreadsheet in here. String urlAllResultsDirectory = urlWebPageRoot + downloadDirectory; // URL as seen from the internet that is equivalent to localOutputDirectory above. e.g. http://icmv058.icm.jhu.edu:8080/download try { ApacheCommonsFtpWrapper ftpClient = new ApacheCommonsFtpWrapper(ftpHost, ftpUser, ftpPassword); ftpClient.verbose = verbose; System.out.println(userId + " Ches File Names: " + chesFileNames + "Berg File Names " + bergFileNames); System.out.println(userId + " Ches Subjects: " + chesSubjectIds + "Berg Subjects " + bergSubjectIds); FileOutputStream out = new FileOutputStream(localAllResultsDirectory + sep + allResultsFileName); HSSFWorkbook wbo = new HSSFWorkbook(); int numSheets = 0; if (!chesSubjectIds.equals("")) { HSSFSheet chesSheet = wbo.createSheet(); chesSheet = consolidateAlgorithmFiles(0, chesSheet, chesSubjectIds, userId, chesFileNames, isPublic, ftpClient); wbo.setSheetName(numSheets, "Chesnokov Results"); ++numSheets; } if (!bergSubjectIds.equals("")) { HSSFSheet bergerSheet = wbo.createSheet(); bergerSheet = consolidateAlgorithmFiles(1, bergerSheet, bergSubjectIds, userId, bergFileNames, isPublic, ftpClient); wbo.setSheetName(numSheets, "Berger Results"); ++numSheets; } if (!qrsScoreSubjectIds.equals("")) { HSSFSheet qrsScoreSheet = wbo.createSheet(); qrsScoreSheet = consolidateAlgorithmFiles(1, qrsScoreSheet, qrsScoreSubjectIds, userId, qrsScoreFileNames, isPublic, ftpClient); wbo.setSheetName(numSheets, "QRS-Score Results"); ++numSheets; } wbo.write(out); out.close(); } catch (IOException e) { e.printStackTrace(); } debugPrintln(bergSubjectIds); debugPrintln(chesSubjectIds); debugPrintln(qrsScoreSubjectIds); stageTransferredDataStatus.addChild(fac.createOMText(urlAllResultsDirectory + sep + allResultsFileName)); debugPrintln("Returning results URL: \"" + urlAllResultsDirectory + sep + allResultsFileName + "\""); return stageTransferredDataStatus; }
From source file:edu.jhu.cvrg.services.nodeDataService.DataStaging.java
License:Open Source License
/** Service to make final destination directories and transfer the file into it, via routeToFolder().<BR/> * Assumes that the file was already transfered to the ftp area. * //from ww w . j av a 2s . com * @param param0 OMElement containing the parameters:<BR/> * userId, subjectId, fileName, ftpHost, ftpUser, ftpPassword, bExposure * @return ??? always returns SUCCESS ??? * @throws Exception */ @SuppressWarnings("deprecation") public org.apache.axiom.om.OMElement consolidateCsvsForWaveform(org.apache.axiom.om.OMElement param0) throws Exception { System.out.println("# consolidateCsvsForWaveform() #"); OMFactory fac = OMAbstractFactory.getOMFactory(); OMNamespace omNs = fac.createOMNamespace("http://www.cvrgrid.org/nodeDataService/", "nodeDataService"); OMElement stageTransferredDataStatus = fac.createOMElement("stageTransferredData", omNs); Iterator iterator = param0.getChildren(); String userId = ((OMElement) iterator.next()).getText(); String chesSubjectIds = ((OMElement) iterator.next()).getText(); String bergSubjectIds = ((OMElement) iterator.next()).getText(); String chesFileNames = ((OMElement) iterator.next()).getText(); String bergFileNames = ((OMElement) iterator.next()).getText(); Boolean isPublic = new Boolean(((OMElement) iterator.next()).getText()).booleanValue(); String ftpHost = ((OMElement) iterator.next()).getText(); String ftpUser = ((OMElement) iterator.next()).getText(); String ftpPassword = ((OMElement) iterator.next()).getText(); String service = ((OMElement) iterator.next()).getText(); long logindatetime = new Long(((OMElement) iterator.next()).getText()).longValue(); String qrsScoreSubjectIds = ((OMElement) iterator.next()).getText(); String qrsScoreFileNames = ((OMElement) iterator.next()).getText(); try { verbose = new Boolean(((OMElement) iterator.next()).getText()).booleanValue(); } catch (NoSuchElementException nseEx) { System.out.println( "'iteration has no more elements' Exception while parsing 'verbose' in consolidateCsvs()"); } String publicOrPrivate = null; if (isPublic) { publicOrPrivate = "public"; } else { publicOrPrivate = "private"; } debugPrintln("userId: \"" + userId + "\""); debugPrintln("chesSubjectIds: \"" + chesSubjectIds + "\""); debugPrintln("bergSubjectIds: \"" + bergSubjectIds + "\""); debugPrintln("chesFileNames: \"" + chesFileNames + "\""); debugPrintln("bergFileNames: \"" + bergFileNames + "\""); debugPrintln("isPublic: \"" + isPublic + "\""); debugPrintln("ftpHost: \"" + ftpHost + "\""); debugPrintln("ftpUser: \"" + ftpUser + "\""); debugPrintln("ftpPassword: \"" + ftpPassword + "\""); debugPrintln("service: \"" + service + "\""); debugPrintln("logindatetime: \"" + logindatetime + "\""); debugPrintln("qrsScoreSubjectIds: \"" + qrsScoreSubjectIds + "\""); debugPrintln("qrsScoreFileNames: \"" + qrsScoreFileNames + "\""); debugPrintln("verbose: \"" + verbose + "\""); String timestamp = utils.generateTimeStamp(); String allResultsFileName = "allResultsFiles_" + userId + "_" + timestamp + ".xls"; String localAllResultsDirectory = localFtpRoot; // put files to be allResults spreadsheet in here. try { ApacheCommonsFtpWrapper ftpClient = new ApacheCommonsFtpWrapper(ftpHost, ftpUser, ftpPassword); ftpClient.verbose = verbose; System.out.println(userId + " Ches File Names: " + chesFileNames + "Berg File Names " + bergFileNames); System.out.println(userId + " Ches Subjects: " + chesSubjectIds + "Berg Subjects " + bergSubjectIds); FileOutputStream out = new FileOutputStream(localAllResultsDirectory + sep + allResultsFileName); HSSFWorkbook wbo = new HSSFWorkbook(); int numSheets = 0; if (!chesSubjectIds.equals("")) { HSSFSheet chesSheet = wbo.createSheet(); chesSheet = consolidateAlgorithmFiles(0, chesSheet, chesSubjectIds, userId, chesFileNames, isPublic, ftpClient); wbo.setSheetName(numSheets, "Chesnokov Results"); ++numSheets; } if (!bergSubjectIds.equals("")) { HSSFSheet bergerSheet = wbo.createSheet(); bergerSheet = consolidateAlgorithmFiles(1, bergerSheet, bergSubjectIds, userId, bergFileNames, isPublic, ftpClient); wbo.setSheetName(numSheets, "Berger Results"); ++numSheets; } if (!qrsScoreSubjectIds.equals("")) { HSSFSheet qrsScoreSheet = wbo.createSheet(); qrsScoreSheet = consolidateAlgorithmFiles(1, qrsScoreSheet, qrsScoreSubjectIds, userId, qrsScoreFileNames, isPublic, ftpClient); wbo.setSheetName(numSheets, "QRS-Score Results"); ++numSheets; } wbo.write(out); out.close(); } catch (IOException e) { e.printStackTrace(); } debugPrintln(bergSubjectIds); debugPrintln(chesSubjectIds); debugPrintln(qrsScoreSubjectIds); stageTransferredDataStatus.addChild(fac.createOMText(localAllResultsDirectory + sep + allResultsFileName)); debugPrintln("Returning results path: \"" + localAllResultsDirectory + sep + allResultsFileName + "\""); return stageTransferredDataStatus; }
From source file:edu.ku.brc.dbsupport.TableModel2Excel.java
License:Open Source License
/** * Converts a tableModel to an Excel Spreadsheet. * @param toFile the file object to write it to. * @param title the title of the spreadsheet. * @param tableModel the table model/*from www. ja v a 2s. c o m*/ * @return a file to a spreadsheet */ public static File convertToExcel(final File toFile, final String title, final TableModel tableModel) { if (toFile == null) { UIRegistry.showLocalizedMsg("WARNING", "FILE_NO_EXISTS", toFile != null ? toFile.getAbsolutePath() : ""); return null; } if (tableModel != null && tableModel.getRowCount() > 0) { try { // create a new file FileOutputStream out; try { out = new FileOutputStream(toFile); } catch (FileNotFoundException ex) { UIRegistry.showLocalizedMsg("WARNING", "FILE_NO_WRITE", toFile != null ? toFile.getAbsolutePath() : ""); return null; } // create a new workbook HSSFWorkbook wb = new HSSFWorkbook(); // create a new sheet HSSFSheet sheet = wb.createSheet(); // declare a row object reference // Header Captions HSSFFont headerFont = wb.createFont(); headerFont.setFontHeightInPoints((short) 12); headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); // create a style for the header cell HSSFCellStyle headerStyle = wb.createCellStyle(); headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); headerStyle.setFont(headerFont); setBordersOnStyle(headerStyle, HSSFColor.GREY_25_PERCENT.index, HSSFCellStyle.BORDER_THIN); short numColumns = (short) tableModel.getColumnCount(); HSSFRow headerRow = sheet.createRow(0); for (int i = 0; i < numColumns; i++) { HSSFCell headerCell = headerRow.createCell((short) i); headerCell.setCellStyle(headerStyle); //add the date to the header cell headerCell.setCellValue(tableModel.getColumnName(i)); sheet.setColumnWidth((short) i, (short) (30 * 256)); } //-------------------------- // done header //-------------------------- // create 3 cell styles HSSFCellStyle oddCellStyle = wb.createCellStyle(); HSSFCellStyle evenCellStyle = wb.createCellStyle(); setBordersOnStyle(oddCellStyle, HSSFColor.GREY_25_PERCENT.index, HSSFCellStyle.BORDER_THIN); setBordersOnStyle(evenCellStyle, HSSFColor.GREY_25_PERCENT.index, HSSFCellStyle.BORDER_THIN); // create 2 fonts objects HSSFFont cellFont = wb.createFont(); //set font 1 to 12 point type cellFont.setFontHeightInPoints((short) 11); oddCellStyle.setFont(cellFont); evenCellStyle.setFont(cellFont); evenCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); oddCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); oddCellStyle.setFillForegroundColor(HSSFColor.WHITE.index); evenCellStyle.setFillForegroundColor(HSSFColor.LIGHT_CORNFLOWER_BLUE.index); oddCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); evenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // set the sheet name to HSSF Test wb.setSheetName(0, title); for (short rownum = 0; rownum < (short) tableModel.getRowCount(); rownum++) { // create a row HSSFRow row = sheet.createRow(rownum + 1); for (short cellnum = (short) 0; cellnum < numColumns; cellnum++) { // create a numeric cell HSSFCell cell = row.createCell(cellnum); Object dataVal = tableModel.getValueAt(rownum, cellnum); cell.setCellValue(dataVal != null ? dataVal.toString() : ""); // on every other row cell.setCellStyle((rownum % 2) == 0 ? evenCellStyle : oddCellStyle); } } // write the workbook to the output stream // close our file (don't blow out our file handles wb.write(out); out.close(); } catch (Exception ex) { edu.ku.brc.af.core.UsageTracker.incrHandledUsageCount(); edu.ku.brc.exceptions.ExceptionTracker.getInstance().capture(TableModel2Excel.class, ex); log.error("convertToExcel", ex); //$NON-NLS-1$ } } return toFile; }
From source file:edu.ku.brc.specify.tasks.subpane.wb.XLSExport.java
License:Open Source License
public void writeData(final List<?> data) throws Exception { HSSFWorkbook workBook = new HSSFWorkbook(); HSSFSheet workSheet = workBook.createSheet(); DocumentSummaryInformation mappings = null; int rowNum = 0; if (config.getFirstRowHasHeaders() && !config.getAppendData()) { writeHeaders(workSheet);/*from w w w .j ava 2 s . c o m*/ rowNum++; String[] headers = config.getHeaders(); for (int i = 0; i < headers.length; i++) { workSheet.setColumnWidth(i, StringUtils.isNotEmpty(headers[i]) ? (256 * headers[i].length()) : 2560); } WorkbenchTemplate wbTemplate = null; if (data.get(0) instanceof WorkbenchTemplate) { wbTemplate = (WorkbenchTemplate) data.get(0); } else { wbTemplate = ((WorkbenchRow) data.get(0)).getWorkbench().getWorkbenchTemplate(); } mappings = writeMappings(wbTemplate); } //assuming data is never empty. boolean hasTemplate = data.get(0) instanceof WorkbenchTemplate; boolean hasRows = hasTemplate ? data.size() > 1 : data.size() > 0; if (hasRows) { int[] disciplinees; WorkbenchRow wbRow = (WorkbenchRow) data.get(hasTemplate ? 1 : 0); Workbench workBench = wbRow.getWorkbench(); WorkbenchTemplate template = workBench.getWorkbenchTemplate(); int numCols = template.getWorkbenchTemplateMappingItems().size(); int geoDataCol = -1; Vector<Integer> imgCols = new Vector<Integer>(); disciplinees = bldColTypes(template); for (Object rowObj : data) { if (rowObj instanceof WorkbenchTemplate) { continue; } WorkbenchRow row = (WorkbenchRow) rowObj; HSSFRow hssfRow = workSheet.createRow(rowNum++); int colNum; boolean rowHasGeoData = false; for (colNum = 0; colNum < numCols; colNum++) { HSSFCell cell = hssfRow.createCell(colNum); cell.setCellType(disciplinees[colNum]); setCellValue(cell, row.getData(colNum)); } if (row.getBioGeomancerResults() != null && !row.getBioGeomancerResults().equals("")) { geoDataCol = colNum; rowHasGeoData = true; HSSFCell cell = hssfRow.createCell(colNum++); cell.setCellType(HSSFCell.CELL_TYPE_STRING); setCellValue(cell, row.getBioGeomancerResults()); } // if (row.getCardImage() != null) if (row.getRowImage(0) != null) { if (!rowHasGeoData) { colNum++; } int imgIdx = 0; WorkbenchRowImage img = row.getRowImage(imgIdx++); while (img != null) { if (imgCols.indexOf(colNum) < 0) { imgCols.add(colNum); } HSSFCell cell = hssfRow.createCell(colNum++); cell.setCellType(HSSFCell.CELL_TYPE_STRING); String cellValue = img.getCardImageFullPath(); String attachToTbl = img.getAttachToTableName(); if (attachToTbl != null) { cellValue += "\t" + attachToTbl; } setCellValue(cell, cellValue); img = row.getRowImage(imgIdx++); } } } if (imgCols.size() > 0 || geoDataCol != -1) { writeExtraHeaders(workSheet, imgCols, geoDataCol); } } try { // Write the workbook File file = new File(getConfig().getFileName()); if (file.canWrite() || (!file.exists() && file.createNewFile())) { FileOutputStream fos = new FileOutputStream(file); workBook.write(fos); fos.close(); //Now write the mappings. //NOT (hopefully) the best way to write the mappings, but (sadly) the easiest way. //May need to do this another way if this slows performance for big wbs. if (mappings != null) { InputStream is = new FileInputStream(file); POIFSFileSystem poifs = new POIFSFileSystem(is); is.close(); mappings.write(poifs.getRoot(), DocumentSummaryInformation.DEFAULT_STREAM_NAME); fos = new FileOutputStream(file); poifs.writeFilesystem(fos); fos.close(); } } else { UIRegistry.displayErrorDlgLocalized("WB_EXPORT_PERM_ERR"); } } catch (Exception e) { edu.ku.brc.af.core.UsageTracker.incrHandledUsageCount(); edu.ku.brc.exceptions.ExceptionTracker.getInstance().capture(XLSExport.class, e); throw (e); } }
From source file:edu.tum.cs.conqat.quamoco.ExcelUtils.java
License:Apache License
/** Creates a new Workbook with a sheet */ public static HSSFSheet createSheet() { HSSFWorkbook workbook = new HSSFWorkbook(); return workbook.createSheet(); }
From source file:egovframework.rte.fdl.excel.EgovExcelSXSSFServiceTest.java
License:Apache License
/** * [Flow #-4] ? : ? ? ?(Header, Footer)? *///from w w w . j a v a 2 s.com @Test public void testModifyDocAttribute() throws Exception { try { log.debug("testModifyDocAttribute start...."); StringBuffer sb = new StringBuffer(); sb.append(fileLocation).append("/").append("testModifyDocAttribute.xls"); if (EgovFileUtil.isExistsFile(sb.toString())) { EgovFileUtil.delete(new File(sb.toString())); log.debug("Delete file...." + sb.toString()); } HSSFWorkbook wbTmp = new HSSFWorkbook(); wbTmp.createSheet(); // ? ? excelService.createWorkbook(wbTmp, sb.toString()); // ? HSSFWorkbook wb = excelService.loadWorkbook(sb.toString()); log.debug("testModifyCellContents after loadWorkbook...."); HSSFSheet sheet = wb.createSheet("doc test sheet"); HSSFRow row = sheet.createRow(1); HSSFCell cell = row.createCell(1); cell.setCellValue(new HSSFRichTextString("Header/Footer Test")); // Header HSSFHeader header = sheet.getHeader(); header.setCenter("Center Header"); header.setLeft("Left Header"); header.setRight(HSSFHeader.font("Stencil-Normal", "Italic") + HSSFHeader.fontSize((short) 16) + "Right Stencil-Normal Italic font and size 16"); // Footer HSSFFooter footer = sheet.getFooter(); footer.setCenter(HSSFHeader.font("Fixedsys", "Normal") + HSSFHeader.fontSize((short) 12) + "- 1 -"); log.debug("Style is ... " + HSSFHeader.font("Fixedsys", "Normal") + HSSFHeader.fontSize((short) 12) + "- 1 -"); footer.setLeft("Left Footer"); footer.setRight("Right Footer"); // ? FileOutputStream out = new FileOutputStream(sb.toString()); wb.write(out); out.close(); assertTrue(EgovFileUtil.isExistsFile(sb.toString())); ////////////////////////////////////////////////////////////////////////// // ? HSSFWorkbook wbT = excelService.loadWorkbook(sb.toString()); HSSFSheet sheetT = wbT.getSheet("doc test sheet"); HSSFHeader headerT = sheetT.getHeader(); assertEquals("Center Header", headerT.getCenter()); assertEquals("Left Header", headerT.getLeft()); assertEquals(HSSFHeader.font("Stencil-Normal", "Italic") + HSSFHeader.fontSize((short) 16) + "Right Stencil-Normal Italic font and size 16", headerT.getRight()); HSSFFooter footerT = sheetT.getFooter(); assertEquals("Right Footer", footerT.getRight()); assertEquals("Left Footer", footerT.getLeft()); assertEquals(HSSFHeader.font("Fixedsys", "Normal") + HSSFHeader.fontSize((short) 12) + "- 1 -", footerT.getCenter()); } catch (Exception e) { log.error(e.toString()); throw new Exception(e); } finally { log.debug("testModifyDocAttribute end...."); } }
From source file:egovframework.rte.fdl.excel.EgovExcelSXSSFServiceTest.java
License:Apache License
/** * [Flow #-5] : ?? ? ? ? //from w ww.j av a2s. c o m */ @Test public void testGetCellContents() throws Exception { try { log.debug("testGetCellContents start...."); StringBuffer sb = new StringBuffer(); sb.append(fileLocation).append("/").append("testGetCellContents.xls"); if (EgovFileUtil.isExistsFile(sb.toString())) { EgovFileUtil.delete(new File(sb.toString())); log.debug("Delete file...." + sb.toString()); } HSSFWorkbook wbTmp = new HSSFWorkbook(); wbTmp.createSheet(); // ? ? excelService.createWorkbook(wbTmp, sb.toString()); // ? HSSFWorkbook wb = excelService.loadWorkbook(sb.toString()); log.debug("testGetCellContents after loadWorkbook...."); HSSFSheet sheet = wb.createSheet("cell test sheet"); HSSFCellStyle cs = wb.createCellStyle(); cs = wb.createCellStyle(); cs.setWrapText(true); for (int i = 0; i < 100; i++) { HSSFRow row = sheet.createRow(i); for (int j = 0; j < 5; j++) { HSSFCell cell = row.createCell(j); cell.setCellValue(new HSSFRichTextString("row " + i + ", cell " + j)); cell.setCellStyle(cs); } } // ? FileOutputStream out = new FileOutputStream(sb.toString()); wb.write(out); out.close(); ////////////////////////////////////////////////////////////////////////// // ? HSSFWorkbook wbT = excelService.loadWorkbook(sb.toString()); HSSFSheet sheetT = wbT.getSheet("cell test sheet"); for (int i = 0; i < 100; i++) { HSSFRow row1 = sheetT.getRow(i); for (int j = 0; j < 5; j++) { HSSFCell cell1 = row1.getCell(j); log.debug("row " + i + ", cell " + j + " : " + cell1.getRichStringCellValue()); assertEquals("row " + i + ", cell " + j, cell1.getRichStringCellValue().toString()); } } } catch (Exception e) { log.error(e.toString()); throw new Exception(e); } finally { log.debug("testGetCellContents end...."); } }
From source file:egovframework.rte.fdl.excel.EgovExcelSXSSFServiceTest.java
License:Apache License
/** * [Flow #-6] ? : ? ?(?, ? )? /*from w w w . ja v a2 s . c o m*/ */ @Test public void testModifyCellAttribute() throws Exception { try { log.debug("testModifyCellAttribute start...."); StringBuffer sb = new StringBuffer(); sb.append(fileLocation).append("/").append("testModifyCellAttribute.xls"); if (EgovFileUtil.isExistsFile(sb.toString())) { EgovFileUtil.delete(new File(sb.toString())); log.debug("Delete file...." + sb.toString()); } HSSFWorkbook wbTmp = new HSSFWorkbook(); wbTmp.createSheet(); // ? ? excelService.createWorkbook(wbTmp, sb.toString()); // ? HSSFWorkbook wb = excelService.loadWorkbook(sb.toString()); log.debug("testModifyCellAttribute after loadWorkbook...."); HSSFSheet sheet = wb.createSheet("cell test sheet2"); // sheet.setColumnWidth((short) 3, (short) 200); // column Width HSSFCellStyle cs = wb.createCellStyle(); HSSFFont font = wb.createFont(); font.setFontHeight((short) 16); font.setBoldweight((short) 3); font.setFontName("fixedsys"); cs.setFont(font); cs.setAlignment(HSSFCellStyle.ALIGN_RIGHT); // cell cs.setWrapText(true); for (int i = 0; i < 100; i++) { HSSFRow row = sheet.createRow(i); // row.setHeight((short)300); // row? height for (int j = 0; j < 5; j++) { HSSFCell cell = row.createCell(j); cell.setCellValue(new HSSFRichTextString("row " + i + ", cell " + j)); cell.setCellStyle(cs); } } // ? FileOutputStream out = new FileOutputStream(sb.toString()); wb.write(out); out.close(); ////////////////////////////////////////////////////////////////////////// // ? HSSFWorkbook wbT = excelService.loadWorkbook(sb.toString()); HSSFSheet sheetT = wbT.getSheet("cell test sheet2"); log.debug("getNumCellStyles : " + wbT.getNumCellStyles()); HSSFCellStyle cs1 = wbT.getCellStyleAt((short) (wbT.getNumCellStyles() - 1)); HSSFFont fontT = cs1.getFont(wbT); log.debug("font getFontHeight : " + fontT.getFontHeight()); log.debug("font getBoldweight : " + fontT.getBoldweight()); log.debug("font getFontName : " + fontT.getFontName()); log.debug("getAlignment : " + cs1.getAlignment()); log.debug("getWrapText : " + cs1.getWrapText()); for (int i = 0; i < 100; i++) { HSSFRow row1 = sheetT.getRow(i); for (int j = 0; j < 5; j++) { HSSFCell cell1 = row1.getCell(j); log.debug("row " + i + ", cell " + j + " : " + cell1.getRichStringCellValue()); assertEquals(16, fontT.getFontHeight()); assertEquals(3, fontT.getBoldweight()); assertEquals(HSSFCellStyle.ALIGN_RIGHT, cs1.getAlignment()); assertTrue(cs1.getWrapText()); } } } catch (Exception e) { log.error(e.toString()); throw new Exception(e); } finally { log.debug("testModifyCellAttribute end...."); } }
From source file:eu.itesla_project.entsoe.util.BoundaryPointXlsParserTest.java
License:Mozilla Public License
private HSSFWorkbook createWorkbook() { HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(); // Add dummy lines sheet.createRow(0).createCell(0).setCellValue("First dummy row"); sheet.createRow(1).createCell(0).setCellValue("Second dummy row"); HSSFRow row = sheet.createRow(2);/*from w w w.j a va 2s . c om*/ row.createCell(13).setCellValue("BoundaryPoint FR-BE"); row.createCell(14).setCellValue("France"); row.createCell(15).setCellValue("Belgium"); return workbook; }