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

Sheet.rowIterator介绍

[英]Returns an iterator of the physical rows
[中]返回物理行的迭代器

代码示例

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

Workbook wb = WorkbookFactory.create(new File("/path/to/your/excel/file"));
 Sheet mySheet = wb.getSheetAt(0);
 Iterator<Row> rowIter = mySheet.rowIterator();
 System.out.println(mySheet.getRow(1).getCell(0));

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

InputStream inp =getClass().getResourceAsStream("filename.xls"));
Workbook wb = WorkbookFactory.create(inp);
DataFormatter objDefaultFormat = new DataFormatter();
FormulaEvaluator objFormulaEvaluator = new HSSFFormulaEvaluator((HSSFWorkbook) wb);

Sheet sheet= wb.getSheetAt(0);
Iterator<Row> objIterator = sheet.rowIterator();

while(objIterator.hasNext()){

  Row row = objIterator.next();
  Cell cellValue = row.getCell(0);
  objFormulaEvaluator.evaluate(cellValue); // This will evaluate the cell, And any type of cell will return string value
  String cellValueStr = objDefaultFormat.formatCellValue(cellValue,objFormulaEvaluator);

}

代码示例来源：origin: mrdear/JavaWEB

Iterator<Row> rowIterator = sheet.rowIterator();

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

for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
  final Sheet sheet = workbook.getSheetAt(i);
  final Iterator<Row> rows = sheet.rowIterator();
  if (rows.hasNext()) {
    final Row header = rows.next();
    ....
  }
}

代码示例来源：origin: org.molgenis/molgenis-one-click-importer

private List<Object> getColumnDataFromSheet(Sheet sheet, int columnIndex) {
 List<Object> dataValues = newLinkedList();
 sheet
   .rowIterator()
   .forEachRemaining(row -> dataValues.add(getCellValue(row.getCell(columnIndex))));
 dataValues.remove(0); // Remove the header value
 return dataValues;
}

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

Workbook wb = WorkbookFactory.create(new File("/path/to/your/excel/file"));
 Sheet mySheet = wb.getSheetAt(0);
 Iterator<Row> rowIter = mySheet.rowIterator();
 System.out.println(mySheet.getRow(1).getCell(0));

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

File filename = new File("E:/Test.xlsx");
FileInputStream isr= new FileInputStream(filename);

Workbook book1 = new XSSFWorkbook(isr);
Sheet sheet = book1.getSheetAt(0);  
Iterator<Row> rowItr = sheet.rowIterator();

代码示例来源：origin: org.databene/databene-formats

public static int getColumnCount(Sheet sheet) {
  int columnCount = 0;
  Iterator<Row> rowIterator = sheet.rowIterator();
  while (rowIterator.hasNext())
    columnCount = Math.max(columnCount, rowIterator.next().getLastCellNum());
  return columnCount;
}

代码示例来源：origin: eu.ralph-schuster/csv

/**
 * Computes the max row length of any rows in this sheet.
 * @return int length
 */
public int computeMaxColumnCount() {
  int maxColumnCount = 0;
  for (java.util.Iterator<Row> i = sheet.rowIterator(); i.hasNext();) {
    int length = i.next().getLastCellNum();
    if (length > maxColumnCount) maxColumnCount = length;
  }
  return maxColumnCount;
}

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

String path="C:\\Book2.xlsx";
try {

    File f = new File( path );
    Workbook wb = WorkbookFactory.create(f);
    Sheet mySheet = wb.getSheetAt(0);
    Iterator<Row> rowIter = mySheet.rowIterator();
    for ( Iterator<Row> rowIterator = mySheet.rowIterator() ;rowIterator.hasNext(); )
    {
      for (  Iterator<Cell> cellIterator = ((Row)rowIterator.next()).cellIterator() ; cellIterator.hasNext() ;  ) 
      {
        System.out.println ( ( (Cell)cellIterator.next() ).toString() );
      }
      System.out.println( " **************************************************************** ");
    }
  } catch ( Exception e )
  {
    System.out.println( "exception" );
    e.printStackTrace();
  }

代码示例来源：origin: cn.afterturn/easypoi-base

private void ensureColumnBounds(Sheet sheet) {
  if (gotBounds) {
    return;
  }
  Iterator<Row> iter = sheet.rowIterator();
  firstColumn = (iter.hasNext() ? Integer.MAX_VALUE : 0);
  endColumn = 0;
  while (iter.hasNext()) {
    Row row = iter.next();
    short firstCell = row.getFirstCellNum();
    if (firstCell >= 0) {
      firstColumn = Math.min(firstColumn, firstCell);
      endColumn = Math.max(endColumn, row.getLastCellNum());
    }
  }
  gotBounds = true;
}

代码示例来源：origin: org.jeecg/easypoi-base

private void ensureColumnBounds(Sheet sheet) {
  if (gotBounds)
    return;
  Iterator<Row> iter = sheet.rowIterator();
  firstColumn = (iter.hasNext() ? Integer.MAX_VALUE : 0);
  endColumn = 0;
  while (iter.hasNext()) {
    Row row = iter.next();
    short firstCell = row.getFirstCellNum();
    if (firstCell >= 0) {
      firstColumn = Math.min(firstColumn, firstCell);
      endColumn = Math.max(endColumn, row.getLastCellNum());
    }
  }
  gotBounds = true;
}

