If you get the exception mentioned while using the JExcel API for reading the content of Microsoft Files;
Warning: Cannot read drop down range Unrecognized token 43 Exception
Try to add the following lines of code before getting the first sheet of the Excel Document.
//Warning: Cannot read drop down range Unrecognized token 43 WorkbookSettings workbooksetting = new WorkbookSettings(); workbooksetting.setCellValidationDisabled(true); Workbook workbook = Workbook.getWorkbook(new File("C:\\yourexcelfile.xls"),workbooksetting);
However, I think this is a temporary solution for the problem, it is better if you take care of the Excel document’s format before reading it using the JExcel API.