springboot生成excel文件
时间: 2023-06-05 09:47:08 浏览: 242
Spring Boot可以使用Apache POI库来生成Excel文件。POI是一个Java库,可以读取和写入Microsoft Office格式的文件,包括Excel、Word和PowerPoint。
以下是使用Spring Boot和POI生成Excel文件的步骤:
1. 添加POI依赖
在pom.xml文件中添加以下依赖:
```
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
```
2. 创建Excel文件
使用POI创建Excel文件的步骤如下:
a. 创建工作簿
```
Workbook workbook = new XSSFWorkbook();
```
b. 创建工作表
```
Sheet sheet = workbook.createSheet("Sheet1");
```
c. 创建行
```
Row row = sheet.createRow(0);
```
d. 创建单元格
```
Cell cell = row.createCell(0);
cell.setCellValue("Hello World");
```
3. 将Excel文件写入输出流
使用Java IO将Excel文件写入输出流,以便将其发送到客户端。
```
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=myfile.xlsx");
OutputStream outputStream = response.getOutputStream();
workbook.write(outputStream);
outputStream.flush();
outputStream.close();
```
完整的代码示例:
```
@GetMapping("/download")
public void downloadExcel(HttpServletResponse response) throws IOException {
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("Hello World");
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=myfile.xlsx");
OutputStream outputStream = response.getOutputStream();
workbook.write(outputStream);
outputStream.flush();
outputStream.close();
}
```
以上就是使用Spring Boot和POI生成Excel文件的步骤。