creating a string variable to be used in xlswrite

2012 7 13
3 个回答
回答已采纳
5 次查看（30 天）

0 个投票

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

请先登录，再回答此问题。

 采纳的回答

the cyclist
the cyclist 2012-7-13

0 个投票

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.

更多回答（2 个）

Sean de Wolski
Sean de Wolski 2012-7-13

1 个投票

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 2012-7-13

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by