Reading Excel data rea-ltime with changing data
4 views (last 30 days)
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.
Vinai Datta Thatiparthi on 29 Oct 2019
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.