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.
引用格式
Roni Peer (2024). Converting Dataset Simulation results to Excel Spreadsheet (https://www.mathworks.com/matlabcentral/fileexchange/42183-converting-dataset-simulation-results-to-excel-spreadsheet), MATLAB Central File Exchange. 检索来源 .
MATLAB 版本兼容性
平台兼容性
Windows macOS Linux类别
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- Computational Finance > Spreadsheet Link > Data Import from MATLAB >
标签
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!版本 | 已发布 | 发行说明 | |
---|---|---|---|
1.0.0.0 |