MATLAB: Data from MATLAB to excel then back

dataexcelMATLABreadtabletransferxlsread

I have a program where I output data to excel from MATLAB, then MATLAB performs calculations on that data and sends it back to excel, and then excel performs calculations(the final data). I want to get the final data from excel into MATLAB, but if I try to use readtable, the calculations are not performed even though I put readtable after MATLAB sends the data to excel. The final data only shows when I open excel. How could I go about doing this?

Best Answer

  • Your calculations inside Excel are Excel macros, and macros are not triggered at the time data is written.