I am trying to write data on to Excel on a specific but dynamic location (say not E1 or C3 but depending on what I have done in the code, row no. 2i and column 4y). Is it possible to do that?

Question

Abhinav Sharma 2018-12-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/436618-i-am-trying-to-write-data-on-to-excel-on-a-specific-but-dynamic-location-say-not-e1-or-c3-but-depen

评论： Abhinav Sharma 2018-12-20

I am trying to write data on to Excel on a specific but dynamic location (say not E1 or C3 but depending on what I have done in the code, row no. 2*i and column 4*y). Is it possible to do that?

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

请先登录，再进行评论。

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

Answer 1

Caglar 2018-12-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/436618-i-am-trying-to-write-data-on-to-excel-on-a-specific-but-dynamic-location-say-not-e1-or-c3-but-depen#answer_353267

编辑：Caglar 2018-12-20

在 MATLAB Online 中打开

You need to convert your row and column into cell name that xlswrite understands.

cellname=[xlscol(column) num2str(row)];

You need xlscol from fileexchange: https://www.mathworks.com/matlabcentral/fileexchange/28343-column-converter-for-excel?focused=5156839&tab=function

Note that xlswrite starts to write from that cell, but does not limit writing to that cell. If you feed it with an array or matrix, it will write on neigbour cells too.

An unexpected behaviour (at least to me) is that it writes one letter per cell when writing a char array or string. Therefore, use cellstr(yourtext) when writing those.

2 个评论
显示无隐藏无

madhan ravi 2018-12-20

编辑：madhan ravi 2018-12-20

@Caglar you can select the particular code and press the code button so that the reader is able to know where the code is easily, thanks for understanding.

Abhinav Sharma 2018-12-20