MATLAB: Get data from Excel sheet from running .m scripts

spreadsheetSpreadsheet Link

I am using Spreadsheet Link Ex. I know how to push data from Excel to Matlab but not the other way round. When I run a .m script, I want the matlab codes to update the data from Excel before calculation. Any example available.

Best Answer

I have not used Spreadsheet Link for a while. I prefer COM server or using xlsread() and xlswrite(). But here is a link.

http://www.mathworks.com/help/toolbox/exlink/f2-2311.html#bsc9p77-1

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: Importing data from excel sheet

sheet={'sheet1','sheet2'}, %specify your sheets
out=cellfun(@(x) xlsread('book1.xlsx',x),sheet,'uni',false)

if you want one line command (for 4 sheets)

out=cellfun(@(x) xlsread('book1.xlsx',x),cellfun(@(y) ...
sprintf('sheet%d',y),num2cell(1:4),'uni',false),'uni',false)

Best Answer

Related Solutions

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

MATLAB: Importing data from excel sheet

Related Question