Warning: Cannot read drop down range Unrecognized token 43

2014-11-24 07:48:35 · 作者: · 浏览: 2

今天jxl读excel时,报了这个错误,以为是office版本问题,或者引入包版本问题

解决办法:
WorkBookSetting设定一下disableVlidate(true)再实例化Workbook类就可以了,代码如下

WorkbookSettings workbooksetting = new WorkbookSettings();
workbooksetting .setCellValidationDisabled(true);
Workbook wb = Workbook.getWorkbook(is,workbooksetting);



摘自 Intlgj的专栏