Reading Excel data rea-ltime with changing data

3 次查看（过去 30 天）
Leon
Leon 2019-10-25
回答： Vinai Datta Thatiparthi 2019-10-29
Hello,
I have an Excel sheet that receives continuous varying data via a DDE link with another program. (this is working perfectly)
I want to read the Excel data continuously and realtime in Matlab for example with xlsread.
However it only gives the correct value right after the Excel file has been saved. So yu first need to save the Excel file and then read the file to get the correct updated data.
Is there an otherway where I don't need to save the Excel file all the time before reading the Excel file?
Many thanks in advance for you support.

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

回答（1 个）

Vinai Datta Thatiparthi
Hi Leon!
It appears that you must save the incoming real-time data value into the Excel sheet for MATLAB to be able to read that data. This seems to be an essential step to get MATLAB to read the data later.
Alternatively, consider using the command ‘readtable’ instead of ‘xlsread’ (not recommended). Further, here are some examples to use MATLAB to interface with COM technology, since DDE server and client support have been stopped and these functionalities are no longer documented.

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by