Working in Excel with live on MATLAB
2 views (last 30 days)
Show older comments
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
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.
Answers (2)
Angelo Yeo
on 29 Aug 2024
Edited: Angelo Yeo
on 29 Aug 2024
See the video below for a quick introduction to the toolbox.
0 Comments
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.
0 Comments
See Also
Categories
Find more on Data Export to MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!