本文整理汇总了Java中org.apache.poi.ss.usermodel.Row.cellIterator方法的典型用法代码示例。如果您正苦于以下问题:Java Row.cellIterator方法的具体用法?Java Row.cellIterator怎么用?Java Row.cellIterator使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.poi.ss.usermodel.Row
的用法示例。
在下文中一共展示了Row.cellIterator方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: readExcelFile
import org.apache.poi.ss.usermodel.Row; //导入方法依赖的package包/类
/**
* Método que se encarga de leer el libro de excel
* cuya ruta recibimos en el constructor y devuelve una lista
* de ciudadanos
* @return lista de Usuarios de la base de datos
*/
public List<CitizenDB> readExcelFile(){
List<CitizenDB> citizens = new ArrayList<CitizenDB>();
// para cada una de las hojas presentes en el documento de excel
for(int i=0;i < workbook.getNumberOfSheets();i++){
XSSFSheet sheet = this.workbook.getSheetAt(i);
Iterator<Row> rowIterator = sheet.iterator();
Row row;
int counter = 0;
//para cada fila de la hoja
while(rowIterator.hasNext()){
row = rowIterator.next();
if (counter > 0) { //omitimos la cabecera (hay que mirar si hay un metodo de la API)
Iterator<Cell> cellIterator = row.cellIterator();
int j = 0;
CitizenDB user = new CitizenDB();
while (cellIterator.hasNext())
this.insertCitizenField(user, j++, cellIterator.next());
user.setPassword(new GenerationPassword().passwordGenerator());
citizens.add(user);
}
counter++;
}
}
return citizens;
}
示例2: isBlankRow
import org.apache.poi.ss.usermodel.Row; //导入方法依赖的package包/类
/**
* 判断空行
*/
private static boolean isBlankRow(Row row) {
if (row == null) {
return true;
}
boolean result = true;
Iterator<Cell> cells = row.cellIterator();
String value = "";
while (cells.hasNext()) {
Cell cell = cells.next();
int cellType = cell.getCellType();
switch (cellType) {
case Cell.CELL_TYPE_NUMERIC:
value = String.valueOf(cell.getNumericCellValue());
break;
case Cell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_BOOLEAN:
value = String.valueOf(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_FORMULA:
value = String.valueOf(cell.getCellFormula());
break;
}
if (StringUtils.isNotBlank(value)) {
result = false;
break;
}
}
return result;
}
示例3: ExcelReader
import org.apache.poi.ss.usermodel.Row; //导入方法依赖的package包/类
public ExcelReader(String fileName, String sheetName) {
int rowNumber = 0;
int colNumber = 0;
try {
FileInputStream file = new FileInputStream(new File(fileName));
XSSFWorkbook workbook = new XSSFWorkbook(file);
XSSFSheet sheet;
Iterator<Row> rowIterator;
if (sheetName != null)
sheet = workbook.getSheet(sheetName);
else
sheet = workbook.getSheetAt(0);
Row row;
Cell cell;
Iterator<Cell> cellIterator;
if (sheet != null) {
rowIterator = sheet.iterator();
while (rowIterator.hasNext()) {
row = rowIterator.next();
cellIterator = row.cellIterator();
colNumber = 0;
while (cellIterator.hasNext()) {
cell = cellIterator.next();
if (rowNumber == 0)
celNum.put(cellVal(cell), colNumber);
else
celValues.put("["+ rowNumber +","+ colNumber +"]", cellVal(cell));
colNumber++;
}
rowNumber++;
}
}
rowCount = rowNumber - 1;
file.close();
}
catch (Exception x) {
x.printStackTrace();
}
}