How can I determine last row and pointed out in a xlsread?
5 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Paolo
on 8 Jul 2018
Edited: Paolo
on 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.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!