I have two columns of excel data which I want to be imported using xlsread based on certain criteria, but I can only get one column to be selected.

Question

Kyle Reagan 2017-6-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/344449-i-have-two-columns-of-excel-data-which-i-want-to-be-imported-using-xlsread-based-on-certain-criteria

评论： Kyle Reagan 2017-6-12

I have an excel file with two columns. The first is a numerical date column (e.g. 7.3685e+05) and the next column is text corresponding to each date. I have a matlab code which searches the excel date column based on a date > day1 & < day2 which the user specifies using a calendar GUI. The code is shown below. b returns a 3x1 matrix with the correct dates, however the problem is that I want a 3x2 matrix with the text in the second column. Anyone know how to make it return both columns?

day1 = uigetdate;
day2 = uigetdate;
[~,~,rawMN] = xlsread('PracticeFile','sheet1','M500:N703');
b = rawMN(cellfun(@(x) ~isempty(x) && isnumeric(x) && x>= day1 && x <= day2, rawMN));