Working in Excel with live on MATLAB

5 次查看（过去 30 天）
종영
종영 2024-8-29
回答： Image Analyst 2024-8-30
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 个评论
halleyhit
halleyhit 2024-8-29
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.

请先登录，再进行评论。

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

采纳的回答

Angelo Yeo
Angelo Yeo 2024-8-29
编辑：Angelo Yeo 2024-8-29
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)

更多回答（1 个）

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

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by