通通是干货,直接贴代码
Maven依赖
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.0.1</version>
</dependency>
@GetMapping("/download/export/student")
public R setUpExcel(@Param("type") String type, @Param("id") String id, HttpServletRequest request, HttpServletResponse response) throws IOException{
List<RoomPersonnel> roomPersonnelList=roomPersonnelService.getRoomStudent(type, id,LyraUtils.getCompanyId());
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("学生信息");
HSSFRow row = sheet.createRow((int) 0);
wb.setSheetName(0, "宿舍学生信息");
String[] headers = {
"学生姓名", "学号","性别","年级","班级","宿舍楼","宿舍号","床位号","入住时间"};
fo