org.apache.poi.hssf.usermodel.HSSFSheet.rowIterator()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(7.3k)|赞(0)|评价(0)|浏览(178)

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

HSSFSheet.rowIterator介绍

暂无

代码示例

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

/**
 * Alias for {@link #rowIterator()} to allow
 * foreach loops
 */
@Override
public Iterator<Row> iterator() {
  return rowIterator();
}

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

HSSFWorkbook myWorkBook = new HSSFWorkbook(new POIFSFileSystem(new FileInputStream("E:/Project/SpringHibernet/MultiplexTicketBookingNew/web/excelSheets/Country.xlsx")));
 HSSFSheet mySheet = myWorkBook.getSheetAt(0);
 Iterator rowIter = mySheet.rowIterator();
 System.out.println(mySheet.getRow(1).getCell(0));

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

Iterator rowIter = mySheet.rowIterator();

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/**
 * Alias for {@link #rowIterator()} to allow
 * foreach loops
 */
@Override
public Iterator<Row> iterator() {
  return rowIterator();
}

代码示例来源:origin: com.haulmont.thirdparty/poi

/**
 * Alias for {@link #rowIterator()} to allow
 * foreach loops
 */
public Iterator<Row> iterator() {
  return rowIterator();
}

代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev

/**
 * Alias for {@link #rowIterator()} to allow
 *  foreach loops
 */
public Iterator<Row> iterator() {
  return rowIterator();
}

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

HSSFSheet mySheet = myWorkBook.getSheetAt(0);
       Iterator<Row> rowIter = mySheet.rowIterator();
       while (rowIter.hasNext()) {
         HSSFRow myRow = (HSSFRow) rowIter.next();
         Iterator<Cell> cellIter = myRow.cellIterator();
         List<HSSFCell> cellStore = new ArrayList<HSSFCell>();
         while (cellIter.hasNext()) {
           HSSFCell myCell = (HSSFCell) cellIter.next();
           rowCount++ //For myRow
         }
       }

代码示例来源:origin: gradle.plugin.net.mbonnin/strings2xls

private void prepareMapping(HSSFSheet sheetMapping) {
  if (sheetMapping == null) {
    return;
  }
  mMapping = new HashMap<String, String>();
  Iterator<Row> it = sheetMapping.rowIterator();
  while (it.hasNext()) {
    Row row = it.next();
    mMapping.put(row.getCell(0).getStringCellValue(), row.getCell(1).getStringCellValue());
  }
}

代码示例来源:origin: TomasKypta/android-lang-tool

private void prepareMapping(HSSFSheet sheetMapping) {
  if (sheetMapping == null) {
    return;
  }
  mMapping = new HashMap<String, String>();
  Iterator<Row> it = sheetMapping.rowIterator();
  while (it.hasNext()) {
    Row row = it.next();
    mMapping.put(row.getCell(0).getStringCellValue(), row.getCell(1).getStringCellValue());
  }
}

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

HSSFSheet         sheet1    = workBook.getSheetAt (0);
      Iterator<Row> rows     = sheet1.rowIterator ();

while (rows.hasNext ())
{
Row row = rows.next ();

// do stuff
if (row.getCell(0).getCellType() == HSSFCell.CELL_TYPE_NUMERIC)
  System.out.println ("Row No.: " + row.getRowNum ()+ " " + row.getCell(0).getNumericCellValue());
HSSFCell cell = row.createCell(0);
cell.setCellValue("100"); 

}

代码示例来源:origin: de.adorsys.sts/sts-worksheet-loader

private void updateLogin(HSSFWorkbook workbook) {
    HSSFSheet sheet = workbook.getSheet("Login");
    if (sheet == null)
      return;

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

    while (rowIterator.hasNext()) {
      Row row = rowIterator.next();
      loginLoader.update(row);
    }
  }
}

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

public SVTableModel(HSSFSheet st) {
 this.st = st;
 Iterator<Row> i = st.rowIterator();
 while (i.hasNext()) {
  HSSFRow row = (HSSFRow)i.next();
  if (maxcol < (row.getLastCellNum()+1)) {
    this.maxcol = row.getLastCellNum();
  }
 }
}

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

public SVTableModel(HSSFSheet st) {
 this.st = st;
 Iterator i = st.rowIterator();
 while (i.hasNext()) {
  HSSFRow row = (HSSFRow)i.next();
  if (maxcol < (row.getLastCellNum()+1)) {
    this.maxcol = row.getLastCellNum();
  }
 }
}

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

public SVTableModel(HSSFSheet st) {
 this.st = st;
 Iterator i = st.rowIterator();
 while (i.hasNext()) {
  HSSFRow row = (HSSFRow)i.next();
  if (maxcol < (row.getLastCellNum()+1)) {
    this.maxcol = row.getLastCellNum();
  }
 }
}

