엑셀 자바로 다루기

public class ReadCell {

    @Test
    public void readByPOI() throws Exception {
        POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("Book1.xls"));
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        HSSFSheet sheet = wb.getSheetAt(0);
        HSSFRow row = sheet.getRow(0);
        HSSFCell cell = row.getCell((short) 0);
        assertEquals("A1한글", cell.getRichStringCellValue().toString());
    }

    @Test
    public void readByJExel() throws Exception {
        Workbook workbook = Workbook.getWorkbook(new File("Book1.xls"));
        Sheet sheet = workbook.getSheet(0);
        Cell a1 = sheet.getCell(0, 0);
        assertEquals("A1한글", a1.getContents());
    }
}