Converting Dataset Simulation results to Excel Spreadsheet

버전 1.0.0.0 (110 KB) 작성자: Roni Peer
Two simple functions that convert a Dataset parameter, containing Simulink Simulation data, to excel
다운로드 수: 1.2K
업데이트 날짜: 2013/6/11

라이선스 보기

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 릴리스 호환 정보
개발 환경: R2012b
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
버전 게시됨 릴리스 정보
1.0.0.0