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.'
5 个评论
Nan Shen
2011-8-2
Oleg Komarov
2011-8-2
Can you format the code please?
Nan Shen
2011-8-2
Oleg Komarov
2011-8-2
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
2011-8-2
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.
回答（1 个）
Fangjun Jiang
2011-8-2
0 个投票
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.
2 个评论
Nan Shen
2011-8-2
Fangjun Jiang
2011-8-2
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.
类别
在 帮助中心 和 File Exchange 中查找有关 Creating, Deleting, and Querying Graphics Objects 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
