java 读取xls、xlsx文件

75 阅读 0 评论 50 点赞

我是靠谱客的博主无心汉堡，最近开发中收集的这篇文章主要介绍java 读取xls、xlsx文件，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

try {
this.upload(file);
String originName = file.getOriginalFilename();
// 取出文件的后缀
int count = 0;
for (int i = 0; i < originName.length(); i++) {
if (originName.charAt(i) == '.') {
count = i;
break;
}
}
String fileType = originName.substring(count + 1); //文件类型
if(!fileType.equals("xls")&&!fileType.equals("xlsx")){
return MsgOut.fail("只支持xls、xlsx类型文件");
}
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String format = sdf.format(new Date());
String savePath = uploadpath + "\" + "files" +
"\" + fileType + "\" + format;
String fielPath=savePath + "\" + originName;
//文档
File file1=new File(fielPath);
FileInputStream inputStream = new FileInputStream(file1);
//创建工作本,参数为工作流
Workbook workbook=null;
if(fileType.equals("xls")) {
workbook = new HSSFWorkbook(inputStream);
}else if(fileType.equals("xlsx")){
workbook = new XSSFWorkbook(inputStream);
}
if(workbook!=null) {
// 获取第一个表单Sheet
Sheet sheetAt = workbook.getSheetAt(0);
String sheetName = sheetAt.getSheetName();
//默认第一行为标题行，i = 0
//XSSFRow titleRow = sheetAt.getRow(0);
// 循环获取每一行数据
ThinkUserSpecialRank thinkUserSpecialRank = new ThinkUserSpecialRank();
for (int i = 0; i < sheetAt.getPhysicalNumberOfRows(); i++) {
Row row = sheetAt.getRow(i);
// 读取每一格内容
for (int index = 0; index < row.getPhysicalNumberOfCells(); index++) {
Cell cell = row.getCell(index);
cell.setCellType(Cell.CELL_TYPE_STRING);
if (cell.getStringCellValue().equals("")) {
continue;
}

}
thinkUserSpecialRank.setSpecialName(sheetName);
this.thinkUserSpecialRankMapper.insert(thinkUserSpecialRank);
}
}
} catch (IOException e) {
e.printStackTrace();
return MsgOut.OK("导入失败");
}

private void upload(MultipartFile file) {
// 获取文件原本的名字
String originName = file.getOriginalFilename();
// 判断文件类型
Set<String> set = new HashSet<>();
set.add(".xls");
set.add(".xlsx");
// 取出文件的后缀
int count = 0;
for (int i = 0; i < originName.length(); i++) {
if (originName.charAt(i) == '.') {
count = i;
break;
}
}
String endName = originName.substring(count); //取出文件类型
String fileType = originName.substring(count + 1); //文件类型
// 创建保存路径
//日期格式
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String format = sdf.format(new Date());
String savePath = uploadpath + "\" + "files" + "\" + fileType + "\" + format;
// 保存文件的文件夹
File folder = new File(savePath);
// 判断路径是否存在,不存在则自动创建
if (!folder.exists()) {
folder.mkdirs();
}
String saveName = originName;
try {
File file1 = new File(folder, saveName);
file.transferTo(file1);
String filePath = savePath + "\" + saveName;
} catch (IOException e) {
}
}