How can I determine last row and pointed out in a xlsread?

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.

Answer 1

[Paolo]

You may use this FEX submission for the task.

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.

[ugur uresin]

Thank you so much for your effort!