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

2018 8 21
1 个回答
回答已采纳
更新时间：2018 8 21
7 次查看（30 天）

0 个投票

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.

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

 采纳的回答

0 个投票

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 个）

类别

在 帮助中心 和 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