Writing and Executing Formula in Excel by MATLAB

27 次查看（过去 30 天）
Rounak Saha Niloy
Rounak Saha Niloy 2022-3-22
评论： Arif Hoq 2022-3-23
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?

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

回答（1 个）

Arif Hoq
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

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by