how to import the output of a function displayed

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.

[KSSV]

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.

Answer 1

[John BG]

Hi segun

this is John BG <mailto:[e-mail] [e-mail]>

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

<mailto:[e-mail] [e-mail]>

Answer 2

[Marco]

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.

You can see the documentation at this link: https://it.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html BR Marco

Answer 3

[Walter Roberson]

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.

[segun]

There are 250 numbers with decimals displayed as the output after the Run of the Mfile. How to copy this numbers and transfer them to MSExcel is the problem.

[Walter Roberson]

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);