代码示例来源:origin: TomasKypta/android-lang-tool

private void prepareSplittingMap(HSSFSheet sheetConfig) throws IOException, TransformerException {
  mSplittingMap = new TreeMap<Integer, String>();
  mOutputFileNames = new HashMap<String, String>();
  Iterator<Row> it = sheetConfig.rowIterator();
  while (it.hasNext()) {
    Row row = it.next();
    if (row == null || row.getCell(0) == null || row.getCell(1) == null) {
      return;
    }
    String splitName = row.getCell(1).getStringCellValue();
    mSplittingMap.put((int)row.getCell(0).getNumericCellValue(), splitName);
    if (row.getCell(2) != null) {
      mOutputFileNames.put(splitName, row.getCell(2).getStringCellValue());
    }
  }
}

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

public XLSLineIterator(HSSFSheet sheet, Converter<String, ?> stringPreprocessor) {
  this.emptyMarker = "'";
  if (stringPreprocessor == null)
    stringPreprocessor = new NoOpConverter<String>();
  this.stringPreprocessor = stringPreprocessor;
  rowIterator = sheet.rowIterator();
  
  if (!rowIterator.hasNext()) {
    close();
    return;
  }
}

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

Map<String,String> mapEndoscBarr= new LinkedHashMap<String,String>();
     FileInputStream fis = new FileInputStream(new File(filepath));
     HSSFWorkbook      workBook = new HSSFWorkbook (fis);
     HSSFSheet         sheet    = workBook.getSheetAt (0);
     List<HSSFRow> filteredRows = new ArrayList<HSSFRow>();
     //Filter by pathology from what I am given
     Iterator<Row> rows= sheet.rowIterator(); 
     while (rows.hasNext ()){
     HSSFRow row = (HSSFRow) rows.next ();  
     Iterator<Cell> cells = row.cellIterator (); 
      while (cells.hasNext ()){
        HSSFCell cell = (HSSFCell) cells.next (); 
        if (cell.toString().contains("Tamara")) {
          filteredRows.add(row);
          break;
         }
      }
     }

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

HSSFWorkbook wBook = new HSSFWorkbook(new FileInputStream("your_path"));  
for(int i = 0; i < wBook.getNumberOfSheets(); i++){
    System.out.println("Sheet " + i + " has data: " + isSheetEmpty(wBook.getSheetAt(i)));
}
boolean isSheetEmpty(HSSFSheet sheet){
    Iterator rows = sheet.rowIterator();
    while (rows.hasNext()) {
      HSSFRow row = (HSSFRow) rows.next();
      Iterator cells = row.cellIterator();
      while (cells.hasNext()) {
        HSSFCell cell = (HSSFCell) cells.next();
        if(!cell.getStringCellValue().isEmpty()){
          return true;
        }
      }
    }
    return false;
}

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

FileInputStream fileInputStream = new FileInputStream(fileName);
   HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
   HSSFSheet worksheet = workbook.getSheet(sheetName);
   Iterator<Row> it = worksheet.rowIterator();
   while(it.hasNext()){
     HSSFRow r = (HSSFRow) it.next();
     Iterator<Cell> it1=r.cellIterator();
     while(it1.hasNext()){
       HSSFCell cell = (HSSFCell)it1.next();
       System.out.println("Row: "+cell.getRowIndex()+" ,Column: "+cell.getColumnIndex());
       System.out.println(cell);
     }
     System.out.println();
   }
 } catch (FileNotFoundException e) {
   e.printStackTrace();
 } catch (IOException e) {
   e.printStackTrace();
 }

代码示例来源:origin: org.metaeffekt.core/ae-inventory-processor

protected void readArtifactMetaData(HSSFWorkbook myWorkBook, Inventory inventory) {
  HSSFSheet mySheet = myWorkBook.getSheetAt(0);
  Iterator<?> rows = mySheet.rowIterator();
  List<Artifact> artifacts = new ArrayList<Artifact>();
  inventory.setArtifacts(artifacts);
  if (rows.hasNext()) {
    readHeader((HSSFRow) rows.next());
  }
  while (rows.hasNext()) {
    HSSFRow row = (HSSFRow) rows.next();
    Artifact artifact = readArtifactMetaData(row);
    if (artifact != null) {
      artifacts.add(artifact);
    }
  }
  for (int i = 0; i < 15; i++) {
    int width = mySheet.getColumnWidth(i);
    inventory.getContextMap().put("artifacts.column[" + i + "].width", width);
  }
}

相关文章

微信公众号

最新文章

更多

HSSFSheet类方法