loading a large excel file to Matlab
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (3)
Nick Haddad
el 3 de Oct. de 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 comentarios
Walter Roberson
el 22 de Jul. de 2011
Try xlsread() if it is a .xls or .xlsx file; try cvsread() or dlmread() if it is a .csv file.
Oleg Komarov
el 22 de Jul. de 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 comentario
Ipek
el 26 de Abr. de 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.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!