creating a string variable to be used in xlswrite

12 views (last 30 days)
antonet
antonet on 13 Jul 2012
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

Accepted Answer

the cyclist
the cyclist on 13 Jul 2012
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.

More Answers (2)

Sean de Wolski
Sean de Wolski on 13 Jul 2012
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

Nirmal
Nirmal on 13 Jul 2012
product={'carrots' 'vegetables' 'tomatoes'};
country={'DE' 'FR' 'UK'};
Name={sprintf('Input_%s_%s.xls',country{1,1},product{1,1})};

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by