MATLAB: Data from MATLAB to excel then back

dataexcelMATLABreadtabletransferxlsread

I have a program where I output data to excel from MATLAB, then MATLAB performs calculations on that data and sends it back to excel, and then excel performs calculations(the final data). I want to get the final data from excel into MATLAB, but if I try to use readtable, the calculations are not performed even though I put readtable after MATLAB sends the data to excel. The final data only shows when I open excel. How could I go about doing this?

Best Answer

Your calculations inside Excel are Excel macros, and macros are not triggered at the time data is written.

https://www.mathworks.com/matlabcentral/answers/100938-how-can-i-run-an-excel-macro-from-matlab

Related Solutions

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;

MATLAB: Syntax to plot graph using excel sheet data

Use xlsread() or readtable() to read the data. After that, use plot() on the data. There is no special syntax just because the data came from excel.

Best Answer

Related Solutions

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

MATLAB: Syntax to plot graph using excel sheet data

Related Question