package com.cn.xxx;
@PermInfo(value = "成绩管理", pval = "xx:xx:xx")
@RestController
@RequestMapping("/xx")
public class Controller {
@Autowired
private XXXX xxxx;
/**
* Excel模板导入考试成绩
*/
@RequestMapping(value = "/saveExamGradesExcel", method = RequestMethod.POST)
@RequiresPermissions("detect:examResult:saveExamGradesExcel")
@PermInfo("成绩导入")
public Json saveExamGradesExcel(@RequestBody @RequestParam("file") MultipartFile file, Entity en) {
if (en.getSemesterId() == null || en.getSemesterId() == 0) {
return Json.fail("msg", "请选择xx");
}
//初始化对象
XXX XXX= new XXX();
Workbook workbook = null;
XSSFWorkbook workbook2 = null;
HSSFWorkbook workbook3 = null;
String message = null;
try {
//获取excel文件名
String excleName = file.getOriginalFilename();
//获取输入流
InputStream inputStream = file.getInputStream();
workbook2 = new XSSFWorkbook(inputStream);
inputStream.close();
//工作表对象
XSSFSheet xssfSheet = workbook2.getSheetAt(0);
Map<Integer, String> map = ExcelToPicUtil.getPictures2(xssfSheet);
//总行数
int rowLength = xssfSheet.getLastRowNum() + 1;
//工作表的列
Row row = xssfSheet.getRow(0);
//总列数
int colLength = row.getLastCellNum();
//得到指定的单元格
Cell cell = row.getCell(0);
System.out.println("开始导入校验");
for (int i = 0; i < rowLength; i++) {
row = xssfSheet.getRow(i);
if (i == 0 && colLength > 3) {
for (int j = 0; j < colLength; j++) {
cell = row.getCell(j);
//获取数据
cell.setCellType(Cell.CELL_TYPE_STRING);
String moduleName = cell.getStringCellValue();
}
}
//从第二行开始获取数据
if (i != 0) {
int temp = 0;
for (int j = 0; j < colLength; j++) {
// System.out.println("第" + i + "行" + "第" + j + "列");
cell = row.getCell(j);
//第一个格子
if (j == 0) {
cell.setCellType(Cell.CELL_TYPE_STRING);
String stuNo = cell.getStringCellValue();
//stuNo应该是这个格子的信息
if (stuNo == null || stuNo.equals("")) {
messages.add("第" + i + "行" + "第" + j + "列错误,xxx,请重新导入");
continue;
} else {
//查学号在不在
int countNo = stuMapper.selectCount(stuNo);
if (countNo == 0) {
messages.add("第" + i + "行" + "第" + j + "列错误,xxx,请重新导入");
continue;
} else {
获取数据
}
}
}
// if (j == 1) {
// cell.setCellType(Cell.CELL_TYPE_STRING);
// String stuName = cell.getStringCellValue();
// stu.setStuName(stuName);
// }
if (j >= 2) {
cell.setCellType(Cell.CELL_TYPE_STRING);
String moduleScore = cell.getStringCellValue();
if (moduleScore == null || moduleScore.equals("")) {
messages.add("第" + i + "行" + "第" + j + "列错误,xxx");
continue;
} else {
获取数据
}
}
}
}
}
//将所有格式正确的数据存入集合中,最后在这里将其添加到考试成绩表和模块成绩表
if (list != null && list.size() > 0) {
for (Entity item : list) {
//插入成绩
scoreMapper.insert(item);
}
}
if (messages.size() > 0) {
messages.add("false");
}
return Json.succ("msg", "模板导入考试成绩成功!").data("messages", messages);
} catch (Exception e) {
e.printStackTrace();
return Json.fail("模板导入考试成绩失败,请联系管理员");
}
}
ex表格导入代码
最新推荐文章于 2023-06-10 23:26:51 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)