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 日

0 投票

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 日

0 投票

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

カテゴリ

ヘルプ センター および File ExchangeData 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