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
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
xls_file_name='Book1.xlsx'
2. define what sheet to write on, for instance 2nd page
sheet=2
3. define the start point of the range to write in the Excel file
range1='B2'
4. write it
xlswrite(xls_file_name,A,sheet,range1)
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
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.
  2 Comments
Walter Roberson
Walter Roberson on 5 Oct 2017
Example:
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.

Categories

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!