Writing and Executing Formula in Excel by MATLAB
20 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
Arif Hoq
2022 年 3 月 23 日
編集済み: Arif Hoq
2022 年 3 月 23 日
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 件のコメント
Arif Hoq
2022 年 3 月 23 日
@Rounak Saha Niloy if you find my answer helpful, please mark this as an "Accepted answer"
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!