How can Looping (open text files, processing and save as Excel file) for multi times ?

Question

Furat Alobaidy 2019-11-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/493601-how-can-looping-open-text-files-processing-and-save-as-excel-file-for-multi-times

回答： Furat Alobaidy 2019-11-28

Hi , Please , i have multi text files , i need looping : open ,processing, saving the results as excel file . repeat this process multi times based on number of text files , i have the code for open , processing , and save, process and save as excel for one file each time! so i should change text file name and excel file name munally each time !.

% How can repeat this process for multi text files ?
fid = fopen('stats1.txt','r');
strData = textscan(fid,'%s','Delimiter','\r\n');
strData = strData{1};
fclose(fid);
% Eliminate empty line(s) and the line(s) which contains '--'
idx1 = cellfun(@isempty,strData);
idx2 = contains(strData,'--');
strData = strData(~idx1 & ~idx2);
% Insert space before '#'
strData = replace(strData,'#',' #');
% Replace 3 or more consecutive spaces to 2 consecutive spaces
strData = regexprep(strData,'\s{3,}','  ');
% Prepare the output cell array
outData = cell(size(strData,1),6);
% Split each line with 2 consecutive spaces
for kk = 1:size(strData,1)
  c = strsplit(strData{kk},'  ');
  outData(kk,[1:numel(c)-1, end]) = c;
end
% Save as Excel file
writecell(outData,'result1.xlsx');

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Furat Alobaidy 2019-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/493601-how-can-looping-open-text-files-processing-and-save-as-excel-file-for-multi-times#answer_403838

Still i have problem with this insturaction : how can avoid that ?Please

%% Save result file
xlswrite(result,strcat(outDirectory,text_files(i).name));

Error using xlswrite:

File name must be a string scalar or character vector.

Error in:

xlswrite(outData,strcat(outDirectory,text_files(i).name));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2019-11-28

在 MATLAB Online 中打开

Try it this way:

%% Save result file
fullFileName = fullfile(outDirectory, text_files(i).name)
xlswrite(result, outDirectory,text_files(i).name);

请先登录，再进行评论。

Answer 2

KALYAN ACHARJYA 2019-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/493601-how-can-looping-open-text-files-processing-and-save-as-excel-file-for-multi-times#answer_403734

在 MATLAB Online 中打开

text_files=dir('C:\complete path....\folder_name\*.txt');
outDirectory='C:\complete path....\folder_name\';
for i=1:length(text_files)
text_file=strcat('C:\complete path....\folder_name\',text_files(i).name);
text_data=(textscan(text_file));
%% Do operation say result
%% Save result file
xlswrite(result,strcat(outDirectory,text_files(i).name));
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Furat Alobaidy 2019-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/493601-how-can-looping-open-text-files-processing-and-save-as-excel-file-for-multi-times#answer_403833

编辑：Furat Alobaidy 2019-11-28

thanks for your help , but its gave me error :

Error using xlswrite (line 170)

File name must be a string scalar or character vector.

Error in test2 (line 26)

xlswrite(outData(i),strcat(outDirectory,text_files(i).name));

outDirectory='C:\Users\...\1-FromStatstoExcel\';
txtpattern = fullfile(outDirectory, '*.txt');
text_files = dir(txtpattern);
for i=1:length(text_files)
fid=strcat('C:\Users\...\1-FromStatstoExcel\',text_files(i).name);
strData=textscan(fid,'%s','Delimiter','\r\n');
strData = strData{1};
% Eliminate empty line(s) and the line(s) which contains '--'
idx1 = cellfun(@isempty,strData);
idx2 = contains(strData,'--');
strData = strData(~idx1 & ~idx2);
% Insert space before '#'
strData = replace(strData,'#',' #');
% Replace 3 or more consecutive spaces to 2 consecutive spaces
strData = regexprep(strData,'\s{3,}','  ');
% Prepare the output cell array
outData = cell(size(strData,1),6);
% Split each line with 2 consecutive spaces
for kk = 1:size(strData,1)
  c = strsplit(strData{kk},'  ');
  outData(kk,[1:numel(c)-1, end]) = c;
end
 xlswrite(outData(i),strcat(outDirectory,text_files(i).name));
end