Xlswrite, strfind, excel problem.

2016 12 13
2 个回答
回答已采纳
更新时间：2016 12 13
7 次查看（30 天）

0 个投票

My excel file is been created as shown at "result.jpg".
I want something as shown at "WhatIWant.jpg"
The txt file is uploaded as "items.txt"
Thanks.
function x=testt()
fid = fopen('items.txt','r');
k=1;
while 1
tline = fgetl(fid);
if strfind(tline, 'AbilityCooldown')>0
x=strfind(tline, 'AbilityCooldown')
% tline(x:end)
sprintf('%s %f',tline)
my_cell = sprintf( 'A%s',num2str(k) );
xlswrite('testitens2.xlsx',tline,'Sheet1',my_cell);
k=k+1;
end
if ~ischar(tline)
break
end
end
end

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

 采纳的回答

KSSV
KSSV 2016-12-13

0 个投票

fid = fopen('items.txt') ;
S = textscan(fid,'%s','delimiter','\n') ;
S = S{1} ;
idx = strfind(S, 'AbilityCooldown');
idx = find(not(cellfun('isempty',idx)));
%
ACD = S(idx) ;
b=regexp(ACD,'\d+(\.)?(\d+)?','match') ;
iwant=str2double([b{:}])
You have the AbilityCooldown numbers in array, you can write into excel at a stretch.

更多回答（1 个）

Lucas Santana
Lucas Santana 2016-12-13

0 个投票

Thanks a lot! My program works fine but im having trouble on fully understanding what this code do. Could you explain for me?
idx = strfind(S, 'AbilityCooldown');
idx = find(not(cellfun('isempty',idx)));
%
ACD = S(idx) ;
b=regexp(ACD,'\d+(\.)?(\d+)?','match') ;
iwant=str2double([b{:}])
Here is my final program.
function x=testt()
fid = fopen('items.txt') ;
S = textscan(fid,'%s','delimiter','\n') ;
S = S{1} ;
idx = strfind(S, 'AbilityCooldown');
idx = find(not(cellfun('isempty',idx)));
%
ACD = S(idx) ;
b=regexp(ACD,'\d+(\.)?(\d+)?','match') ;
iwant=str2double([b{:}])
y=size(iwant)
tit{1}='AbilityCooldown';
my_cell = sprintf( 'B%s',num2str(1) );
xlswrite('testitens2.xlsx',tit,'Sheet1',my_cell);
for k=1:y(2)
my_cell = sprintf( 'B%s',num2str(k+1) );
xlswrite('testitens2.xlsx',iwant(k),'Sheet1',my_cell);
end
x=0;
end

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by