代码2

WorkbookSettings workbookSetting = new WorkbookSettings();
            workbookSetting.setDrawingsDisabled(true);
            // 解决总是提示cannot add data validity settings
            workbookSetting.setCellValidationDisabled(true);
//            workbookSetting.setEncoding("Unicode");
            InputStream is = new FileInputStream(fileName);
            wb = Workbook.getWorkbook(is, workbookSetting);
            System.out.println(Arrays.toString( wb.getRangeNames() ));