How to update the text field from the loaded excel file in MATLAB?

1 次查看（过去 30 天）

显示更早的评论

KenL 2016-10-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305464-how-to-update-the-text-field-from-the-loaded-excel-file-in-matlab

评论： KenL 2016-10-3

采纳的回答： Walter Roberson

I encountered a problem to update the text field from the loaded excel file in MATLAB.

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

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2016-10-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305464-how-to-update-the-text-field-from-the-loaded-excel-file-in-matlab#answer_237023

在 MATLAB Online 中打开

[num, txt, raw] = xlsread('TheFilename.xlsx');
raw{7,11} = 'Some New String';   %update the location in memory
xlswrite('TheFilename.xlsx', raw)  %store everything back

OR,

newcontent = 'Some New String';
xlswrite('TheFilename.xlsx', newcontent, 'K7:K7');   %update only the one location

2 个评论
显示无隐藏无

KenL 2016-10-3

Thanks for the prompt response. I managed to update the field at location of raw{7,11} but all my data before such location are replaced with "NaN". Please advise.

KenL 2016-10-3