Export command prompt variables to excel sheet
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a MATLAB code which calculates certain threshold values and other parameters of a signal. The signal is in the form of raw voltage values stored in a txt file. MATLAB imports the file using dlmread(). I want to test this code on many datasets and hence, want to collect the output from the workspace in an excel sheet. I want to append a preexisting excel template, everytime I run the code with a new .txt input data file. I have attached my template below. I am thinking of writing a python script and run it over MATLAB using pyrun, but is there any other effective function in MATLAB to do this job?
The values in this spreadsheet are entered manually by copy pasting the output from MATLAB workspace. Any solution to automate it?

2 Kommentare
dpb
am 23 Jun. 2022
Bearbeitet: dpb
am 23 Jun. 2022
Your best bet will be to build an array to write the column in one call; the MATLAB functions open/close Excel for each call so trying to write single cells in a tight loop is abadidea™.
Alternatively, and the approach I take on something somewhat similar is to read the template into a MATLAB table, modify the pieces of the table as needed, then simply rewrite the whole thing with writetable. The other functions above actually convert the input data to a table and call writetable with appropriate parameters, anyways.
Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB 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!