How to select two (or more) different ranges using xlsread

Question

Daniele Morello 2015-9-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/243805-how-to-select-two-or-more-different-ranges-using-xlsread

评论： Koen Baas 2022-6-27

hi everyone, it's possible to select two or more different ranges using xlsread? for example i need to select columns from A to D ('A:D') and columns from H to M ('H:M')

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

请先登录，再进行评论。

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

Answer 1

Nobel Mondal 2015-9-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/243805-how-to-select-two-or-more-different-ranges-using-xlsread#answer_192875

在 MATLAB Online 中打开

You can patch the function, or write a new one to get the functionality:

Example:

[x,y,z] = xlsreadPatch('test.xlsx', 'Sheet1', {'A1:D10', 'H1:M10'});

Here is a sample function. You can write a similar one (with probably better error handling :) )

function [num, txt, raw] = xlsreadPatch(filename, sheetname, rangecell)
firstRange = rangecell{1};
[num, txt, raw] = xlsread(filename, sheetname, firstRange);
if length(rangecell) > 1
    for k=2:length(rangecell)
        [tNum, tTxt, tRaw] = xlsread(filename, sheetname, rangecell{2});  
          if isempty(num)
              num = tNum;
          else
              num(1:size(tNum,1), end+1:end+size(tNum,2)) = tNum;
          end
          if isempty(txt)
              txt = tTxt;
          else
              txt(1:size(tTxt,1), end+1:end+size(tTxt,2)) = tTxt;
          end 
          raw(1:size(tRaw,1), end+1:end+size(tRaw,2)) = tRaw;
      end
end
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Koen Baas 2022-6-27

在 MATLAB Online 中打开

Hi! Nice function, thank you for sharing. Please change rangecell{2} into rangecell{k} if you want to read in more than 2 ranges. Now it will keep reading in the second range for the 3rd, 4th, etc. range.

Also, I changed "end+1:end+size(tNum,2)" into "k". Please find my modified code below.

function [num, txt, raw] = xlsreadPatch(filename, sheetname, rangecell)
firstRange = rangecell{1};
[num, txt, raw] = xlsread(filename, sheetname, firstRange);
if length(rangecell) > 1
    for k=2:length(rangecell)
        [tNum, tTxt, tRaw] = xlsread(filename, sheetname, rangecell{k});
        if isempty(num)
            num = tNum;
        else
            num(1:size(tNum,1),k) = tNum;
        end
        if isempty(txt)
            txt = tTxt;
        else
            txt(1:size(tTxt,1),k) = tTxt;
        end
        raw(1:size(tRaw,1), k) = tRaw;
    end
end
end