issues with importing large excel file into matlab

3 views (last 30 days)
HI I'm trying to import a large excel file into matlab. It is about 207 columns and 97805 rows. It is taking a very long time to read into the Matlab (~2 hours) and when it finally does, I'm having issues with it freezing or getting locked and preventing me from any further analysis.
I've tried uploading the file several times and only got it to actually import once, however after importing I was unable to create matrices (by selecting the rows/columns I wanted) in order to complete the process and begin analysis.
I'm running matlabv2012 and using the linux_64bit edition.
Any suggestions are appreciated. Thanks!
  2 Comments
dpb
dpb on 2 Jun 2014
What are you using to read the file? What's the form of the file--is it an actual .xls[x] file or csv? I'm not terribly surprised Matlab has some trouble w/ a file on machines not having native Excel; is there any way you can have the file created in a more platform-independent-friendly fashion (like stream if all numeric or even csv? I'd guess you'd have better luck even with the latter and the former would be piece o' cake...

Sign in to comment.

Answers (0)

Categories

Find more on Large Files and Big Data in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!