poi 读取excel2007 出现空指针 期待解决

public static void main(String args[]) throws FileNotFoundException,
IOException {
String file = "d:\\user.xlsx";
List<User> list = importExcel(file);
for (User u : list) {
System.out.println("姓名:" + u.getName() + "密码：" + u.getPassword());
}

}



public static List<User> importExcel(String file)
throws FileNotFoundException, IOException {
String s=file.substring(file.indexOf(".")+1);
List<User> userList = new ArrayList<User>();;// 批处理导入的数据容器
System.out.println(s);
//支持excel2007
if(s.equals("xlsx")){
System.out.println("***********");
XSSFWorkbook wb= new XSSFWorkbook(file);
//只能得到第一个sheet
XSSFSheet sheet = wb.getSheetAt(0);
int firstRowNum = sheet.getFirstRowNum();
int lastRowNum = sheet.getPhysicalNumberOfRows();
System.out.println(firstRowNum+","+lastRowNum);
for (int r = firstRowNum; r <= lastRowNum; r++) {
// 循环得到每一行
XSSFRow row = sheet.getRow(r);
if (row == null)
continue;
String cell=row.getCell(r).toString();//获取每一行的内容

User user = new User();
user.setName(cell);


user.setPassword("1111");

userList.add(user);
}



            

}else if (s.equals("xls")){
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));
HSSFWorkbook workbook = new HSSFWorkbook(fs);

int sheetNum = workbook.getNumberOfSheets();// 得到工作簿的个数
for (int i = 0; i < sheetNum; i++) {
// 循环得到每个工作簿
HSSFSheet sheet = workbook.getSheetAt(i);
int firstRowNum = sheet.getFirstRowNum();
int lastRowNum = sheet.getLastRowNum();
for (int r = firstRowNum; r <= lastRowNum; r++) {
// 循环得到每一行
HSSFRow row = sheet.getRow(r);
if (row == null)
continue;
int firstCellNum = row.getFirstCellNum();
int lastCellNum = row.getLastCellNum();
User user = new User();
for (int c = firstCellNum; c <= lastCellNum; c++) {
HSSFCell cell = row.getCell((short) c);// 得到c行的单元格对象

if (cell == null)
continue;
if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
user.setName(cell.getStringCellValue());

}

}
user.setPassword("1111");

userList.add(user);
}

}

}
return userList;

}


异常信息：

xlsx
***********
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
at com.iflysse.poi.testExcel.ReadExcelTest.importExcel(ReadExcelTest.java:39)
at com.iflysse.poi.testExcel.ReadExcelTest.main(ReadExcelTest.java:24)
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 2 more

评论

2 楼 胡德品 2011-07-25  

jieshuo 写道

楼主怎么解决的啊？我也碰到同样的问题哦

public static void main(String args[]) throws FileNotFoundException,
IOException {
String file = "d:\\user.xls";
List<User> list = importExcel(file);
for (User u : list) {
System.out.println("姓名:" + u.getName() + "密码：" + u.getPassword()+"角色Id："+u.getRoleId());
}
}
public static List<User> importExcel(String file)
throws FileNotFoundException, IOException {
String s=file.substring(file.indexOf(".")+1);
List<User> userList = new ArrayList<User>();;// 批处理导入的数据容器
System.out.println(s);
//支持excel2007
if(s.equals("xlsx")){
XSSFWorkbook wb= new XSSFWorkbook(file);
//只能得到第一个sheet
XSSFSheet sheet = wb.getSheetAt(0);
int firstRowNum = sheet.getFirstRowNum();
int lastRowNum = sheet.getLastRowNum();
for (int r = firstRowNum; r <=lastRowNum; r++) {
// 循环得到每一行
XSSFRow row = sheet.getRow(r);
if (row == null)
continue;
int firstCellNum = row.getFirstCellNum();
int lastCellNum = row.getLastCellNum();
User user = new User();
for (int c = firstCellNum; c <= lastCellNum; c++) {
XSSFCell cell = row.getCell((short) c);// 得到c行的单元格对象
if (cell == null)
continue;
if (cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
user.setName(cell.getStringCellValue());
}
if(cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC){
user.setRoleId((int) cell.getNumericCellValue());
}
}
user.setPassword("1111");
userList.add(user);
}
}else if (s.equals("xls")){
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));
HSSFWorkbook workbook = new HSSFWorkbook(fs);
int sheetNum = workbook.getNumberOfSheets();// 得到工作簿的个数
for (int i = 0; i < sheetNum; i++) {
// 循环得到每个工作簿
HSSFSheet sheet = workbook.getSheetAt(i);
int firstRowNum = sheet.getFirstRowNum();
int lastRowNum = sheet.getLastRowNum();
for (int r = firstRowNum+1; r <= lastRowNum; r++) {
// 循环得到每一行
HSSFRow row = sheet.getRow(r);
if (row == null)
continue;
int firstCellNum = row.getFirstCellNum();
int lastCellNum = row.getLastCellNum();
User user = new User();
for (int c = firstCellNum; c <= lastCellNum; c++) {
HSSFCell cell = row.getCell((short) c);// 得到c行的单元格对象                 
if (cell == null)
continue;
if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
user.setName(cell.getStringCellValue());
}
if(cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC){
user.setRoleId((int)cell.getNumericCellValue());
}
}
user.setPassword("1111");
userList.add(user);
}
}
}
return userList;
}
[img][/img]

1 楼 jieshuo 2011-03-07  

楼主怎么解决的啊？我也碰到同样的问题哦