excel offset using in matlab question with code in

3 次查看（过去 30 天）
Nan Shen
Nan Shen 2011-8-2
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 个评论
显示 3更早的评论
Oleg Komarov
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
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
Fangjun Jiang 2011-8-2
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
Nan Shen 2011-8-2
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
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by