CODEWITHSUNDEEP
excelmatlabimportdata-analysis
user3166834
user3166834

Reputation: 31

MATLAB: Importing data into Matlab from an Excel Sheet with 100,000 rows and 300 columns

I have a huge data that comes in an excel file of about 100,000 rows and 300 columns. I'd like to import this data into Matlab to do some analysis.

Basicly, xlsread command does not work. Does anyone know how to effectively import this data into Matlab?

Thanks in advance!

Upvotes: 3

Views: 4948

Answers (1)

Dennis Jaheruddin
Dennis Jaheruddin

Reputation: 21563

As mentioned on matlab central, by @Oleg, it should be possible to read and store the file block by block.

This can be done by using the range input argument as mentioned in the doc:

num = xlsread(filename,xlRange)example
num = xlsread(filename,sheet,xlRange)example
num = xlsread(filename,sheet,xlRange,'basic')

I would say start with 1 row first, and then see whether you can do a few thousand.

Upvotes: 2

Related Questions