MATLAB Answers

Multiple Input/output function to excel

9 views (last 30 days)
Hey Guys,
This is an example of my function:
  1. I want to know how to input different values for my input 'in2' (for example values for in2 ranges from 0 to 0.1 with intervals = 0.001) without having to input them repeatedly in the command window,
  2. Secondly, I want to know how to convert my outputs into a table which can then be used in Excel.

Accepted Answer

Ameer Hamza
Ameer Hamza on 12 Mar 2020
Edited: Ameer Hamza on 12 Mar 2020
You can try something like this
in1 = 0;
in2 = (0:0.001:0.1)';
in3 = 0;
in4 = 0;
% if out1 out2 out3 out4 are scalars
out1 = zeros(size(x));
out2 = zeros(size(x));
out3 = zeros(size(x));
out4 = zeros(size(x));
for i=1:numel(in2)
Then to save in MS excel file
writematrix([out1, out2, out3, out4], 'filename.xlsx');

More Answers (1)

Jakob B. Nielsen
Jakob B. Nielsen on 12 Mar 2020
Edited: Jakob B. Nielsen on 12 Mar 2020
You can achieve this in many ways. The simplest way would be to just create arrays of your input ranges, for example
will get you a 1x101 array with values from 0, in increments of 0.001, to 0.1. And then do this for all your inputs. As long as your function Trial_4 can handle elementwise operations (put dots in front of multiplications and powers and such, so instead of in2^2 write in2^.2), then your outputs will also be 1x101 arrays.
In regards to a table, you can either do
and then copy/paste it over from the workspace.
Or simply / more elegantly,
  1 Comment
Doorgesh Ramkurrun
Doorgesh Ramkurrun on 12 Mar 2020
Hey Jakob,
Thanks, worked like a charm.

Sign in to comment.




Community Treasure Hunt

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

Start Hunting!