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

2 Ansichten (letzte 30 Tage)
ugur uresin
ugur uresin am 8 Jul. 2018
Kommentiert: ugur uresin am 8 Jul. 2018
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).

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

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

Weitere Antworten (0)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by