matlab2018导入excel文件出现Exception in thread "AWT-EventQueue-0": java.lang.NullPointerException？

Question

导入一个比较大的excel文件，就会出现如下报错
Exception in thread "AWT-EventQueue-0": java.lang.NullPointerException
at java.util.Objects.requireNonNull(Unknown Source)
at java.util.Arrays$ArrayList.<init>(Unknown Source)
at java.util.Arrays.asList(Unknown Source)
at com.mathworks.mlwidgets.importtool.AbstractFileTableModel.getDefaultColumnVarNames(AbstractFileTableModel.java:139)
at com.mathworks.mlwidgets.importtool.ImportTable.getColumnVariableNamesArray(ImportTable.java:316)
at com.mathworks.mlwidgets.importtool.WorksheetTable.createDefaultColumnsFromModel(WorksheetTable.java:415)
at com.mathworks.mlwidgets.importtool.WorksheetTable.tableChanged(WorksheetTable.java:327)
at javax.swing.table.AbstractTableModel.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableStructureChanged(Unknown Source)
at com.mathworks.mlwidgets.importtool.AbstractFileTableModel.matlabCallback(AbstractFileTableModel.java:853)
at com.mathworks.mlwidgets.importtool.WorksheetTableModel$4$2.run(WorksheetTableModel.java:585)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
页面停留在正在打开大型电子表格，但是始终不出现信息，请问这个问题该怎么解决？

Answer 1

建议尝试以下解决方法：

1.检查是否正确安装了MATLAB的Excel支持包，如果没有安装，可以尝试安装该支持包。

2.检查Excel文件是否存在格式问题，比如单元格格式或者内容不规范等，可以尝试将文件重新排版或者导出为其他格式再尝试导入。

3.尝试使用其他方式导入Excel文件，比如使用MATLAB的xlsread函数或者将Excel文件转化为CSV格式再导入。

4.尝试将Excel文件拆分为多个小文件再导入，以减少导入时的负担。