Warning: Cannot read drop down range Unrecognized token 43 Exception


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.

Advertisements

One thought on “Warning: Cannot read drop down range Unrecognized token 43 Exception

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s