Data from MATLAB to excel then back

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?

[Brandon Free]

You might have to provide more detail with example code

[Collin Poesch]

Sure. I have to close excel in order for readtable to work.

    % code
  xlswrite('read.xlsx',twothirdspoint(:,:),'calculations','P17:Q26');

The data is now in excel.

I have the data set up so user defined functions are performed on it in excel.

    % code
  newfortwothirds= readtable('read.xlsx','Sheet','calculations','Range','J24:J104');

I then try to retrieve the data that should be calculated but it just returns empty cells.

Answer 1

[Walter Roberson]

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

https://www.mathworks.com/matlabcentral/answers/100938-how-can-i-run-an-excel-macro-from-matlab

[Collin Poesch]

I did something similiar; I just opened the excel workbook then let excel calculate then I extracted the data back to matlab.