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!

답변 (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).

카테고리

도움말 센터File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

질문:

Jen
2011년 8월 29일

Community Treasure Hunt

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

Start Hunting!

Translated by