Access to Excel-Worksheet-Cells Property
13 ビュー (過去 30 日間)
古いコメントを表示
I want to access some excel data with a loop over some rows and columns. With vba, I am used to do this with the cell-property (!). That's my attemp in matlab:
excelObject = actxserver('Excel.Application');
excelObject.Visible = 1;
oWorkbook = excelObject.Workbooks.Open('C:\abc.xls');
oWorksheet = oWorkbook.Sheets.Item(1);
oWorksheet.Activate;
% Here I want to get the address of cell B2:
disp oWorksheet.Cells(2,2).Address;
% The error Index exceeds matrix dimensions occures
It looks like matlab wants to use the Cell-Property as an array - not as a property with two arguments.
How can I access the Cells-Property? I tried the "get"-Function, but this doesn't help me.
Regards
Andreas
0 件のコメント
採用された回答
その他の回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!