Using writetable in a loop to save each iteration as a new line
13 次查看(过去 30 天)
显示 更早的评论
I am trying to use writetable in a loop so that each iteration prints on a new line. Since the data is only one row, I would want something like A1, A2, A3... but it seems like this can't be done because 'A1' is a string. This is what I have:
for w = 1:n %each folder has a different number of files defined by n
T(1:1,:)
writetable(T,filename, 'Sheet',1,'Range', 'A(w)') %this needs to be 'A1' to assign the location of the table, but is there a way to use A(index)?
end
Thanks a bunch
0 个评论
采纳的回答
Chenchal
2017-11-3
use ['A' num2str(w)] where w = 1 or a loop var
% code
writetable(T,filename,'Sheet',1,'Range', ['A' num2str(w)])
2 个评论
William Harris
2021-9-30
To keep the headings you can use an if clause:
init_cell = sprintf( 'A%s',num2str(count) );
if count == 1
writetable(T, filename, 'Sheet', 1, 'Range', init_cell);
else
writetable(T, filename, 'Sheet', 1, 'Range', init_cell, 'WriteVariableNames', false);
end
However, I am getting an issue with this where the final table doesn't include the first row of data. Does anyone have a fix for this?
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!