MATLAB: Xlsread certain range of rows

MATLABrangerowxlsread

Hi,

I have a very large excel file. When I used xlsread command it took very long time to read entire range. Therefore, I want to read just a part of it.

Column: Same as xlsread.

Row: 1:10000.

When I tried, xlsread(File,sheet,'1:1000'), it read all columns of 10645(?). However, I want to read the range of columns that xlsread loads automatically. I just want to cut off certain range of rows. Deleting rows after loading whole data is not an option because it took too much time.

Thank you.

Best Answer

You can enter any rectangular range argument to xlsread in Excel A1:X200 syntax. You must, however, know the ranges of interest this way. Or, create a named area in the spreadsheet that comprises the area of interest. It must also be contiguous, hence rectangular.

Related Solutions

MATLAB: Import dat from excel to matlab

Hi,

a hint:

doc xlsread

Titus

MATLAB: How to retrieve a specific range of values from a cell

Let's say your cell is called data and this is a 1 by 4 cell array with each cell containing column vectors of size 685 x 1. You can access the data directly using the following code:

data{1,1}(15:25,1)
data{1,2}(15:25,1)
data{1,3}(15:25,1)
data{1,4}(15:25,1)

You could also take rows 15:25 from each cell in your cell array as follows:

numarray=cell2mat(cellfun(@(x) x(15:25), data, 'UniformOutput', false))
plot(numarray)

TLDR;

If your cells are always the same size you can do the following:

numarray=cell2mat(data);
plot(numarray(15:25,:))

Best Answer

Related Solutions

MATLAB: Import dat from excel to matlab

MATLAB: How to retrieve a specific range of values from a cell

Related Question