issues with importing large excel file into matlab

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

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...
Can you upload the file?

Sign in to comment.

Answers (0)

Categories

Asked:

on 2 Jun 2014

Commented:

on 3 Jun 2014

Community Treasure Hunt

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

Start Hunting!