MATLAB: I have 600 xlsx files and I want to convert all of them in mat, how to do that

mat

Each xlsx file contains 6 columns and rows are varying.

Best Answer

Related Solutions

MATLAB: How can i convert excel file to mat file

[a,b,c]=xlsread('yourfile.xlsx')
save yourmatfile c

MATLAB: Fminsearch from table or mat, choose row values

I don't think fminsearch is the best way to solve this problem. Here is a different approach:

% T is your data table.
% in1 and in2 are the two input values.
T.dif1 = abs(T.A-in1);
min1 = min(T.dif1);
T1 = T(T.dif1==min1,:);  % T1 has the rows of T that come closest to matching in1.
T1.dif2 = abs(T1.B-in2);
min2 = min(T1.dif2);
T2 = T1(T1.dif2==min2,:);  % T2 has the rows of T1 that come closest to matching in2.
% If T2 only has 1 row, it is the row you wanted.
% If T2 has more than 1 row, I am not sure which one(s) you want.

Best Answer

Related Solutions

MATLAB: How can i convert excel file to mat file

MATLAB: Fminsearch from table or mat, choose row values

Related Question