当前页面: 开发资料首页 → J2SE 专题 → POI包中如何获得EXCEL表格的行和列?
POI包中如何获得EXCEL表格的行和列?
摘要: POI包中如何获得EXCEL表格的行和列?
如题~~
试试:
FileInputStream fis = new FileInputStream(filePath);
POIFSFileSystem fs = new POIFSFileSystem(fis);
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(i);
//行:
for (Iterator it = sheet.rowIterator(); it.hasNext();) {
HSSFRow row = (HSSFRow) it.next();
//列
for (Iterator cit = row.cellIterator(); cit.hasNext();) {
HSSFCell cell = (HSSFCell) cit.next();
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:
insertStr.append((long) cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:
insertStr.append("'" + cell.getStringCellValue() + "'");
break;
}
}
}
}
HSSFSheet sheet = wb.getSheetAt(i);
这个变量i 是怎么来的?
这个方法读取的数据顺序有点特别!!!