Replace cell text in Excel

Question

Bjarte 2018-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/390422-replace-cell-text-in-excel

回答： Bjarte 2018-3-24

How can I replace a cell's text in Excel with another text?

%%DATA INPUT FROM PRESPECIFIED EXCEL FILE
[~, text, ~] = xlsread('input.xlsx');
Country = text(1,1)
% Replace text in cell A1 in input.xlsx with another text here
%%EXPORTS OUTPUT DATA TO PRESPECIFIED FILE
filename = 'output.xlsx';
A = [Country];
sheet = 1;
xlRange = 'A2'; 
xlswrite(filename,A,sheet,xlRange)

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2018-3-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/390422-replace-cell-text-in-excel#answer_311702

在 MATLAB Online 中打开

Why not

xlswrite(filename,Country,sheet,xlRange)

Country should be a cell with a string inside of it, so this should work.

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

请先登录，再进行评论。

Answer 2

Bjarte 2018-3-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/390422-replace-cell-text-in-excel#answer_311711

I am not sure if that works in my case. I am trying to run a function with input parameters from input.xlsx, and export resulting outputs to output.xlsx. Once finished, it should change one of the input parameters in input.xlsx, and export the new output.