creating a string variable to be used in xlswrite
조회 수: 2 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
채택된 답변
the cyclist
2012년 7월 13일
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.
댓글 수: 0
추가 답변 (2개)
Sean de Wolski
2012년 7월 13일
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
댓글 수: 0
Nirmal
2012년 7월 13일
product={'carrots' 'vegetables' 'tomatoes'};
country={'DE' 'FR' 'UK'};
Name={sprintf('Input_%s_%s.xls',country{1,1},product{1,1})};
참고 항목
카테고리
Help Center 및 File Exchange에서 Numeric Types에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!