清空筛选条件
清空筛选条件

using the Xlsread functon

1 次查看（过去 30 天）
Ahmed BOULMANE
Ahmed BOULMANE 2015-7-15
评论： Ahmed BOULMANE 2015-7-15
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 个评论
显示 1更早的评论
Ahmed BOULMANE
Ahmed BOULMANE 2015-7-15
i want to use it to build a file name: using that : name = ['txt file\',FileName,'.txt']
Ahmed BOULMANE
Ahmed BOULMANE 2015-7-15
So I need another function that can give me the possibility to use the texts that I recovers from the excel file as normal texts

请先登录，再进行评论。

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

采纳的回答

Brendan Hamm
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
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!

Translated by