Using writetable in a loop to save each iteration as a new line

15 次查看（过去 30 天）
Eric Jenkins
Eric Jenkins 2017-11-3
评论： William Harris 2021-9-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

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

采纳的回答

Chenchal
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 个评论
Eric Jenkins
Eric Jenkins 2017-11-3
Thank you so much, this worked great. I did run into the issue of the table heading messing up the output when I write to an xls file, because as the file was incremented per row, the heading was taking up the allocated row. But I did a quick fix using:
'WriteVariableNames', false
I am not sure if there is a better way to do this where I could keep only the first row of headings?
William Harris
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by