excel offset using in matlab question with code in

my 'month' is in cell A1, my target cell is A2, my code is listed below.

objExcel = actxserver('excel.application');

set(objExcel, 'Visible',1);

sheetName = 'DPLLC';

objSheet = objExcel.Worksheets.get('Item', sheetName);

first_m = objSheet.Range('A:Z').Find('month').offset(2,1).Address;

but give me error like ??? '??? Index exceeds matrix dimensions.'

[Nan Shen]

can any one answer this question?? Thanks!!!

[Oleg Komarov]

Can you format the code please?

[Nan Shen]

code formated !! thank you!

[Oleg Komarov]

With the code button: http://www.mathworks.com/matlabcentral/answers/7885-tutorial-how-to-format-your-question. Thanks, it's already more readable.

[Oleg Komarov]

Can't make it work...I suggest to retrieve the address and apply the offset with matlab, you can search one of the submissions on the FEX to do that.

Answer 1

[Fangjun Jiang]

According to the Excel VB reference, 'Offset' is a property, not a method. But in Excel VB, it seems working like a method, such as ActiveCell.Offset(3,3).Activate. But in MATLAB, 'Offset' is a property of the Range object and it returns the same Range object.

I guess you could get the address first, do the offset and then apply range.

[Nan Shen]

but when I run: first_m = objSheet.Range('A:Z').Find('month').offset(1,1).Address;, it works..., I will try your suggestion.

[Fangjun Jiang]

Yes, but this 'Offset' is always one element, same is for 'Cells'. Try this:

get(objSheet.Range('A:Z').Find('month'),'Value')

get(objSheet.Range('A:Z').Find('month').Offset(1,1),'Value')

get(objSheet.Range('A:Z').Find('month').Cells(1,1),'Value')

They are all the same.