List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook getNumberOfSheets
@Override public int getNumberOfSheets()
From source file:uk.co.spudsoft.birt.emitters.excel.tests.SingleSheetsReportTest.java
License:Open Source License
@Test public void testTwoNames() throws BirtException, IOException { InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsTwoNames.rptdesign", "xlsx"); assertNotNull(inputStream);/*from w w w . ja v a2s . c o m*/ try { XSSFWorkbook workbook = new XSSFWorkbook(inputStream); assertNotNull(workbook); assertEquals(1, workbook.getNumberOfSheets()); assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName()); assertEquals(11, firstNullRow(workbook.getSheetAt(0))); } finally { inputStream.close(); } }
From source file:uk.co.spudsoft.birt.emitters.excel.tests.SingleSheetsReportTest.java
License:Open Source License
@Test public void testBigTableDefaultInterval() throws BirtException, IOException { InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsBigTableFortyInterval.rptdesign", "xlsx"); assertNotNull(inputStream);/*from w ww . j a v a 2s . co m*/ try { XSSFWorkbook workbook = new XSSFWorkbook(inputStream); assertNotNull(workbook); assertEquals(1, workbook.getNumberOfSheets()); assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName()); assertEquals(196, firstNullRow(workbook.getSheetAt(0))); } finally { inputStream.close(); } }
From source file:uk.co.spudsoft.birt.emitters.excel.tests.SingleSheetsReportTest.java
License:Open Source License
@Test public void testBigTableZeroIntervalWithPagination() throws BirtException, IOException { htmlPagination = true;/*w w w. ja v a 2s .c o m*/ InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsBigTableZeroInterval.rptdesign", "xlsx"); assertNotNull(inputStream); try { XSSFWorkbook workbook = new XSSFWorkbook(inputStream); assertNotNull(workbook); assertEquals(1, workbook.getNumberOfSheets()); assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName()); assertEquals(196, firstNullRow(workbook.getSheetAt(0))); } finally { inputStream.close(); } }
From source file:uk.co.spudsoft.birt.emitters.excel.tests.WrapTest.java
License:Open Source License
@Test public void testRunReport() throws BirtException, IOException { InputStream inputStream = runAndRenderReport("Wrap.rptdesign", "xlsx"); assertNotNull(inputStream);/* w w w .j a v a 2 s. c om*/ try { XSSFWorkbook workbook = new XSSFWorkbook(inputStream); assertNotNull(workbook); assertEquals(4, workbook.getNumberOfSheets()); assertEquals("Auto", workbook.getSheetAt(0).getSheetName()); assertEquals("NoWrap", workbook.getSheetAt(1).getSheetName()); assertEquals("Normal", workbook.getSheetAt(2).getSheetName()); assertEquals("Preformatted", workbook.getSheetAt(3).getSheetName()); assertTrue(!workbook.getSheetAt(0).getRow(1).getCell(1).getCellStyle().getWrapText()); assertTrue(workbook.getSheetAt(0).getRow(1).getCell(2).getCellStyle().getWrapText()); assertTrue(!workbook.getSheetAt(1).getRow(1).getCell(1).getCellStyle().getWrapText()); assertTrue(!workbook.getSheetAt(1).getRow(1).getCell(2).getCellStyle().getWrapText()); assertTrue(!workbook.getSheetAt(2).getRow(1).getCell(1).getCellStyle().getWrapText()); assertTrue(workbook.getSheetAt(2).getRow(1).getCell(2).getCellStyle().getWrapText()); assertTrue(workbook.getSheetAt(3).getRow(1).getCell(1).getCellStyle().getWrapText()); assertTrue(workbook.getSheetAt(3).getRow(1).getCell(2).getCellStyle().getWrapText()); } finally { inputStream.close(); } }
From source file:ultis.ReadFile.java
private static ArrayList<String> readXlsxFile(String path) throws FileNotFoundException, IOException { ArrayList<String> lines = new ArrayList<>(); // Create file input stream from input file FileInputStream fis = new FileInputStream(path); // Create Workbook instance holding reference to input file XSSFWorkbook workbook = new XSSFWorkbook(fis); // Loop for all sheets for (int i = 0; i < workbook.getNumberOfSheets(); ++i) { XSSFSheet sheet = workbook.getSheetAt(i); // Iterate through each row in input file Iterator<Row> rowIterator = sheet.iterator(); while (rowIterator.hasNext()) { Row row = rowIterator.next(); Iterator<Cell> cellIterator = row.cellIterator(); String line = ""; line += cellIterator.next().getStringCellValue().trim(); line += "|"; line += cellIterator.next().getStringCellValue().trim(); lines.add(line);// w ww .j a v a2 s . co m } } fis.close(); return lines; }
From source file:us.physion.ovation.ui.editor.xls.XLSXReader.java
License:Open Source License
public static void load(File f, LoadHandler handler) throws IOException { try (FileInputStream fis = new FileInputStream(f)) { XSSFWorkbook workbook = new XSSFWorkbook(fis); // for xls HSSFWorkbook for (int i = 0; i < workbook.getNumberOfSheets(); i++) { List<String[]> entries = new ArrayList<>(); Sheet sheet = workbook.getSheetAt(i); for (Row row : sheet) { List<String> rowData = new ArrayList<>(); for (Iterator<Cell> cells = row.cellIterator(); cells.hasNext();) { Cell cell = cells.next(); switch (cell.getCellType()) { case Cell.CELL_TYPE_STRING: rowData.add(cell.getStringCellValue().trim()); break; case Cell.CELL_TYPE_NUMERIC: rowData.add(Double.toString(cell.getNumericCellValue())); break; }/*from www . ja v a 2s .com*/ } entries.add(rowData.toArray(new String[0])); } int columnCount = 0; for (String[] row : entries) { columnCount = Math.max(columnCount, row.length); } entries = reallocEntries(entries, columnCount); TabularData data = new TabularData(entries, getColumnNames(columnCount), f); handler.handle(sheet.getSheetName(), data); } } }
From source file:util.DocumentFunction.java
public static String readXlsxFile(String filename) { StringBuilder text = new StringBuilder(); try {//from w w w. j a va 2s . c o m FileInputStream file = new FileInputStream(new File(filename)); //Create Workbook instance holding reference to .xlsx file XSSFWorkbook workbook = new XSSFWorkbook(file); for (int i = 0; i < workbook.getNumberOfSheets(); i++) { //Get first/desired sheet from the workbook XSSFSheet sheet = workbook.getSheetAt(i); //Iterate through each rows one by one Iterator<Row> rowIterator = sheet.iterator(); while (rowIterator.hasNext()) { Row row = rowIterator.next(); //For each row, iterate through all the columns Iterator<Cell> cellIterator = row.cellIterator(); boolean breakPoint = true; while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); //Check the cell type and format accordingly switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: text.append(cell.getNumericCellValue() + " "); break; case Cell.CELL_TYPE_STRING: text.append(cell.getStringCellValue() + " "); break; case Cell.CELL_TYPE_BLANK: breakPoint = false; break; } } if (breakPoint) { text.append("\n"); } } } file.close(); } catch (Exception e) { e.printStackTrace(); } return text.toString(); }
From source file:util.DocumentFunction.java
public static Map<Boolean, List<ImportedStudent>> readStudentXlsxFile(String filename, int course_id) { // StringBuilder text = new StringBuilder(); Map<Boolean, List<ImportedStudent>> stMap = new TreeMap<>(); List<ImportedStudent> exStudentList = new ArrayList<>(); ImportedStudent st = null;// w ww . ja v a 2 s. c om try { FileInputStream file = new FileInputStream(new File(filename)); //Create Workbook instance holding reference to .xlsx file XSSFWorkbook workbook = new XSSFWorkbook(file); boolean breakPoint = true; for (int i = 0; i < workbook.getNumberOfSheets(); i++) { //Get first/desired sheet from the workbook XSSFSheet sheet = workbook.getSheetAt(i); //Iterate through each rows one by one Iterator<Row> rowIterator = sheet.iterator(); String email = null, firstname = null, lastname = null; while (rowIterator.hasNext()) { Row row = rowIterator.next(); int rownum = row.getRowNum(); //For each row, iterate through all the columns Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (cell.getColumnIndex() == 0) { email = cell.getStringCellValue(); } else if (cell.getColumnIndex() == 1) { firstname = cell.getStringCellValue(); } else if (cell.getColumnIndex() == 2) { lastname = cell.getStringCellValue(); } } if (row.getRowNum() == 0) { if (email.equalsIgnoreCase("Email") && firstname.equalsIgnoreCase("Firstname") && lastname.equalsIgnoreCase("Lastname")) { continue; } else { stMap.put(false, exStudentList); breakPoint = false; break; } } else { st = new ImportedStudent(); st.setCourse_id(course_id); st.setEmail(email); st.setFirstname(firstname); st.setLastname(lastname); exStudentList.add(st); } // System.out.println(email + "/" + firstname + "/" + lastname); } } if (breakPoint) { stMap.put(true, exStudentList); } file.close(); } catch (Exception e) { e.printStackTrace(); } return stMap; }