Data from MATLAB to excel then back

1 次查看（过去 30 天）
Collin Poesch
Collin Poesch 2018-6-8
评论： Collin Poesch 2018-6-8
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?
  2 个评论
Brandon Free
Brandon Free 2018-6-8
You might have to provide more detail with example code
Collin Poesch
Collin Poesch 2018-6-8
编辑：Collin Poesch 2018-6-8
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.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2018-6-8
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
  1 个评论
Collin Poesch
Collin Poesch 2018-6-8
I did something similiar; I just opened the excel workbook then let excel calculate then I extracted the data back to matlab.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by