[Spring] Excel Download/Upload

https://github.com/heowc/SpringBootSample/tree/master/SpringBootExcel

heowc/SpringBootSample

 

추가적으로

// 한글 파일 이름
private void setFileName(HttpServletResponse response, String fileName) {
    String header = getBrowser(this.request);
    try {
        if (header.contains("MSIE")) {
                String docName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
                response.setHeader("Content-Disposition", "attachment;filename=" + getFileExtension(docName) + ";");
            } else if (header.contains("Firefox")) {
                String docName = new String(fileName.getBytes("UTF-8"), "ISO-8859-1"); 
                response.setHeader("Content-Disposition", "attachment; filename=\"" + getFileExtension(docName) + "\"");
            } else if (header.contains("Opera")) {
                String docName = new String(fileName.getBytes("UTF-8"), "ISO-8859-1"); 
                response.setHeader("Content-Disposition", "attachment; filename=\"" + getFileExtension(docName) + "\"");
            } else if (header.contains("Chrome")) {
                String docName = new String(fileName.getBytes("UTF-8"), "ISO-8859-1"); 
                response.setHeader("Content-Disposition", "attachment; filename=\"" + getFileExtension(docName) + "\"");
            }
        } catch (UnsupportedEncodingException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

// Mybatis에서 데이터를 받으면 HashMap 안에 타입이 제 각각 들어가므로
// 그 타입에 맞춰서 setCellValue 함수에 들어갈 수 있도록 변환해야 함
private void createRow(Sheet sheet, List<Object> cellList, int rowNum) {
    int size = cellList.size();
    Row row = sheet.createRow(rowNum);
     
    for (int i = 0; i < size; i++) {
        if(cellList.get(i) instanceof Integer == true)
        {
            row.createCell(i).setCellValue(((Integer)cellList.get(i)).doubleValue());
        }
        else if(cellList.get(i) instanceof String == true)
        {
            row.createCell(i).setCellValue((String)cellList.get(i));
        }
        else if(cellList.get(i) instanceof Timestamp == true)
        {
            Timestamp t = (Timestamp)cellList.get(i);
            Cell cell = row.createCell(i);
            
            cell.setCellStyle(this.cellDateTimeStyle);
            cell.setCellValue( new Date( t.getTime() ) );
        } 
    }
}