主要是用到了POI包逻淌，循環(huán)遍歷疟暖。重點是要判斷cell.getCellType()也就是cell的類型，因為cell表格數(shù)據(jù)可能是數(shù)字骨望，字符串欣舵，日期等。我是根據(jù)表的數(shù)據(jù)只判斷了字符串和數(shù)字劣光，有時候可能會有布爾類型准验，日期等。
// 解析xlsx
public List<Repeater> readText(String path) {
List<Repeater> reList = new ArrayList<Repeater>();
Repeater re = null;
try {
File file = new File(path);
if (file.isFile() && file.exists()) { // 判斷文件是否存在
InputStream is = new FileInputStream(path);
Workbook wb = null;
wb = new XSSFWorkbook(is);// 2007以上版本
// 得到第一個shell
Sheet sheetAt = wb.getSheetAt(0);
// 得到Excel的行數(shù)
int rows = sheetAt.getPhysicalNumberOfRows();
int cells = 0;
// 得到Excel的列數(shù)(前提是有行數(shù))
if (rows > 1 && sheetAt.getRow(0) != null) {
cells = sheetAt.getRow(0).getPhysicalNumberOfCells();
}
// 循環(huán)Excel行數(shù)
for (int r = 1; r < rows; r++) {
Row row = sheetAt.getRow(r);
if (row == null) {
continue;
}
re = new Repeater();
// 循環(huán)Excel的列
for (int c = 0; c < cells; c++) {
Cell cell = row.getCell(c);
if (null != cell) {
re.setCreateDate(null);
re.setModifyDate(new Date());
if (c == 0) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String id = String.valueOf(cell
.getNumericCellValue());
re.setRepeaterId(id);
} else {
re.setRepeaterId(cell.getStringCellValue());
}
} else if (c == 1) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String rptname = String.valueOf(cell
.getNumericCellValue());
re.setRptname(rptname);
} else {
re.setRptname(cell.getStringCellValue());
}
} else if (c == 2) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String number = String.valueOf(cell
.getNumericCellValue());
re.setRptnumber(number);
} else {
re.setRptnumber(cell.getStringCellValue());
}
} else if (c == 3) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String equ = String.valueOf(cell
.getNumericCellValue());
re.setEquipid(equ);
} else {
re.setEquipid(cell.getStringCellValue());
}
} else if (c == 4) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String ven = String.valueOf(cell
.getNumericCellValue());
re.setVendername(ven);
} else {
re.setVendername(cell.getStringCellValue());
}
} else if (c == 5) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String cna = String.valueOf(cell
.getNumericCellValue());
re.setVindicname(cna);
} else {
re.setVindicname(cell.getStringCellValue());
}
} else if (c == 6) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String are = String.valueOf(cell
.getNumericCellValue());
re.setAreaname(are);
} else {
re.setAreaname(cell.getStringCellValue());
}
} else if (c == 7) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String ctr = String.valueOf(cell
.getNumericCellValue());
re.setCtrlarea(ctr);
} else {
re.setCtrlarea(cell.getStringCellValue());
}
} else if (c == 8) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String typ = String.valueOf(cell
.getNumericCellValue());
re.setRpttype(typ);
} else {
re.setRpttype(cell.getStringCellValue());
}
} else if (c == 9) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String ch = String.valueOf(cell
.getNumericCellValue());
re.setTypechina(ch);
} else {
re.setTypechina(cell.getStringCellValue());
}
} else if (c == 10) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String bt = String.valueOf(cell
.getNumericCellValue());
re.setBtschina(bt);
} else {
re.setBtschina(cell.getStringCellValue());
}
} else if (c == 11) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String slave = String.valueOf(cell
.getNumericCellValue());
re.setSlave(slave);
} else {
re.setSlave(cell.getStringCellValue());
}
} else if (c == 12) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String ph = String.valueOf(cell
.getNumericCellValue());
re.setCtrlphone(ph);
} else {
re.setCtrlphone(cell.getStringCellValue());
}
} else if (c == 13) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String flag = String.valueOf(cell
.getNumericCellValue());
re.setCtrlflag(flag);
} else {
re.setCtrlflag(cell.getStringCellValue());
}
} else if (c == 14) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String st = String.valueOf(cell
.getNumericCellValue());
re.setStatus(st);
} else {
re.setStatus(cell.getStringCellValue());
}
} else if (c == 15) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String ce = String.valueOf(cell
.getNumericCellValue());
re.setCellid(ce);
} else {
re.setCellid(cell.getStringCellValue());
}
} else if (c == 16) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String lo = String.valueOf(cell
.getNumericCellValue());
re.setLongitude(lo);
} else {
re.setLongitude(cell.getStringCellValue());
}
} else if (c == 17) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String la = String.valueOf(cell
.getNumericCellValue());
re.setLatitude(la);
} else {
re.setLatitude(cell.getStringCellValue());
}
} else if (c == 18) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String po = String.valueOf(cell
.getNumericCellValue());
re.setPostion(po);
} else {
re.setPostion(cell.getStringCellValue());
}
} else if (c == 19) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String name = String.valueOf(cell
.getNumericCellValue());
re.setOwnername(name);
} else {
re.setOwnername(cell.getStringCellValue());
}
} else if (c == 20) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String phone = String.valueOf(cell
.getNumericCellValue());
re.setOwnerphone(phone);
} else {
re.setOwnerphone(cell.getStringCellValue());
}
} else if (c == 21) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
String con = String.valueOf(cell
.getNumericCellValue());
re.setConfirmed(con);
} else {
re.setConfirmed(cell.getStringCellValue());
}
}
}
}
reList.add(re);
}
// is.close();
} else {
System.out.println("找不到指定的文件");
}
} catch (Exception e) {
System.out.println("讀取文件內(nèi)容出錯");
reList = null;
e.printStackTrace();
return reList;
}
return reList;
}
