Writing and Executing Formula in Excel by MATLAB
16 views (last 30 days)
Show older comments
I have some values in a xlx file in A1:A10 and B1:B10. If A1==B1, in C1, I want to write "Matched". How do I do this using MATLAB?
0 Comments
Answers (1)
Arif Hoq
on 23 Mar 2022
Edited: Arif Hoq
on 23 Mar 2022
My approach:
import the excel file into matlab >> Processing >> export into excel.
str={'Matched'};
A=readtable('example.xlsx','ReadVariableName',false);
if table2array(A(1,1))==table2array(A(1,2))
A(1,3)=str;
end
B=table2cell(A);
writecell(B,'example.xlsx') % export to same excel file, so that you can get the output in C1
2 Comments
Arif Hoq
on 23 Mar 2022
@Rounak Saha Niloy if you find my answer helpful, please mark this as an "Accepted answer"
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!