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

6 次查看(过去 30 天)
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!

回答(2 个)

Jen
Jen 2011-8-29
This appears to be a problem with the Excel version. I have saved it an old Excel format, and now I can import it!

Yair Altman
Yair Altman 2011-9-10
The error seems to indicate that the problem in your Excel file is that it has a worksheet with an empty name (title).

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by