I got an error when I export the data in scan mode to excel file in Simbiology

3 次查看(过去 30 天)
Hello.
I got an error when I use the scan mode to run Simbiology in order to export the data to excel file as follows: "Datasheet export failed with error: The data block starting at cell "A6" exceeds the sheet boundaries by 23020187 row(s) and 0 Column (s). This problem occured when I use the new version of MATLAB 2022a. I drag the results (scalar) to the new data sheet and it showed up in the new data sheet. However, I cannot export it to excel file. Could anyone give me any suggestions how to solve this issue?
Thank you for your assistance.
Kind reagards,
Teerachat Saeheng
  4 个评论
Florian Augustin
Florian Augustin 2022-5-23
Hi Walter,
Good point. Scalar observables on SimData vectors can be exported as follows:
% Assuming the results variable was exported from the
% SimBiology Model Analyzer as decribed in my previous comment.
scalarObs = vertcat(results.ScalarObservables);
writetable(scalarObs, "obs.csv");
This table will probably be shorter than exporting all time-dependent data in the SimData vectors. If the length of the SimData is less than the max. number of allowed rows in Excel spreadsheets, then the file extension .xlsx can be used.
-Florian

请先登录,再进行评论。

回答(0 个)

社区

更多回答在  SimBiology Community

类别

Help CenterFile Exchange 中查找有关 Import Data 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by