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

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

Answer 1

[Chenchal]

use ['A' num2str(w)] where w = 1 or a loop var

    % code
  writetable(T,filename,'Sheet',1,'Range', ['A' num2str(w)])

[Eric Jenkins]

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]

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?