Export command prompt variables to excel sheet

1 Ansicht (letzte 30 Tage)
Avantika Iyengar
Avantika Iyengar am 23 Jun. 2022
Kommentiert: Avantika Iyengar am 24 Jun. 2022
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
dpb am 23 Jun. 2022
Bearbeitet: dpb am 23 Jun. 2022
See writecell, writematrix, etc., ...
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.
Avantika Iyengar
Avantika Iyengar am 24 Jun. 2022
The second approach looks more potentiable. I'll try that out, thanks.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

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!

Translated by