How to change range while importing Excel data into MATLAB using xlsread?

4 次查看（过去 30 天）
MathWorks Support Team
回答： MathWorks Support Team 2018-8-21
Hi,
I have to import an excel file, wherein columns and rows can change - how do I specify it in MATLAB Code
YTWstart= xlsread('YTW.xlsx','YTW1','b6:x9') ;
like the last part of the code could be b2 to X25 or b2 to AB21
Please let me know, how can I solve it.

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

采纳的回答

MathWorks Support Team
It is certainly possible to specify range as a variable.
Refer the example below-
beginning = 'A1';
ending = 'B2';
range = [beginning, ':', ending];
[num,txt,raw] = xlsread('myExample.xlsx', range);
You can change the variables '_beginning_' and '_ending_' to change the range.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by