loading a large excel file to Matlab
显示 更早的评论
Hi,
I have an excel file of 16400 columns and 6000 rows. Is it possible to load it to matlab? I am trying to using the import wizard and i am receiving an error: ??? Undefined function or variable "internalSheetNames".
Error in ==> uiimport>filePreview at 285 numberOfSheets=size(internalSheetNames,1);
??? Error while evaluating com.mathworks.mde.dataimport.ImportProxy FilePreviewEventCallback
回答（3 个）
Nick Haddad
2014-10-3
2 个投票
This issue is a known bug in MATLAB and has been addressed in the following bug report:
The bug report has a workaround which you can install for MATLAB R2013a through R2014b.
Walter Roberson
2011-7-22
1 个投票
Try xlsread() if it is a .xls or .xlsx file; try cvsread() or dlmread() if it is a .csv file.
Oleg Komarov
2011-7-22
0 个投票
16 400 * 6000 * (8 bytes) = 750.732422 megabytes
If you're in windows import the excel in blocks by specifying the range with xlsread.
1 个评论
Ipek
2012-4-26
Thank you so much for your comment, it solved my problem which I've been trying to solve for days... I wish Matlab import wizard could give an error such as "Your data is too big to fit in my memory, I can not import it, try slicing it" rather than just getting stuck in import and make us mad.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2011-7-22
2014-10-3
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
