Export command prompt variables to excel sheet

1 visualizzazione (ultimi 30 giorni)
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 Commenti
dpb
dpb il 23 Giu 2022
Modificato: dpb il 23 Giu 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 il 24 Giu 2022
The second approach looks more potentiable. I'll try that out, thanks.

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by