Function with xlsread including the excel file name as input variable

Hi,

I have the following problem: I have multiple excel files named after countries, e.g. US,UK,FRA,JPN,... .

Now I want to write a function, which takes the name of the excel file as input string, e.g. 'JPN' and then loads the corresponding excel file e.g. data = xlsread('JPN',sheet1).

I tried using eval, but could'nt get it to work.

Best and thanks in advance, Chris

Answer 1

[Walter Roberson]

filename = 'JPN';
data = xlsread(filename, sheet1);

[Christian F.]

Didn't expect it to be that simple.

Thanks alot!

Answer 2

[Christian F.]

Maybe I should ad that I also want the variable, to which the data is stored, to be the named after the respective country, e.g. JPN = xlsread(JPN);

[Walter Roberson]

http://matlab.wikia.com/wiki/FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F

[Christian F.]

thanks!