loading a large excel file to Matlab
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
0 Commenti
Risposte (3)
Nick Haddad
il 3 Ott 2014
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.
0 Commenti
Walter Roberson
il 22 Lug 2011
Try xlsread() if it is a .xls or .xlsx file; try cvsread() or dlmread() if it is a .csv file.
Oleg Komarov
il 22 Lug 2011
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 Commento
Ipek
il 26 Apr 2012
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.
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!