本文整理了Java中org.apache.poi.ss.usermodel.Sheet.getPhysicalNumberOfRows()方法的一些代码示例，展示了Sheet.getPhysicalNumberOfRows()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Sheet.getPhysicalNumberOfRows()方法的具体详情如下：
包路径：org.apache.poi.ss.usermodel.Sheet
类名称：Sheet
方法名：getPhysicalNumberOfRows

Sheet.getPhysicalNumberOfRows介绍

[英]Returns the number of physically defined rows (NOT the number of rows in the sheet)
[中]返回物理定义的行数（而不是工作表中的行数）

代码示例

代码示例来源：origin: looly/hutool

/**
 * 
 * sheet是否为空
 * 
 * @param sheet {@link Sheet}
 * @return sheet是否为空
 * @since 4.0.1
 */
public static boolean isEmpty(Sheet sheet) {
  return null == sheet || (sheet.getLastRowNum() == 0 && sheet.getPhysicalNumberOfRows() == 0);
}

代码示例来源：origin: looly/hutool

/**
 * 
 * sheet是否为空
 * 
 * @param sheet {@link Sheet}
 * @return sheet是否为空
 * @since 4.0.1
 */
public static boolean isEmpty(Sheet sheet) {
  return null == sheet || (sheet.getLastRowNum() == 0 && sheet.getPhysicalNumberOfRows() == 0);
}

代码示例来源：origin: zstackio/zstack

public ExcelReader(String base64Content) {
  byte[] decoded = Base64.getDecoder().decode(base64Content);
  InputStream input = new ByteArrayInputStream(decoded);
  try {
    Workbook workbook = WorkbookFactory.create(input);
    if (workbook.getNumberOfSheets() == 0) {
      workbook.createSheet();
    }
    sheet = workbook.getSheetAt(0);
    header = sheet.getPhysicalNumberOfRows() == 0 ? null : readRow(0);
  } catch (IOException | InvalidFormatException e) {
    throw new IllegalArgumentException(e);
  }
}

代码示例来源：origin: pentaho/pentaho-kettle

