Reading Excel Real time with changing data to MATLAB

2 views (last 30 days)
Hi All,
I am trying to use COM Automation server to transfer real-time data from Excel to MATLAB, but i am failing on registerevent function. someone please help me.
thanks in advance .
Excel = actxserver('Excel.Application');
%%
fullPathToExcelFile = 'C:\Users\User1\Desktop\ExcelToMatlab_COM\rtd1.xlsx'; % Please modify this to the location of your excel file
ExcelWorkbook = Excel.workbooks.Open(fullPathToExcelFile,0,true);
WorkSheets = Excel.sheets;
Excel.Visible = true; %make excel visible so user can interact
%%
TargetSheet = get(WorkSheets,'item','Sheet1');
Activate(TargetSheet);
%%
DataRange = TargetSheet.UsedRange;
r = DataRange.Address;
data = DataRange.Value;
registerevent(TargetSheet, {'Change',@(TargetSheet) @ExlData});
function t = ExlData(TargetSheet)
% data = range.Value
temp = TargetSheet.UsedRange;
t = temp.Value
disp(t)
end
Error is coming like:
Error using comeventcallback (line 24)
Error firing event 'Change' to '@(TargetSheet)@ExlData'.
Someone please help.

Answers (0)

Community Treasure Hunt

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

Start Hunting!