Excel的导入和导出

Excel的导入和导出

excel的导入
fileName创建文件的名字需要为excel格式
public static void getExcel(HttpServletResponse response, List<List> data, String fileName) {
ExcelWriter writer = ExcelUtil.getWriter(true);
writer.write(data);
response.reset();
response.setContentType(“application/octet-stream; charset=utf-8”);
response.setHeader(“Content-Disposition”, “attachment;filename=” + URLEncoder.encode(fileName));
try {
writer.flush(response.getOutputStream());
} catch (IORuntimeException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
writer.close();
}

excel的导出
public static List<List> getRows(MultipartFile file) {
try {
ExcelReader reader = ExcelUtil.getReader(file.getInputStream());
List<List> read = reader.read();
if(read != null && read.size() >= 2){
return read.subList(1, read.size());
}
return read;
} catch (IOException e) {
e.printStackTrace();
throw new BusinessException("-1", “读取Excel错误”);
}
}