if ( data.sheet.getPhysicalNumberOfRows() > 0 ) {
 data.posY = data.sheet.getLastRowNum();
 data.posY++;

代码示例来源：origin: org.tinygroup/org.tinygroup.tinyscript.excel

private void checkValidate() throws Exception {
  if (sheet == null || sheet.getPhysicalNumberOfRows() < 1) {
    throw new Exception("没有数据存在，无法移动到第一行！");
  }
}

代码示例来源：origin: org.apache.poi/poi-examples

private void compareDataInSheet(Locator loc1, Locator loc2) {
  for (int j = 0; j < loc1.sheet.getPhysicalNumberOfRows(); j++) {
    if (loc2.sheet.getPhysicalNumberOfRows() <= j) return;
    loc1.row = loc1.sheet.getRow(j);
    loc2.row = loc2.sheet.getRow(j);
    if ((loc1.row == null) || (loc2.row == null)) {
      continue;
    }
    compareDataInRow(loc1, loc2);
  }
}

代码示例来源：origin: cn.hutool/hutool-all

/**
 * 
 * sheet是否为空
 * 
 * @param sheet {@link Sheet}
 * @return sheet是否为空
 * @since 4.0.1
 */
public static boolean isEmpty(Sheet sheet) {
  return null == sheet || (sheet.getLastRowNum() == 0 && sheet.getPhysicalNumberOfRows() == 0);
}

代码示例来源：origin: org.paxml/paxml-core

@Override
public int getRowCount() {
  if (compact) {
    return sheet.getPhysicalNumberOfRows();
  } else {
    return sheet.getLastRowNum() + 1;
  }
}

代码示例来源：origin: org.paxml/PaxmlCore

@Override
public int getRowCount() {
  if (compact) {
    return sheet.getPhysicalNumberOfRows();
  } else {
    return sheet.getLastRowNum() + 1;
  }
}

代码示例来源：origin: org.tinygroup/org.tinygroup.tinyscript.excel

public int getRows() throws Exception {
  checkValidate();
  return sheet.getPhysicalNumberOfRows();
}

代码示例来源：origin: com.gitee.zhaohuihua/zhh-tools

private static Row getOrCreateRow(Sheet sheet, int index) {
  if (index < sheet.getPhysicalNumberOfRows()) {
    Row row = sheet.getRow(index);
    return row != null ? row : sheet.createRow(index);
  } else {
    return sheet.createRow(index);
  }
}

代码示例来源：origin: cpesch/RouteConverter

private void parseSheet(Sheet sheet, ParserContext<ExcelRoute> context) {
  if (sheet.getPhysicalNumberOfRows() < 2)
    return;
  Row header = sheet.getRow(0);
  log.info(format("Parsing sheet '%s' with %d rows and %d columns", sheet.getSheetName(), sheet.getPhysicalNumberOfRows(), header.getPhysicalNumberOfCells()));
  ColumnTypeToRowIndexMapping mapping = parseHeader(header);
  List<ExcelPosition> positions = new ArrayList<>();
  for (int i = 1, c = sheet.getPhysicalNumberOfRows(); i < c; i++) {
    Row row = sheet.getRow(i);
    // in case there is just a formatting in a line, the row is null
    if (row != null)
      positions.add(new ExcelPosition(row, mapping));
  }
  context.appendRoute(new ExcelRoute(this, sheet, mapping, positions));
}

代码示例来源：origin: org.apache.metamodel/MetaModel-excel

@Override
public DataSet executeQuery(Table table, List<Column> columns, int maxRows) {
  final Workbook wb = ExcelUtils.readWorkbook(_resource, true);
  final Sheet sheet = wb.getSheet(table.getName());
  if (sheet == null || sheet.getPhysicalNumberOfRows() == 0) {
    return new EmptyDataSet(columns.stream().map(SelectItem::new).collect(Collectors.toList()));
  }
  DataSet dataSet = ExcelUtils.getDataSet(wb, sheet, table, _configuration);
  if (maxRows > 0) {
    dataSet = new MaxRowsDataSet(dataSet, maxRows);
  }
  return dataSet;
}

代码示例来源：origin: apache/metamodel

@Override
public DataSet executeQuery(Table table, List<Column> columns, int maxRows) {
  final Workbook wb = ExcelUtils.readWorkbook(_resource, true);
  final Sheet sheet = wb.getSheet(table.getName());
  if (sheet == null || sheet.getPhysicalNumberOfRows() == 0) {
    return new EmptyDataSet(columns.stream().map(SelectItem::new).collect(Collectors.toList()));
  }
  DataSet dataSet = ExcelUtils.getDataSet(wb, sheet, table, _configuration);
  if (maxRows > 0) {
    dataSet = new MaxRowsDataSet(dataSet, maxRows);
  }
  return dataSet;
}

代码示例来源：origin: tobyweston/simple-excel

private static org.apache.poi.ss.usermodel.Row createRow(Sheet sheet) {
  if (sheet.getPhysicalNumberOfRows() == 0)
    return sheet.createRow(0);
  return sheet.createRow(sheet.getLastRowNum() + 1);
}

代码示例来源：origin: stackoverflow.com

public void autoSizeColumns(Workbook workbook) {
  int numberOfSheets = workbook.getNumberOfSheets();
  for (int i = 0; i < numberOfSheets; i++) {
    Sheet sheet = workbook.getSheetAt(i);
    if (sheet.getPhysicalNumberOfRows() > 0) {
      Row row = sheet.getRow(0);
      Iterator<Cell> cellIterator = row.cellIterator();
      while (cellIterator.hasNext()) {
        Cell cell = cellIterator.next();
        int columnIndex = cell.getColumnIndex();
        sheet.autoSizeColumn(columnIndex);
      }
    }
  }
}

代码示例来源：origin: ozlerhakan/poiji

@Override
public <T> void unmarshal(Class<T> type, Consumer<? super T> consumer) {
  Workbook workbook = workbook();
  Sheet sheet = this.getSheetToProcess(workbook, options);
  int skip = options.skip();
  int maxPhysicalNumberOfRows = sheet.getPhysicalNumberOfRows() + 1 - skip;
  loadColumnTitles(sheet, maxPhysicalNumberOfRows);
  for (Row currentRow : sheet) {
    if (!skip(currentRow, skip) && !isRowEmpty(currentRow)) {
      T t = deserialize0(currentRow, type);
      consumer.accept(t);
    }
  }
}

代码示例来源：origin: org.eobjects.metamodel/MetaModel-excel

@Override
public DataSet executeQuery(InputStream inputStream, Table table, Column[] columns, int maxRows) {
  final Workbook wb = ExcelUtils.readWorkbook(inputStream);
  final Sheet sheet = wb.getSheet(table.getName());
  if (sheet == null || sheet.getPhysicalNumberOfRows() == 0) {
    return new EmptyDataSet(columns);
  }
  DataSet dataSet = ExcelUtils.getDataSet(wb, sheet, table, _configuration);
  if (maxRows > 0) {
    dataSet = new MaxRowsDataSet(dataSet, maxRows);
  }
  return dataSet;
}

代码示例来源：origin: org.primefaces.extensions/primefaces-extensions

protected void addColumnFacets(final SubTable table, final Sheet sheet, final ColumnType columnType) {
  final int sheetRowIndex = sheet.getPhysicalNumberOfRows() > 0 ? sheet.getLastRowNum() + 1 : 0;
  final Row rowHeader = sheet.createRow(sheetRowIndex);
  for (final UIColumn col : table.getColumns()) {
    if (col instanceof DynamicColumn) {
      ((DynamicColumn) col).applyStatelessModel();
    }
    if (col.isRendered() && col.isExportable()) {
      addColumnValue(rowHeader, col.getFacet(columnType.facet()), "facet");
    }
  }
}

代码示例来源：origin: org.geoserver.extension/excel

private void testMultipleFeatureTypes( Workbook wb ) throws IOException{
    // check we have the expected sheets
    Sheet sheet = wb.getSheet("PrimitiveGeoFeature");
    assertNotNull(sheet);

    // check the number of rows in the output
    FeatureSource fs = getFeatureSource(MockData.PRIMITIVEGEOFEATURE);
    assertEquals(fs.getCount(Query.ALL) + 1, sheet.getPhysicalNumberOfRows());

    sheet = wb.getSheet("GenericEntity");
    assertNotNull(sheet);

    // check the number of rows in the output
    fs = getFeatureSource(MockData.GENERICENTITY);
    assertEquals(fs.getCount(Query.ALL) + 1, sheet.getPhysicalNumberOfRows());    	
  }
}