java 엑셀 다운로드

dispatcher-servlet.xml  에

<bean name="excelView" class="egovframework.utils.ExcelLoader"/>

ExcelLoader.java 에

package egovframework.utils;
 
import java.util.List;
import java.util.Map;
 
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.web.servlet.view.document.AbstractExcelView;
 
import egovframework.front.cal.vo.CalcVO;
import egovframework.sys.stt.vo.StatsVO;
 
public class ExcelLoader extends AbstractExcelView{
    @Override   
    protected void buildExcelDocument(Map<String,Object> ModelMap,HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception{
             HSSFSheet worksheet = null;
             HSSFRow row = null;
 
             worksheet = workbook.createSheet("sheet1");
             String fileName = "";
 
             if(ModelMap.get("excelKey").equals("calc")){
                 fileName = "calc";
                 List<CalcVO> list = (List<CalcVO>)ModelMap.get("excelList");
 
                 row = worksheet.createRow(0);
                 row.createCell(0).setCellValue("거래번호");
                 
                 for(int i=0;i<list.size();i++){
                     row = worksheet.createRow(i+1);
                     row.createCell(0).setCellValue(list.get(i).getOrdNo());
                     
                 }
 
             }else if(ModelMap.get("excelKey").equals("stats_cate")){
                 fileName = "stats_cate";
                 List<StatsVO> list = (List<StatsVO>)ModelMap.get("excelList");
 
                 row = worksheet.createRow(0);
                 row.createCell(0).setCellValue("월/일");
                 
                 for(int i=0;i<list.size();i++){
                     row = worksheet.createRow(i+1);
                     row.createCell(0).setCellValue(list.get(i).getOrdDt());
                    
                 }
             }else if(ModelMap.get("excelKey").equals("stats_user")){
                 fileName = "stats_user";
                 List<StatsVO> list = (List<StatsVO>)ModelMap.get("excelList");
 
                 row = worksheet.createRow(0);
                 row.createCell(1).setCellValue("1월");
                
 
                 for(int i=0;i<list.size();i++){
                     row = worksheet.createRow(i+1);
                     row.createCell(0).setCellValue(list.get(i).getUserNm());
                    
                 }
             }else if(ModelMap.get("excelKey").equals("stats_prod")){
                 fileName = "stats_prod";
                 List<StatsVO> list = (List<StatsVO>)ModelMap.get("excelList");
 
                 row = worksheet.createRow(0);
                 row.createCell(0).setCellValue("월/일");
                
                 for(int i=0;i<list.size();i++){
                     row = worksheet.createRow(i+1);
                     row.createCell(0).setCellValue(list.get(i).getOrdDt());
                     
                 }
             }
 
 
             response.setContentType("Application/Msexcel");
             response.setHeader("Content-Disposition", "ATTachment; Filename="+fileName+"_"+DateUtil.getCurrentDate("yyyyMMdd")+".xls");
       }
}