支持：xls （HSSF）、xlsx（XSSF）、word（HWPF）、powerpoint（HSLF）、visio（HDGF）读写
poi
工作簿workbook、工作表sheet、行、列、单元格
@Test
public void test1() throws IOException {
Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet();
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("第一行第一个单元格");
Row row2 = sheet.createRow(1);
Cell row2cell1 = row.createCell(0);
cell.setCellValue("第二行第一个单元格");
FileOutputStream fileOutputStream = new FileOutputStream("f:/1.xls");
workbook.write(fileOutputStream);
fileOutputStream.close();
}
@Test
public void test2() throws IOException {
FileInputStream fileInputStream = new FileInputStream("f:/1.xls");
Workbook workbook = new HSSFWorkbook(fileInputStream);
Sheet sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(0);
Cell cell = row.getCell(0);
System.out.println(cell.getStringCellValue(););
fileInputStream.close();
}
