MATLAB Answers

Multiple Input/output function to excel

조회 수: 6(최근 30일)
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.

채택된 답변

Ameer Hamza
Ameer Hamza 12 Mar 2020
편집: Ameer Hamza 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');

추가 답변(1개)

Jakob B. Nielsen
Jakob B. Nielsen 12 Mar 2020
편집: Jakob B. Nielsen 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
Doorgesh Ramkurrun
Doorgesh Ramkurrun 12 Mar 2020
Hey Jakob,
Thanks, worked like a charm.

댓글을 달려면 로그인하십시오.




Community Treasure Hunt

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

Start Hunting!

Translated by