MATLAB: How to select all values of a cell array between two cells

arraysdataselecting groups of datatablesxlsread

I was previously using 3 xlsread functions, and I realized this probably wasn't the best way to go about it. I was reading some data from tables, so using xlsread, I was able to specify what cells I want read (in this case, B2:P14). How would I do something similar in matlab (because table/array size may vary, how would I just go about getting all data located after (2,2), instead of from (2,2) to (14,16), for example)?

Best Answer

V=xlsread('file.xlsx')
out=V(2:end,2:end)

Related Solutions

MATLAB: Condition and xlsread

I think that if you're simply looking to see if there is data in the cell, you can just use the ISEMPTY function. Something like this:

xlswrite('test.xls',magic(2))
if isempty(xlsread('test.xls','Sheet1','A4'))
   disp('The cell is empty')
else
   disp('The cell contains a value')
end

Although, it would probably be better, since you're using XLSREAD anyway, to read the data into a variable.

What is your goal? Maybe I can be of more help if I better understand what you are trying to do.

MATLAB: How to clear the contents of Excel by sheet

Would it meet your need to write an array of empty strings ("") instead?

Best Answer

Related Solutions

MATLAB: Condition and xlsread

MATLAB: How to clear the contents of Excel by sheet

Related Question