Recognizing empty spaces in excel file

Question

Saeid 2017-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/321909-recognizing-empty-spaces-in-excel-file

编辑： Guillaume 2017-1-25

Imagine a section of an Excel file of the form shown below:

I can already have MATLAB find the values under the column named "AMPLITUDE" using:

[NUMM,STRR,RAWW]=xlsread('FILENAME.xlsx',1);

[ii,jj] = find(strncmpi(RAWW, 'AMPLITUDE',10))

However, I want my array to be limited to the values starting immediately under the Title AMPLITUDE and ending before the next series start (again at Q1, then Omega/Hz etc.). In this case I am only interested at the values between 0,268 and 399,729. How can I limit the reading to this section without explicitly knowing the number of lines containing these values?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2017-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/321909-recognizing-empty-spaces-in-excel-file#answer_251999

编辑：Guillaume 2017-1-25

在 MATLAB Online 中打开

[~, ~, raw] = xlsread(somefile, 1);
[startrow, ~] = find(strncmpi(raw, 'AMPLITUDE', numel('AMPLITUDE')));
endrow = find(cellfun(@(x) ~isstr(x) && isnan(x), raw(startrow:end, startcol)), 1);
selecteddata = raw(startrow:endrow, :)
%or
selecteddata = cell2table(raw(startrow+1:endrow, :), 'VariableNames', matlab.lang.makeValidName(raw(startrow, :)))