Naver Search API 활용 Excel에서 Cell의 데이터타입 알아보기

# Naver Search API 활용 Excel에서 Cell의 데이터타입 알아보기

## 작업소스

• 아래와 같이 엑셀 파일 생성하여 저장.

cellDataType.xls

0.02MB

• 아래와 같이 작업하여 셀타입 확인 가능.

import java.io.FileInputStream;
import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;

public class Project03_C {
	public static void main(String[] args) {
		String fileName = "cellDataType.xls";
		
		try (FileInputStream fis = new FileInputStream(fileName)) {
			
			HSSFWorkbook workbook = new HSSFWorkbook(fis);
			
			HSSFSheet sheet = workbook.getSheetAt(0);
			Iterator<Row> rows = sheet.rowIterator();
			
			while (rows.hasNext()) {
				HSSFRow row = (HSSFRow) rows.next();
				Iterator<Cell> cells = row.cellIterator();
				
				while (cells.hasNext()) {
					HSSFCell cell = (HSSFCell) cells.next();
					CellType type = cell.getCellType();
					
					if (type == CellType.STRING) {
						System.out.println("[" + cell.getRowIndex() 
								+ "," + cell.getColumnIndex() + "]"
								+ " = STRING; Value : " + cell.getRichStringCellValue());
					} else if (type == CellType.NUMERIC) {
						System.out.println("[" + cell.getRowIndex() 
						+ "," + cell.getColumnIndex() + "]"
						+ " = NUMERIC; Value : " + cell.getNumericCellValue());
					} else if (type == CellType.BOOLEAN) {
						System.out.println("[" + cell.getRowIndex() 
						+ "," + cell.getColumnIndex() + "]"
						+ " = BOOLEAN; Value : " + cell.getBooleanCellValue());
					} else if (type == CellType.BLANK) {
						System.out.println("[" + cell.getRowIndex() 
						+ "," + cell.getColumnIndex() + "]"
						+ " = BLANK; Value : BLANK CELL");
					}					
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}