How to update the text field from the loaded excel file in MATLAB?
2 views (last 30 days)
Show older comments
I encountered a problem to update the text field from the loaded excel file in MATLAB.
0 Comments
Accepted Answer
Walter Roberson
on 3 Oct 2016
[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
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!