Filter löschen
Filter löschen

Writing and Executing Formula in Excel by MATLAB

26 Ansichten (letzte 30 Tage)
Rounak Saha Niloy
Rounak Saha Niloy am 22 Mär. 2022
Kommentiert: Arif Hoq am 23 Mär. 2022
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?

Antworten (1)

Arif Hoq
Arif Hoq am 23 Mär. 2022
Bearbeitet: Arif Hoq am 23 Mär. 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 Kommentare
Arif Hoq
Arif Hoq am 23 Mär. 2022
@Rounak Saha Niloy if you find my answer helpful, please mark this as an "Accepted answer"

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Produkte


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by