MATLAB: Reading real time data from Excel 365 to MATLAB 2018a

automationcom server

Hi,

I am having problem while reading real time data from Excel 365 to MATLAB. somebody please help. How to do read real time data from excel to MATLAB ?

Thanks in Advance.

Best Answer

I was using COM server for Automation, but wasn't getting real time data on MATLAB from excel. I did use actxserver to connect to excel.

exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open(['C:\Users\Amarkant\Desktop\ExcelToMatlab_COM\Indices_rtd.xlsx']);
exlSheet1 = exlFile.Sheets.Item('Sheet1');
robj = exlSheet1.Columns.End(4);       % Find the end of the column
numrows = robj.row;                    % And determine what row it is
dat_range = ['A1:B' num2str(numrows)]; % Read to the last row
rngObj = exlSheet1.Range(dat_range);
exlData = rngObj.Value;

data is changing on excel but I am not getting updated data on variable "exlData". This is the problem I am facing, I wanted to manipulate rtd from excel into MATLAB.

I am very new to COM Automation server.

please help. Thanks in Advance.

Related Solutions

MATLAB: Reading multiple excel files from a folder that has other types of files in addition to excel and putting the values in a cell array

sdirectory = 'D:\EXAMPLE_directory';
tifffiles = dir([sdirectory '/*.xlsx']);
sd = length(tifffiles);
for k = 1:numel(sd)
     File1 = [sdirectory '/' tifffiles(k).name];
     A = xlsread(File1)
end

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

Best Answer

Related Solutions

MATLAB: Reading multiple excel files from a folder that has other types of files in addition to excel and putting the values in a cell array

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

Related Question