how to import the output of a function displayed
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Réponse acceptée
John BG
le 5 Oct 2017
Modifié(e) : John BG
le 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
0 commentaires
Plus de réponses (2)
Marco
le 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.
You can see the documentation at this link: https://it.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html BR Marco
0 commentaires
Walter Roberson
le 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 commentaires
Walter Roberson
le 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);
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!