代码示例来源：origin: zhangdaiscott/jeasypoi

private void ensureColumnBounds(Sheet sheet) {
  if (gotBounds)
    return;
  Iterator<Row> iter = sheet.rowIterator();
  firstColumn = (iter.hasNext() ? Integer.MAX_VALUE : 0);
  endColumn = 0;
  while (iter.hasNext()) {
    Row row = iter.next();
    short firstCell = row.getFirstCellNum();
    if (firstCell >= 0) {
      firstColumn = Math.min(firstColumn, firstCell);
      endColumn = Math.max(endColumn, row.getLastCellNum());
    }
  }
  gotBounds = true;
}

代码示例来源：origin: xiaolanglang/easypoi

private void ensureColumnBounds(Sheet sheet) {
  if (gotBounds)
    return;
  Iterator<Row> iter = sheet.rowIterator();
  firstColumn = (iter.hasNext() ? Integer.MAX_VALUE : 0);
  endColumn = 0;
  while (iter.hasNext()) {
    Row row = iter.next();
    short firstCell = row.getFirstCellNum();
    if (firstCell >= 0) {
      firstColumn = Math.min(firstColumn, firstCell);
      endColumn = Math.max(endColumn, row.getLastCellNum());
    }
  }
  gotBounds = true;
}

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

private void ensureColumnBounds(Sheet sheet) {
  if (gotBounds) {
    return;
  }
  Iterator<Row> iter = sheet.rowIterator();
  firstColumn = (iter.hasNext() ? Integer.MAX_VALUE : 0);
  endColumn = 0;
  while (iter.hasNext()) {
    Row row = iter.next();
    short firstCell = row.getFirstCellNum();
    if (firstCell >= 0) {
      firstColumn = Math.min(firstColumn, firstCell);
      endColumn = Math.max(endColumn, row.getLastCellNum());
    }
  }
  gotBounds = true;
}

代码示例来源：origin: eBay/xcelite

private void buildHeader() {
  header = Sets.newLinkedHashSet();
  rowIterator = sheet.getNativeSheet().rowIterator();
  Row row = rowIterator.next();
  if (row == null) {
   throw new XceliteException("First row in sheet is empty. First row must contain header");
  }
  Iterator<Cell> itr = row.cellIterator();
  while (itr.hasNext()) {
   Cell cell = itr.next();
   header.add(cell.getStringCellValue());
  }   
 }
}

代码示例来源：origin: FutureCitiesCatapult/TomboloDigitalConnector

@Override
public List<Attribute> getFixedValueAttributes(String datasourceID) {
  List<Attribute> attributes = new ArrayList<>();
  Row attributeHeader = workbook.getSheetAt(DatasourceId.schools.sheetIdx).rowIterator().next();
  IntStream.rangeClosed(attributeHeader.getFirstCellNum(), attributeHeader.getLastCellNum() - 1)
      .forEach(idx -> {
            String label = attributeHeader.getCell(idx).getStringCellValue();
            attributes.add(new Attribute(getProvider(), label, label));
          }
      );
  return attributes;
}

代码示例来源：origin: org.databene/databene-formats

public XLSLineIterator(Sheet sheet, boolean headersIncluded, boolean formatted, Converter<String, ?> stringPreprocessor) {
  this.emptyMarker = "'";
  this.nullMarker = null;
  this.formatted = formatted;
  if (stringPreprocessor == null)
    stringPreprocessor = new NoOpConverter<String>();
  this.stringPreprocessor = stringPreprocessor;
  
  rowIterator = sheet.rowIterator();
  if (!rowIterator.hasNext()) {
    close();
    return;
  } else if (headersIncluded) {
    parseHeaders();
  }
}

代码示例来源：origin: gradle.plugin.GoBqa/gradle-plugin

public TestSuite load() throws IOException {
  final TestSuite result = new TestSuite(suiteName);
  final Workbook workbook = SuiteUtils.loadSuite(suiteFile);
  workbook.sheetIterator().forEachRemaining(sheet -> {
    final TestCase testCase = result.addTestCase(sheet.getSheetName());
    final int rowCount = sheet.getLastRowNum() - sheet.getFirstRowNum();
    if (rowCount < 2)
      throw new IllegalArgumentException(
          String.format("Suite file [%s] has an invalid number of rows", this.suiteFile));
    final Iterator<Row> iterator = sheet.rowIterator();
    final Row titleRow = iterator.next(); // siempre debería haber una row con titulos
    iterator.forEachRemaining(row -> addRow(testCase, row));
  });
  return result;
}

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

CellStyle centeredStyle = workbook.createCellStyle();
centeredStyle.setAlignment(CellStyle.ALIGN_CENTER);

CellStyle leftStyle = workbook.createCellStyle();
leftStyle.setAlignment(CellStyle.ALIGN_LEFT);

Sheet sheet = workbook.getSheetAt(0);
for(Row row : sheet.rowIterator()) {
  for(Cell cell : row.cellIterator()) {
    CellStyle cellStyle = (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) ? centeredStyle : leftStyle;
    cell.setCellStyle(cellStyle);
  }
}