Using a variable range with xlsread??
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
0 Commenti
Risposte (1)
Jan
il 13 Giu 2011
'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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Graphics Object Programming in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!