Importing 'n' number of cells in xlsread while n is not constant!

1 回表示 (過去 30 日間)
ugur uresin
ugur uresin 2018 年 7 月 8 日
コメント済み: ugur uresin 2018 年 7 月 8 日
My code is given below
n=caselist(1,1);
[num, txt] = xlsread('S:/PLOT/PLOT.xlsx', 'B4:B29');
In my data, the start cell (B4) is fixed but the final cell (B29) is not!
So, I'd like to get cells from B4 to B'n' (n: is a variable that points number of cells to be imported).

採用された回答

Paolo
Paolo 2018 年 7 月 8 日
n = caselist(1,1);
range = strcat('B4:B',num2str(n))
[num, txt] = xlsread('S:/PLOT/PLOT.xlsx', range);

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by