MATLAB: Access to Excel-Worksheet-Cells Property

excel property cellsMATLAB

I want to access some excel data with a loop over some rows and columns. With vba, I am used to do this with the cell-property (!). That's my attemp in matlab:

excelObject = actxserver('Excel.Application'); 
excelObject.Visible = 1;
oWorkbook = excelObject.Workbooks.Open('C:\abc.xls');
oWorksheet = oWorkbook.Sheets.Item(1);
oWorksheet.Activate;
% Here I want to get the address of cell B2:
disp oWorksheet.Cells(2,2).Address;
% The error Index exceeds matrix dimensions occures

It looks like matlab wants to use the Cell-Property as an array – not as a property with two arguments.

How can I access the Cells-Property? I tried the "get"-Function, but this doesn't help me.

Regards

Andreas

Best Answer

Hi,

use this:

get(get(oWorksheet,'Cells',2,2),'Address')

Related Solutions

MATLAB: Error: Unable to resolve the name workbooks.Open.

After excel = actxserver(), you have not defined "workbooks". Need this?

workbooks= excel.Workbooks;

MATLAB: How to get Hyperlinks’ addresses from an Excel file

Matlab does not have a function to retrieve the target of hyperlinks and the way excel stores hyperlink is a bit convoluted as the hyperlinks are not properties of the cell themselves, they're stored in a separate collection. The following function will retrieve all the hyperlinks in a spreadsheet:

function [links, locations] = xlsgethyperlinks(file, sheet)
   %retrieve all hyperlinks and their location in an excel worksheet
   %syntax:
   %    [links, locations] = xlsgethyperlinks(file);
   %    [links, locations] = xlsgethyperlinks(file, sheet);
   %with:
   %    file: full path of the excel workbook (scalar string / char vector)
   %    sheet: name or index of worksheet (scalar string / char vector / scalar positive integer). Default is 1
   %    links: column cell vector of hyperlink targets in the order returned by excel
   %    locations: column cell vector of char vectors containing the location of the hyperlinks in the sheet, in RC format
   %    Author: G. de Sercey
   %    BSD license
   if nargin < 2
       sheet = 1;
   end
   %todo: add input validation
   %The code starts excel, load the workbook, then iterates over all the hyperlinks in the worksheet storing the hyperlink address and the range address of the hyperlinks.
   %excel is closed automatically by the onCleanup when the function terminates (normally or due to errors).
   excel = actxserver('Excel.Application');
   cleanup = onCleanup(@() excel.Quit);
   workbook = excel.Workbooks.Open(file);
   worksheet = workbook.Worksheets.Item(sheet);
   hyperlinks = worksheet.Hyperlinks;
   links = cell(hyperlinks.Count, 1);
   locations = cell(hyperlinks.Count, 1);
   for hidx = 1:hyperlinks.Count
      hyperlink = hyperlinks.Item(hidx);
      links{hidx} = hyperlink.Address;
      locations{hidx} = hyperlink.Range.Address;
   end
end

Note that I've just written this on the fly just now. There may be bugs.

Best Answer

Related Solutions

MATLAB: Error: Unable to resolve the name workbooks.Open.

MATLAB: How to get Hyperlinks’ addresses from an Excel file

Related Question