I got an error when I export the data in scan mode to excel file in Simbiology
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Florian Augustin
am 23 Mai 2022
Hi Walter,
% 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
Antworten (0)
Communitys
Weitere Antworten in SimBiology Community
Siehe auch
Kategorien
Mehr zu Scan Parameter Ranges finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!