How can I determine last row and pointed out in a xlsread?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
ugur uresin
am 8 Jul. 2018
Kommentiert: ugur uresin
am 8 Jul. 2018
My code is below:
[num, txt] = xlsread('S:/PLOT/PLOT.xlsx', 'D1:XFD1');
XFD1 is the last row in excel and it takes time!
Instead of writing XFD in this code, I'd like to write the name of the cell up to n lines from D1.
*
Example: Let n = 3.
D E F G
The code should scan from D1 to G1.
0 Kommentare
Akzeptierte Antwort
Paolo
am 8 Jul. 2018
Bearbeitet: Paolo
am 8 Jul. 2018
For n = 3:
starting_letter = 'D';
offset = xlscol(starting_letter);
n = 3+offset;
final_letter = xlscol(n);
range = strcat(starting_letter,num2str(1),':',final_letter,num2str(1));
Range:
'D1:G1'
For n= 16380
starting_letter = 'D';
offset = xlscol(starting_letter);
n = 16380+offset;
final_letter = xlscol(n);
range = strcat(starting_letter,num2str(1),':',final_letter,num2str(1));
Range:
'D1:XFD1'
In general, to find n, call the function with the name of the cell:
xlscol('XFD')
and subtract four to account for the offset.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!