Reading Excel Real time with changing data to MATLAB
2 views (last 30 days)
Show older comments
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.
0 Comments
Answers (0)
See Also
Categories
Find more on Use COM Objects in MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!