개발/삽질
POI HSSF ~ 이용 엑셀파일 만들기
백아절현
2008. 7. 16. 10:34
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("sheet1"); //시트생성
HSSFRow rows = sheet1.createRow(0); //로우생성
HSSFCell cell = rows.createCell((short) 0); //셀생성 <-- 요놈 안적어서 파일이 안만들어지다니..;
rows.createCell((short) 1).setCellValue("test1");
rows.createCell((short) 2).setCellValue("test2");
String root = request.getSession().getServletContext().getRealPath("/WEB-INF/FileData");
FileOutputStream fileOut = new FileOutputStream(root+"/PPWSB0090A/sample1.xls");
wb.write(fileOut); //파일생성
fileOut.close();
참고 : http://blog.naver.com/btchae/80005156571
HSSFSheet sheet1 = wb.createSheet("sheet1"); //시트생성
HSSFRow rows = sheet1.createRow(0); //로우생성
HSSFCell cell = rows.createCell((short) 0); //셀생성 <-- 요놈 안적어서 파일이 안만들어지다니..;
rows.createCell((short) 1).setCellValue("test1");
rows.createCell((short) 2).setCellValue("test2");
String root = request.getSession().getServletContext().getRealPath("/WEB-INF/FileData");
FileOutputStream fileOut = new FileOutputStream(root+"/PPWSB0090A/sample1.xls");
wb.write(fileOut); //파일생성
fileOut.close();
참고 : http://blog.naver.com/btchae/80005156571