Error in importing data from Excel file (new today--did not have same error yesterday)

I am trying to import data from an Excel file. I had no problem importing data from this file yesterday, but today I get this error:
??? Java exception occurred: java.lang.NullPointerException at java.util.Hashtable.get(Hashtable.java:334)
Error in ==> uiimport>variablePreview at 599 sheetName=sn_htable.get(char(getSheetName(b)));
??? Error while evaluating com.mathworks.mde.dataimport.ImportProxy VariablePreviewEventCallback
I have tried copying the data into a new workbook and saving it, but that doesn't work either. Any suggestions? Thanks!

Answers (2)

This appears to be a problem with the Excel version. I have saved it an old Excel format, and now I can import it!
The error seems to indicate that the problem in your Excel file is that it has a worksheet with an empty name (title).

Categories

Asked:

Jen
on 29 Aug 2011

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!