Hi, how can i import data from many worksheet in Excel? Can i used a cicle for?please help me

Hi, how can i import data from many worksheet in Excel? Can i used a cicle for?please help me

[Giuseppe Zaccaro]

I have tried to write: [A]=xlsread('prove.xlsx','15x5_003','A3:A3603'); [B]=xlsread('prove.xlsx','15x5_003','B3:B3603'); plot(A,B)

but i need to do this many time for many worksheets,so I have proved with a for loop,but without success function cnr1 for i=0:5 [A]=xlsread('prove.xlsx','15x5_003+i','A3:A3603'); [B]=xlsread('prove.xlsx','15x5_003+i','B3:B3603'); plot(A,B) end

Answer 1

[George]

You're trying to use i as your loop index. (Conventionally ii would be used to avoid confusion with i = sqrt(-1) )

However, in your calls to xlsread you're using i as part of the string. e.g.,

[A]=xlsread('prove.xlsx','15x5_003+i','A3:A3603');

treats '15x5_003+i' as char array and it won't interpolate the index variable.

Try

[A]=xlsread('prove.xlsx',['15x5_003+' int2str(i)],'A3:A3603');

which will concatenate the first bit with the string representation of i. (I'd still refactor this to ii.)