POI 创建单元格 并给值

    Workbook wb = new HSSFWorkbook()//.xls

    //Workbook wb = new XSSFWorkbook();//.xlsx

    CreationHelper createHelper = wb.getCreationHelper();

    Sheet sheet = wb.createSheet("new sheet");



    // Create a row and put some cells in it. Rows are 0 based.

    //创建行

    Row row = sheet.createRow((short)0);

    // Create a cell and put a value in it.

    //创建单元格

    Cell cell = row.createCell(0);

    //设置单元格的值为1

    cell.setCellValue(1);



    // 另外一种设置方法

    row.createCell(1).setCellValue(1.2);

    row.createCell(2).setCellValue(

         createHelper.createRichTextString("This is a string"));

    row.createCell(3).setCellValue(true);



    // Write the output to a file

    FileOutputStream fileOut = new FileOutputStream("workbook.xls");

    wb.write(fileOut);

    fileOut.close();