replace updated data with previous data in Matlab while Matlab and excel are linked.

Question

Amir amini 2020-4-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/519036-replace-updated-data-with-previous-data-in-matlab-while-matlab-and-excel-are-linked

评论： Stijn Haenen 2020-4-20

Hi guys.

in my thesis, an engineering software runs and its result sends to an excel file (not saving). in the next step, I must send this data to Matlab and finally, Matlab creates some values for putting in engineering software. for any iteration, engineering software replaces updated data with previous data in excel. this cycle will do until Matlab optimize the objective function.

so I must create a linking between Matlab with excel while data in excel always updates and I need replace updated data with previous data in Matlab.

How can I do this?

I used "xlsread" and "actxservere" commands but in xlsread I just could get first data (before updating) and in actxserver, , I couldn't replace updated data with previous data because actxserve just can read files.

thank's

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stijn Haenen 2020-4-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/519036-replace-updated-data-with-previous-data-in-matlab-while-matlab-and-excel-are-linked#answer_426891

Make a while loop in which matlab reads the data from the excel file every minute or every hour. You can generate a script that read the excel file with the "inport data" tool.