[POI] 셀타입 통화로 만들 때.

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) {

}

}