JAVA 读写excle 之POI

五、读取不同的数据类型

 

---

---

---

四、读取excel

@Test
public void readExcele() throws Exception {
    FileInputStream fis = new FileInputStream("jinhua.xls");

    Workbook wb = new XSSFWorkbook(fis);
// new XSSFWorkbook(fis);
// new SXSSFWorkbook(fis);

    Sheet sheet = wb.getSheetAt(0);
    Row row = sheet.getRow(0);
    Cell c1 = row.getCell(0);
    System.out.println(c1.getStringCellValue());
}

 

 

---

---

---

---

三、03版本和07版本写入excle文件

@Test
public void createExcele() throws IOException {
    //创建工作薄