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
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值