생각을 계획으로, 계획을 실천으로

public void poi(HttpServletRequest req, HttpServletResponse resp) throws Exception {

try {

// 워크북 생성

HSSFWorkbook objWorkBook = new HSSFWorkbook();

// 워크시트 생성

HSSFSheet objSheet = objWorkBook.createSheet();

// 행생성

HSSFRow objRow = objSheet.createRow(0);

// 셀 생성

HSSFCell objCell = objRow.createCell(0);

HSSFCellStyle cs = objWorkBook.createCellStyle();

HSSFDataFormat df = objWorkBook.createDataFormat();

cs.setDataFormat(df.getFormat("#,##0.0")); //or cs.setDataFormat((short)7);

objCell.setCellValue(2655.32);

objCell.setCellStyle(cs);

objWorkBook.write(resp.getOutputStream());

OutputStream out = resp.getOutputStream();   

resp.setCharacterEncoding("utf-8");    

resp.setContentType("application/x-msexcel");    

resp.setHeader("Content-Disposition", "attachment;filename=test.xls");   

objWorkBook.write(out);   

out.close();

} catch(Exception e) {

}

}

  // 워크북 생성
  HSSFWorkbook objWorkBook = new HSSFWorkbook();
  // 워크시트 생성
  HSSFSheet objSheet = objWorkBook.createSheet();
  
  // 행생성
  HSSFRow objRow = objSheet.createRow(0);
  // 셀 생성
  HSSFCell objCell = objRow.createCell(0);
 
//  objWorkBook.set(HSSFCell.ENCODING_UTF_16);
  HSSFRichTextString richTextString = new HSSFRichTextString("연도");
  objCell.setCellValue(richTextString);
  
  objWorkBook.write(response.getOutputStream());

  OutputStream out = response.getOutputStream();  
  response.setCharacterEncoding("utf-8");   
  response.setContentType("application/x-msexcel");   
  response.setHeader("Content-Disposition", "attachment;filename=test.xls");   

  objWorkBook.write(out);  
  out.close();