excel offset using in matlab question with code in
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Oleg Komarov
le 2 Août 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
le 2 Août 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.
Réponses (1)
Fangjun Jiang
le 2 Août 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 commentaires
Fangjun Jiang
le 2 Août 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.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!