how to save each iteration values without overwriting in a loop ?
1 次查看(过去 30 天)
显示 更早的评论
hi, i spliting strings into cell array and storing of each value in each cell in MS excel is done..but while coming to do same for many files in loop and append them .i couldnt move ahead..stuck here..help needed plz
TESTDATA_20120807_1826 0 +1.107672E+1 +6.204607E+0 +1.513477E+1
..i need to do 10 files and need to append in excel file..i tried, stuck here in writing to my output file ..help needed
pathName = 'F\run\';
fileList = dir(fullfile(pathName, '*.run'));
out = fopen(fullfile(pathName, 'append.xls'), 'w');
for k = 1:numel(fileList)
s = fileread(fullfile(pathName, fileList(k).name));
a=regexp(s,' ','split');
b=a(~cellfun(@isempty ,a));
fwrite(out, b, 'char');
end
fclose(out);
0 个评论
回答(1 个)
Walter Roberson
2013-8-12
fprintf() instead of fwrite(), and be sure to insert the delimiters between the fields. Or are you trying to write a binary .xls file? If so then do not try to use fwrite() yourself for that purpose: use xlswrite()
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!