creating a string variable to be used in xlswrite

Dear all,

I have

[N,T,R]=xlsread(Name);

where

Name={'Input_DE_carrots.xlsx'}

The DE which represents the country changes for every country as well as the name of the product which in the previous example is "carrots"

I want to have

product={'carrots' 'vegetables' 'tomatoes'}

country={'DE' 'FR' 'UK'}

Name={'Input_country(1)_product(1).xlsx'}

[N,T,R]=xlsread(Name);

How can I do that?

thanks

Answer 1

[the cyclist]

Name=['Input_',country{1},'_',product{1},'.xlsx']

Note the use of curly brackets when accessing the cell arrays, in order to get at the contents of the cell, not the cell element itself.

Answer 2

[Sean de Wolski]

product={'carrots' 'vegetables' 'tomatoes'}
country={'DE' 'FR' 'UK'}
for ii = 1:numel(product)
  sprintf('%s_%s_%i',product{ii},country{ii},ii)
end

And for more info:

doc sprintf

Answer 3

[Nirmal]

product={'carrots' 'vegetables' 'tomatoes'};

country={'DE' 'FR' 'UK'};

Name={sprintf('Input_%s_%s.xls',country{1,1},product{1,1})};

[antonet]

thank you all of you