List of usage examples for org.apache.poi.ss.usermodel Sheet getSheetName
String getSheetName();
From source file:no.hild1.bank.KonverterMottagerregister.java
License:Apache License
private boolean convertToXML() throws InvalidFormatException { Sheet sheet = null; System.out.println("Starter konvertering til SDC XML"); int numSheets = this.workbook.getNumberOfSheets(); boolean foundAtleastOneValid = false; for (int i = 0; i < numSheets; i++) { sheet = this.workbook.getSheetAt(i); String name = sheet.getSheetName(); if (name.contains("innland")) { System.out.println("Fant innland-regneark, prosesserer"); foundAtleastOneValid = true; this.processInnland(sheet); } else if (name.contains("utland")) { System.out.println("Fant utland-regneark, vet ikke hvordan dette prosesseres"); } else {/*from ww w . j a va 2s .co m*/ System.out.println("Fant ukjent regneark: " + name + ", ignorerer"); } } if (!foundAtleastOneValid) { throw new InvalidFormatException( "Fant ikke innland-regneark, ingen output laget. (utland-konvertering stttes ikke atm.)"); } return true; }
From source file:no.hild1.excelsplit.ES.java
private boolean splitWorkbook() throws InvalidFormatException, IOException { Sheet sheet = null; System.out.println("Starter splitting av fil"); int numSheets = this.inputWorkbook.getNumberOfSheets(); boolean foundAtleastOneValid = false; for (int i = 0; i < numSheets; i++) { sheet = this.inputWorkbook.getSheetAt(i); String name = sheet.getSheetName(); if (name.contains("Ark1")) { System.out.println("Fant Ark1, prosesserer"); foundAtleastOneValid = true; processSheet(sheet);//from w w w . j ava 2s . c o m System.out.println("Finished prosessing."); } else { System.out.println("Fant ukjent regneark: " + name + ", ignorerer"); } } if (!foundAtleastOneValid) { throw new InvalidFormatException( "Fant ikke innland-regneark, ingen output laget. (utland-konvertering stttes ikke atm.)"); } return true; }
From source file:org.alanwilliamson.openbd.plugin.spreadsheet.cfSpreadSheetData.java
License:Open Source License
public void setActiveSheet(int sheetNo) { Sheet sheet = workbook.getSheetAt(sheetNo); if (sheet != null) { workbook.setActiveSheet(sheetNo); workbook.setSelectedTab(sheetNo); activeSheetName = sheet.getSheetName(); activeSheetObj = sheet;//www .j a v a 2 s. c om } }
From source file:org.aludratest.app.excelwizard.WorkbookTracker.java
License:Apache License
private int haveColumnWithHeader(String header, Sheet sheet, int insertionIndex) { addExpectedHeader(header, sheet.getSheetName()); Row headerRow = sheet.getRow(0);//from w w w . ja v a2 s . co m int existingColumnIndex = ExcelUtil.findCellWithText(header, headerRow); if (existingColumnIndex >= 0) { return existingColumnIndex; } else { insertColumn(header, sheet, insertionIndex, Cell.CELL_TYPE_STRING); return insertionIndex; } }
From source file:org.apache.any23.plugin.officescraper.ExcelExtractor.java
License:Apache License
private void writeSheetMetadata(URI sheetURI, Sheet sheet, ExtractionResult er) { final String sheetName = sheet.getSheetName(); final int firstRowNum = sheet.getFirstRowNum(); final int lastRowNum = sheet.getLastRowNum(); er.writeTriple(sheetURI, excel.sheetName, RDFUtils.literal(sheetName)); er.writeTriple(sheetURI, excel.firstRow, RDFUtils.literal(firstRowNum)); er.writeTriple(sheetURI, excel.lastRow, RDFUtils.literal(lastRowNum)); }
From source file:org.apache.any23.plugin.officescraper.ExcelExtractor.java
License:Apache License
private URI getSheetURI(URI documentURI, Sheet sheet) { return RDFUtils.uri(documentURI.toString() + "/sheet/" + sheet.getSheetName()); }
From source file:org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegate.java
License:Apache License
private MutableTable createTable(final Workbook wb, final Sheet sheet) { final MutableTable table = new MutableTable(sheet.getSheetName()); if (sheet.getPhysicalNumberOfRows() <= 0) { // no physical rows in sheet return table; }/*from ww w . j ava 2 s. c o m*/ final Iterator<Row> rowIterator = ExcelUtils.getRowIterator(sheet, _configuration, false); if (!rowIterator.hasNext()) { // no physical rows in sheet return table; } Row row = null; if (_configuration.isSkipEmptyLines()) { while (row == null && rowIterator.hasNext()) { row = rowIterator.next(); } } else { row = rowIterator.next(); } final int columnNameLineNumber = _configuration.getColumnNameLineNumber(); if (columnNameLineNumber == ExcelConfiguration.NO_COLUMN_NAME_LINE) { // get to the first non-empty line (no matter if lines are skipped // or not we need to read ahead to figure out how many columns there // are!) while (row == null && rowIterator.hasNext()) { row = rowIterator.next(); } // build columns without any intrinsic column names final ColumnNamingStrategy columnNamingStrategy = _configuration.getColumnNamingStrategy(); try (final ColumnNamingSession columnNamingSession = columnNamingStrategy.startColumnNamingSession()) { final int offset = getColumnOffset(row); for (int i = 0; i < offset; i++) { columnNamingSession.getNextColumnName(new ColumnNamingContextImpl(i)); } for (int j = offset; j < row.getLastCellNum(); j++) { final ColumnNamingContext namingContext = new ColumnNamingContextImpl(table, null, j); final Column column = new MutableColumn(columnNamingSession.getNextColumnName(namingContext), ColumnType.STRING, table, j, true); table.addColumn(column); } } } else { boolean hasColumns = true; // iterate to the column name line number (if above 1) for (int j = 1; j < columnNameLineNumber; j++) { if (rowIterator.hasNext()) { row = rowIterator.next(); } else { hasColumns = false; break; } } if (hasColumns) { createColumns(table, wb, row); } } return table; }
From source file:org.apache.metamodel.excel.ExcelUpdateCallback.java
License:Apache License
private int getLastRowNum(Sheet sheet) { final int lastRowNum = sheet.getLastRowNum(); if (lastRowNum == 0 && sheet instanceof SXSSFSheet) { // streaming sheets have bad behaviour in this scenario - since no // rows are in cache, it will return 0! DataSet ds = _dataContext.query().from(sheet.getSheetName()).selectCount().execute(); ds.next();/*from w w w .ja v a2 s .c o m*/ final Number count = (Number) ds.getRow().getValue(0); final int columnNameLineNumber = _configuration.getColumnNameLineNumber(); int oneBasedResult = count.intValue() + (columnNameLineNumber == ExcelConfiguration.NO_COLUMN_NAME_LINE ? 0 : columnNameLineNumber); return oneBasedResult - 1; } return lastRowNum; }
From source file:org.bbreak.excella.reports.processor.ReportProcessor.java
License:Open Source License
/** * ???????//from w w w . j av a2s .co m * * @param workbook * @param reportBook * @return ????? */ private Set<String> expandTemplate(Workbook workbook, ReportBook reportBook) { Set<String> delSheetNames = new TreeSet<String>(Collections.reverseOrder()); Set<String> useSheetNames = new HashSet<String>(); // ???? for (ReportSheet reportSheet : reportBook.getReportSheets()) { if (reportSheet != null) { if (reportSheet.getSheetName().equals(reportSheet.getTemplateName())) { // ????? int lastSheetIndex = workbook.getNumberOfSheets() - 1; workbook.setSheetOrder(reportSheet.getSheetName(), lastSheetIndex); useSheetNames.add(reportSheet.getTemplateName()); } else { int tempIdx = workbook.getSheetIndex(reportSheet.getTemplateName()); Sheet sheet = workbook.cloneSheet(tempIdx); ReportsUtil.copyPrintSetup(workbook, tempIdx, sheet); workbook.setSheetName(workbook.getSheetIndex(sheet), reportSheet.getSheetName()); delSheetNames.add(reportSheet.getTemplateName()); } } } // ? for (int i = 0; i < workbook.getNumberOfSheets(); i++) { Sheet sheet = workbook.getSheetAt(i); if (!isOutputSheet(sheet, reportBook)) { delSheetNames.add(sheet.getSheetName()); } } delSheetNames.removeAll(useSheetNames); // ????? return delSheetNames; }
From source file:org.bbreak.excella.reports.processor.ReportProcessor.java
License:Open Source License
/** * ???/*from w w w . j av a 2 s. c o m*/ * * @param sheet * @param reportBook * @return */ private boolean isOutputSheet(Sheet sheet, ReportBook reportBook) { for (ReportSheet reportSheet : reportBook.getReportSheets()) { if (reportSheet != null && sheet.getSheetName().equals(reportSheet.getSheetName())) { return true; } } return false; }