Clear Filters
Clear Filters

Working in Excel with live on MATLAB

2 views (last 30 days)
종영
종영 on 29 Aug 2024
Answered: Image Analyst on 30 Aug 2024
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?
  1 Comment
halleyhit
halleyhit on 29 Aug 2024
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.

Sign in to comment.

Answers (2)

Angelo Yeo
Angelo Yeo on 29 Aug 2024
Edited: Angelo Yeo on 29 Aug 2024
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.

Image Analyst
Image Analyst on 30 Aug 2024
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.

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!