반응형

controller ---------------------

@Autowired
 private ExcelView excelView;

 public void setExcelView(ExcelView excelView) {
  this.excelView = excelView;
 }
............
public ModelAndView view() {
......
  ModelAndView mav = new ModelAndView(excelView);
  mav.addObject("dataList", list);
  return mav;
}


excel view ---------------------

public class excelView extends AbstractExcelView {
  List<String> list = (List<String>)model.get("dataList");

  HSSFSheet sheet = workbook.createSheet("view");
  sheet.setDefaultColumnWidth((short)12);

  HSSFRow header = sheet.createRow(0);
  header.createCell((short)1).setCellValue("header 1");
  header.createCell((short)2).setCellValue("header 2");

  HSSFRow row = sheet.createRow(1);
  row.createCell((short)1).setCellValue("data 1");
  row.createCell((short)1).setCellValue("data 1");
}


applicationContext.xml ---------------------

<bean id="excelView" class="xxx.xxx.xxxx.ExcelView"/>

반응형

'프로그래밍 > Java' 카테고리의 다른 글

[안드로이드] 개발 환경 구축  (0) 2011.06.24
[링크] unsigned data type  (0) 2011.05.18
url encoding  (0) 2011.02.18
[link] sitemesh  (0) 2011.01.17
[이클립스] 플러그인 FindBugs  (0) 2010.06.10

+ Recent posts