Using a variable range with xlsread??

2 次查看（过去 30 天）
Matt
Matt 2011-6-13
Hello, I am trying to use xlsread, but I need the range to be variables. for example:
str1 = 'A1'; str2 = 'B5'; Input = xlsread(filename,'str1:str2');
However, this is giving me the following error: "Data range is invalid." Is there a way to do this? Thanks!
-Matt

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

回答（1 个）

Jan
Jan 2011-6-13
'str1:str2' is the string 'str1:str2' - not surprising. But you want to concatenate two (three!) string variables:
str1 = 'A1';
str2 = 'B5';
Input = xlsread(filename,[str1, ':', str2]);
Such methods are explained in the Getting Started chapters of the documentation.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by