Export command prompt variables to excel sheet

조회 수: 3 (최근 30일)
Avantika Iyengar
Avantika Iyengar 2022년 6월 23일
댓글: Avantika Iyengar 2022년 6월 24일
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
dpb
dpb 2022년 6월 23일
편집: dpb 2022년 6월 23일
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 2022년 6월 24일
The second approach looks more potentiable. I'll try that out, thanks.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by