How should i prepare an excel to be imported to fuzzy logic toolbox? Also, what program to write for import data from excel and export the output into an excel?

Kindly help me with a program to impirt data into fuzzy logic toolbox.

Also, I am trying to generate output using evalfis into excel. The following program is not working.

fis = readfis('Optimistic_r');
output = evalfis (fis,[36 3.6; 51.8 8])
xlswrite(filename,sets);

Answer 1

[Asvin Kumar]

You can read from an Excel sheet using readmatrix. See example here.

You can pass the MxN matrix as an input to the evafis function. See example here.

You can then write the ouput of the FIS to an Excel sheet using the writematrix function. See example here.

readmatrix and writematrix were introduced in R2019a. If you're using an earlier version of MATLAB, your approach is correct. xlsread and xlswrite are the way to go. Here are some examples which show you how to use them.

1. Reading a numeric matrix using xlsread
2. Writing a numeric matrix / vector to Spreadsheet using xlswrite

[Sanchit Saran Agarwal]

Thank you, I will check your links.