清空筛选条件
清空筛选条件

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

2 次查看（过去 30 天）
ugur uresin
ugur uresin 2018-7-8
评论： ugur uresin 2018-7-8
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.

请先登录，再回答此问题。

采纳的回答

Paolo
Paolo 2018-7-8
编辑：Paolo 2018-7-8
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by