using the Xlsread functon
조회 수: 2 (최근 30일)
이전 댓글 표시
hello! i used the function xlsread to do that:
[num,txt]=xlsread(nameoffile,'C:C')
then
txt(indice,1)='xxxxxxxxxxxxx'
so, when i do that:
FileName =txt(indice,1)
==> the result is :
FileName= 'xxxxxxxxxxxx'
but me, i want to do that: FileName='xxxxxxxxxxxx' ==> FileName=xxxxxxxxxxxx in order to use FileName in my script
댓글 수: 3
채택된 답변
Brendan Hamm
2015년 7월 15일
The issue is that txt is a cell array which contains char-arrays. So you need to use curly brackets to extract the character array back out.
FileName = txt{indice,1} % Curly Brackets!
name = ['txt file\',FileName,'.txt']
댓글 수: 2
Brendan Hamm
2015년 7월 15일
Sorry, almost missed the fact that:
txt(indice,1)='xxxxxxxxxxxxx'
is an invalid statement. You need curly brackets here too.
txt{indice,1}='xxxxxxxxxxxxx'
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!