本文整理了Java中org.apache.poi.hssf.usermodel.HSSFSheet.rowIterator()
方法的一些代码示例,展示了HSSFSheet.rowIterator()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。HSSFSheet.rowIterator()
方法的具体详情如下:
包路径:org.apache.poi.hssf.usermodel.HSSFSheet
类名称: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);
}
}
内容来源于网络,如有侵权,请联系作者删除!