How to for loop readtable and writetable range?

Question

Anilcan Taner 2021-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/813055-how-to-for-loop-readtable-and-writetable-range

评论： Anilcan Taner 2021-4-26

Let's say I have a worksheet consist of words and numbers. I want to change certain cells or cell groups with a for loop. How may I handle it?

data=readtable('test4.xls','ReadVariableNames',0,'Range','Ex:Fx');
writetable(A, 'test4.xls','WriteVariableNames',0, 'Range', 'BX:CX');

I want the "x" values here to be change as for loop goes on from i=1:10, lets say.

(To be more clear, if i = 3 the range will be E3:F3)

Btw, the solution has to in this form ( readtable and writetable) . Since I'm using Ubuntu and couldn't find any other solution for now, to my problem. Other solutions are currently either not avaible in R2018a or does not overwrites to existing .xls file.

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

请先登录，再进行评论。

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

Answer 1

VBBV 2021-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/813055-how-to-for-loop-readtable-and-writetable-range#answer_684590

编辑：VBBV 2021-4-25

在 MATLAB Online 中打开

%f true
    %if true
for i = 1:10 
R1 = sprintf('%s%d:%s%d',char(069),i,char(070),i);
R2 = sprintf('%s%d:%s%d',char(066),i,char(067),i);
data=readtable('test4.xls','ReadVariableNames',0,'Range',R1);
writetable(A, 'test4.xls','WriteVariableNames',0, 'Range', R2);
end

Try this

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

Anilcan Taner 2021-4-26

I got the idea I' ve to change some few, but at the end issue is solved. However, I want to ask is there any other way to write column names other than char(xxx)? If not how may I translate A, B, C .. etc?

请先登录，再进行评论。