/** * Alias for {@link #cellIterator()} to allow foreach loops: * <blockquote><pre> * for(Cell cell : row){ * ... * } * </pre></blockquote> * * @return an iterator over cells in this row. */ @Override public Iterator<Cell> iterator() { return cellIterator(); }
/** * Alias for {@link #cellIterator()} to allow foreach loops: * <blockquote><pre> * for(Cell cell : row){ * ... * } * </pre></blockquote> * * @return an iterator over cells in this row. */ public Iterator<Cell> iterator() { return cellIterator(); }
/** * Alias for {@link #cellIterator()} to allow foreach loops: * <blockquote><pre> * for(Cell cell : row){ * ... * } * </pre></blockquote> * * @return an iterator over cells in this row. */ @Override public Iterator<Cell> iterator() { return cellIterator(); }
Vector cellVectorHolder = new Vector(); XSSFSheet mySheet = myWorkBook.getSheetAt(0); Iterator rowIter = mySheet.rowIterator(); while(rowIter.hasNext()){ XSSFRow myRow = (XSSFRow) rowIter.next(); Iterator cellIter = myRow.cellIterator(); List list = new ArrayList(); while(cellIter.hasNext()){ XSSFCell myCell = (XSSFCell) cellIter.next(); list.add(myCell); } cellVectorHolder.addElement(list); }
while (rows.hasNext()) { XSSFRow row = (XSSFRow) rows.next(); if(rowCount==3){ Iterator cells = row.cellIterator(); while (cells.hasNext()) { XSSFCell cell = (XSSFCell) cells.next(); System.out.print(cell.getStringCellValue()+"\t"); } } System.out.println(); rowCount++; }
XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); while (rows.hasNext()){ row=(XSSFRow) rows.next(); Iterator cells = row.cellIterator(); while (cells.hasNext()) { cell=(XSSFCell) cells.next(); cIndex=cell.getColumnIndex(); data += cell.toString() + ", "; } dataList.add(data); }
XSSFRow myRow = (XSSFRow) rowIter.next(); Iterator cellIter = myRow.cellIterator(); List cellRowList = new ArrayList(); while (cellIter.hasNext()) { XSSFCell originalCell = (XSSFCell) cellIter.next(); XSSFCell myCell = originalCell; try { // XSSFCell newCell = myCell; //( How to clone or copy a new one) XSSFCellStyle style = workbook.createCellStyle(); // the XSSFWorkbook from which you clone style.cloneStyleFrom(originalCell.getCellStyle()); myCell.setCellStyle(style); } catch (Exception e) { syso(e); } }
/** * get the contents of a sheet * * @param sheet * @return the list of list of cells */ public List<List<Object>> getSheetContent(XSSFSheet sheet) { List<List<Object>> result = new ArrayList<List<Object>>(); Iterator<Row> rows = sheet.rowIterator(); while (rows.hasNext()) { XSSFRow row = (XSSFRow) rows.next(); Iterator<Cell> cells = row.cellIterator(); List<Object> rowList = new ArrayList<Object>(); while (cells.hasNext()) { XSSFCell cell = (XSSFCell) cells.next(); Object cellValue = getCellValue(cell); rowList.add(cellValue); } if (rowList.size() > 0) result.add(rowList); } return result; }
/** * Used to check if the column order is in the required order. * @param sheet a {@link org.apache.poi.xssf.usermodel.XSSFSheet} representing the spreadsheet uploaded * @return true or false if column is in order */ public boolean isColumnNameInOrder(XSSFSheet sheet) { boolean result = false; int counter = 0; XSSFRow row = sheet.getRow(0); Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (cell.toString().isEmpty()) { break; } result = cell.toString().trim().equalsIgnoreCase(columnOrder.getColumnOrder().get(counter).trim()); if (!result) { break; } counter++; } return result; } }
Iterator cellIter = row.cellIterator(); Vector cellStoreVector=new Vector();
private String findAxisCol(XSSFCell cell) { int cellCol = cell.getColumnIndex(); Iterator<Cell> axixIt = row.cellIterator(); String axis = null; while( axixIt.hasNext() ){ Cell next = axixIt.next(); if(cellCol == next.getColumnIndex()){ axis = next.getStringCellValue(); break; } } return axis; }
Iterator cells = row.cellIterator(); while (cells.hasNext()){ cell = (XSSF) cells.next();
@Override public Collection<IColumn> getColumns() { if (_columns == null) { _columns = new HashMap<String, IColumn>(); XSSFRow headers = _workbook.getSheetAt(_index).getRow(_workbook.getSheetAt(_index) .getFirstRowNum()); for (Iterator<Cell> cit = headers.cellIterator(); cit.hasNext();) { Cell cell = cit.next(); _columns.put(cell.getStringCellValue().trim(), new ExcelColumn(cell)); _columnIDs.add(cell.getStringCellValue().trim()); } } return _columns.values(); }
Iterator cells = row.cellIterator();
Iterator cells = row.cellIterator(); while (cells.hasNext())
/** * Get all rows in current sheet. Skip header it there is one * * @return List of rows */ private List<XSSFRow> getRows() { List<XSSFRow> effectiveRows = new ArrayList<>(); int firstRowNumber = 0; XSSFSheet sheet = workBook.getSheet(collectionName); if ("Описание" .equals(sheet.getRow(sheet.getFirstRowNum()).cellIterator().next().getStringCellValue())) { // Check if there is a header on the current shit. If so, skip it firstRowNumber++; } for (int i = firstRowNumber; i <= sheet.getLastRowNum(); i++) { effectiveRows.add(sheet.getRow(i)); } return effectiveRows; }
currentObjName = ""; } else if (isObjectDeclarator(row)) { currentObjName = row.cellIterator().next().getStringCellValue().trim(); resultObj.append(currentObjName, getObjectDeclaration(row)); } else // parse a row and append it to object currentObjName = row.cellIterator().next().getStringCellValue().trim(); resultObj.append(currentObjName, getObjectDeclaration(row)); } else if (isSimpleKeyValueMap(row)) {
/** * Get all rows in current sheet. Skip header it there is one * * @return List of rows */ private List<XSSFRow> getRows() { List<XSSFRow> effectiveRows = new ArrayList<>(); int firstRowNumber = 0; XSSFSheet sheet = workBook.getSheet(sheetName); if ("Описание" .equals(sheet.getRow(sheet.getFirstRowNum()).cellIterator().next().getStringCellValue())) { // Check if there is a header on the current shit. If so, skip it firstRowNumber++; } for (int i = firstRowNumber; i <= sheet.getLastRowNum(); i++) { effectiveRows.add(sheet.getRow(i)); } return effectiveRows; }
row = (XSSFRow)rowIterator.next(); Iterator<Cell> cellIterator = row.cellIterator();
for (Iterator<Cell> cit = row.cellIterator(); cit.hasNext() && n < _columnIDs.size();) { Cell cell = cit.next(); if (!_columnIDs.get(n).equals(column)) {