[Java] 엑셀 다운로드 기능 구현

- POI dependency 추가

https://mvnrepository.com/artifact/org.apache.poi/poi

Maven Repository: org.apache.poi » poi

- 가장 최신버전인 5.0.0 버전을 활용했습니다.

 

<!-- xls 전용 -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>5.0.0</version>
</dependency>

<!-- xlsx 전용 -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>5.0.0</version>
</dependency>

 

- 컨트롤러 구성

import java.io.IOException;
import java.util.List;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFWorkbook; 
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook; 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping; 

import simms.soft.board.model.BoardVO;
import simms.soft.board.service.BoardService;

@Controller
public class BoardApiController {
	
	@Autowired
	BoardService boardService;
	

	@GetMapping("/api/excel/board")
	public void downloadBoard(HttpServletResponse response) throws IOException {
		Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet("게시판글들");
        int rowNo = 0;
 
        Row headerRow = sheet.createRow(rowNo++);
        headerRow.createCell(0).setCellValue("글 번호");
        headerRow.createCell(1).setCellValue("제목");
        headerRow.createCell(2).setCellValue("내용");
        headerRow.createCell(3).setCellValue("작성자");
 
        List<BoardVO> list = boardService.excelBoardList();
        for (BoardVO board : list) {
            Row row = sheet.createRow(rowNo++);
            row.createCell(0).setCellValue(board.getBoardNo());
            row.createCell(1).setCellValue(board.getTitle());
            row.createCell(2).setCellValue(board.getContent());
            row.createCell(3).setCellValue(board.getUserId());
        }
 
        response.setContentType("ms-vnd/excel");
        response.setHeader("Content-Disposition", "attachment;filename=boardlist.xls");
 
        workbook.write(response.getOutputStream());
        workbook.close();
	}
	 
}

 

- 간단하게 엑셀 다운로드 완료

 

 

---

출처

 

https://shanepark.tistory.com/260

Java) POI 활용해 DB데이터 엑셀 파일로 저장하기

 

https://techblog.woowahan.com/2698/

아 엑셀다운로드 개발,,, 쉽고 빠르게 하고 싶다 (feat. 엑셀 다운로드 모듈 개발기) | 우아한형제