java POI创建Excel文件及Sheet

一、代码

   //Workbook wb = new XSSFWorkbook();    //FileOutputStream fileOut = new FileOutputStream("E:\\standarcode\\workbook.xlsx");Workbook wb = new HSSFWorkbook();    FileOutputStream fileOut = new FileOutputStream("E:\\standarcode\\workbook.xls");    Sheet sheet1 =  wb.createSheet("new sheet");    Sheet sheet2 =  wb.createSheet("second sheet");        // Note that sheet name is Excel must not exceed 31 characters    // and must not contain any of the any of the following characters:    // 0x0000    // 0x0003    // colon (:)    // backslash (\)    // asterisk (*)    // question mark (?)    // forward slash (/)    // opening square bracket ([)    // closing square bracket (])    // You can use org.apache.poi.ss.util.WorkbookUtil#createSafeSheetName(String nameProposal)}    // for a safe way to create valid names, this utility replaces invalid characters with a space (' ')    String safeName = WorkbookUtil.createSafeSheetName("[O'Brien's sales*?]"); // returns " O'Brien's sales   "    Sheet sheet3 =  wb.createSheet(safeName);    wb.write(fileOut);    fileOut.close();

二、注意点

1、sheet的名字的长度不能超过31个字符，若是超过的话，会自动截取前31个字符;
2、sheet的名字不能包含如下字符串：
// 0x0000
    // 0x0003
    // colon (:)
    // backslash (\)
    // asterisk (*)
    // question mark (?)
    // forward slash (/)
    // opening square bracket ([)
    // closing square bracket (])
若是包含的话，会报错。但有一个解决此问题的方法，就是调用org.apache.poi.ss.util.WorkbookUtil的createSafeSheetName(String nameProposal)方法来创建sheet name,若是有如上特殊字符，它会自动用空字符来替换掉，自动过滤。