MATLAB Answers

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?

6 views (last 30 days)
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);

Accepted Answer

Asvin Kumar
Asvin Kumar on 23 Jun 2021
Edited: Asvin Kumar on 23 Jun 2021
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

More Answers (0)

Community Treasure Hunt

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

Start Hunting!