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

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

Answer 1

[Walter Roberson]

[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

[KenL]

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]

Hi...I did a mistake. Now, problem solved. Thanks.