how to import the output of a function displayed

3 views (last 30 days)
How do one import the output of a function simulated in MATLAB 2015 that is about 250 number outputs displayed vertically. I need to put it into MSexcel for further analysis.
  1 Comment
KSSV on 5 Oct 2017
Edited: KSSV on 5 Oct 2017
doc xlswrite to write the data into excel file. By the way why you want to go to excel, when you can analyze everything and anything in MATLAB.

Sign in to comment.

Accepted Answer

John BG
John BG on 5 Oct 2017
Edited: John BG on 5 Oct 2017
Hi segun
Let be your data for instance
A=randi([-1e4 1e4],5,1)
1. choose the Excel file
2. define what sheet to write on, for instance 2nd page
3. define the start point of the range to write in the Excel file
4. write it
if you find this answer useful would you please be so kind to consider marking my answer as Accepted Answer?
To any other reader, if you find this answer useful please consider clicking on the thumbs-up vote link
thanks in advance
John BG

More Answers (2)

Marco on 5 Oct 2017
Hello, to export a table in the workspace to a Microsoft® Excel® spreadsheet file, use the writetable function. You can export data from the workspace to any worksheet in the file, and to any location within that worksheet.

Walter Roberson
Walter Roberson on 5 Oct 2017
Assign the output to a variable if possible.
If the output is just be displayed, such as through disp() or fprintf(), then best is to modify the function to return the information.
If it is just being displayed and modifying the function is not practical, then use evalc() to capture the output as text, after which you can split it into lines and str2double() it.
Walter Roberson
Walter Roberson on 5 Oct 2017
S = evalc('MyBlackBoxFunction()');
Slines = regexp(S, '\n', 'split');
Slines(1:3) = []; %remove a text header
Slines( cellfun(@isempty, Slines) ) = []; %delete empty lines
data = str2double(Slines);
xlswrite('MyOutput.xlsx', data);

Sign in to comment.


Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!