Working in Excel with live on MATLAB

On matlab, I am going to import an Excel file and work on it live in real time.

If I change the value in Excel, I want to reflect it in real time in MATLAB.

However, as far as I know, if you modify it without saving the Excel, it cannot be applied in MATLAB right away.

Is there a way to solve this?

[halleyhit]

It is difficult, because excel and MATLAB are two separated tasks and thus not easy to exchange data. One workaround might be generating your MATLAB code into Excel Add-ins, so that all data are in Excel only.

Answer 1

[Angelo Yeo]

You can use Spreadsheet Link toolbox to make a real-time interface between MATLAB and Excel.

See the video below for a quick introduction to the toolbox.

How to Install and Use Spreadsheet Link - MATLAB (mathworks.com)

Answer 2

[Image Analyst]

You can interact with Excel "live" if you are using Windows and use ActiveX. I attach a demo for that, ExcelDemo. You can stop the demo at a breakpoint at any point and switch over to Excel and see the changes that you have made will be there. I'm also attaching a class with many useful ActiveX functions, Excel_utils.m.