今天jxl读excel时,报了这个错误,以为是office版本问题,或者引入包版本问题
解决办法:
WorkBookSetting设定一下disableVlidate(true)再实例化Workbook类就可以了,代码如下
WorkbookSettings workbooksetting = new WorkbookSettings();
workbooksetting .setCellValidationDisabled(true);
Workbook wb = Workbook.getWorkbook(is,workbooksetting);