MATLAB Answers

Access to Excel-Worksheet-Cells Property

63 views (last 30 days)
Andreas
Andreas on 5 Jul 2013
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

  0 Comments

Sign in to comment.

Accepted Answer

Friedrich
Friedrich on 5 Jul 2013
Hi,
use this:
get(get(oWorksheet,'Cells',2,2),'Address')

More Answers (1)

Tom
Tom on 5 Jul 2013
oWorksheet.Range('B2')

  1 Comment

Andreas
Andreas on 8 Jul 2013
Thank you. I want to make a loop through my sheet. That's why I want to use the numeric mode.

Sign in to comment.


Translated by