Code covered by the BSD License  

Highlights from
Converting Dataset Simulation results to Excel Spreadsheet

Be the first to rate this file! 23 Downloads (last 30 days) File Size: 110 KB File ID: #42183
image thumbnail

Converting Dataset Simulation results to Excel Spreadsheet

by

 

Two simple functions that convert a Dataset parameter, containing Simulink Simulation data, to excel

| Watch this File

File Information
Description

Many times when running simulations, you want to take the results, and use them in an excel spreadsheet, or convert them to a text format.
The supplied functions enable you to save the simulation results to excel, or import other scenarios into MATLAB, in a Dataset format valid for running simulations with Simulink.
Including sample excel spreadsheet, a Simulink model to create a Dataset, and a Simulink model to run the imported scenario. The functions are documented and pretty much self-explanatory.

Option 1 - Simulink to Excel:
Open and run the model 'example_Simulink'. This will create a parameter named 'logsout' in the workspace.
Run the following command - Dataset2XLS(logsout, 'example_data.xlsx') , and an excel spreadsheet named 'example_data' will be created in the current directory.

Option 2 - Excel to Simulink:
Run the function new = XLS2Dataset('example_Dataset.xlsx')
Open the model example_ReadDS. View the Data Import/Export pane in the Configuration parameters,
and see how the data is used.

*** Notes:
Tested on Microsoft Excel Version 2010.

Required Products Simulink
MATLAB
MATLAB release MATLAB 8.0 (R2012b)
Other requirements Tested on Excel 2010.
Tags for This File   Please login to tag files.
Please login to add a comment or rating.

Contact us