java 서블릿 jsp 실무교육 진행하는 전문학원
오라클자바 교육센터
자바 jsp추천 실무실습 강좌안내
http://www.oraclejava.co.kr/gspecedu/curri/curri_java.php
<%@ page import="java.io.*,
org.apache.poi.poifs.filesystem.POIFSFileSystem,
org.apache.poi.hssf.record.*,
org.apache.poi.hssf.model.*,
org.apache.poi.hssf.usermodel.*,
org.apache.poi.hssf.util.*" %>
<%
String excelfile = "D:/workspace/webmaster/data_upload/upload_files/AC_ENG_0001_MT_01.xls";
try {
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(excelfile));
//워크북을 생성!
HSSFWorkbook workbook = new HSSFWorkbook(fs);
int sheetNum = workbook.getNumberOfSheets();
//for (int k = 0; k < sheetNum; k++) {
for (int k = 0; k < sheetNum; k++) {
System.out.println( "Sheet Number " + k );
System.out.println( "Sheet Name" + workbook.getSheetName(k));
HSSFSheet sheet = workbook.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 0; r < rows; r++) {
// 시트에 대한 행을 하나씩 추출
HSSFRow row = sheet.getRow(r);
if (row != null ) {
int cells = row.getPhysicalNumberOfCells();
System.out.println( "ROW " + row.getRowNum() + " " + cells );
for (short c = 0; c < cells; c++) {
// 행에대한 셀을 하나씩 추출하여 셀 타입에 따라 처리
HSSFCell cell = row.getCell(c);
if (cell != null) {
String value = null;
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_FORMULA :
value = "FORMULA value=" + cell.getCellFormula();
break;
case HSSFCell.CELL_TYPE_NUMERIC :
value = "NUMERIC value=" + cell.getNumericCellValue(); //double
break;
case HSSFCell.CELL_TYPE_STRING :
value = "STRING value=" + cell.getStringCellValue(); //String
break;
case HSSFCell.CELL_TYPE_BLANK :
value = null;
break;
case HSSFCell.CELL_TYPE_BOOLEAN :
value = "BOOLEAN value=" + cell.getBooleanCellValue(); //boolean
break;
case HSSFCell.CELL_TYPE_ERROR :
value = "ERROR value=" + cell.getErrorCellValue(); // byte
break;
default :
}
System.out.println( "CELL col= " + cell.getCellNum() + " VALUE=" + value );
}
}
}
}
}
}
catch( Exception e ){
e.printStackTrace();
}
%>