excel offset using in matlab question with code in
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Oleg Komarov
il 2 Ago 2011
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
il 2 Ago 2011
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.
Risposte (1)
Fangjun Jiang
il 2 Ago 2011
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 Commenti
Fangjun Jiang
il 2 Ago 2011
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.
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!