MATLAB Answers

How to selectExcel columns through Matlab activeX control?

조회 수: 10(최근 30일)
Matt 22 May 2015
답변: Matt 22 May 2015
In Excel VBA I can create groups by using:
Columns(3).Resize(, 4).Group
This will make columns 3 through 7 into a group. In Matlab I have:
XL = actxserver('excel.application');
XL.DisplayAlerts = 0;
XL.Visible = 0;
XLWB = XL.Workbooks;
WB = Add(XLWB);
WS = WB.Worksheets;
AS = WB.ActiveSheet;
... bunch of stuff added to the sheet
At this point I want to group some columns. I have all the following and all have failed.
What's the proper way to do this?

  댓글 수: 1

Guillaume 22 May 2015
Failed in what way?

댓글을 달려면 로그인하십시오.

채택된 답변

Matt 22 May 2015
So the best way I found to do this was to access the columns through the Range of the ActiveSheet.
command = sprintf('%s:%s', str1, str2);
I build str1 and str2 by converting the column number into an Excel label like "AA" for 27 and "BA" for 53.

  댓글 수: 0

댓글을 달려면 로그인하십시오.

추가 답변(1개)

Guillaume 22 May 2015
편집: Guillaume 22 May 2015
I don't have time to test if that's the issue (particularly since you've not said what the failure is), but with matlab sometimes you can use the dot notation, and sometimes you can't because matlab fails to find the method. In these cases you have to use invoke.
Does this work?
invoke(As.Columns(3), 'Select');
edit: Actually, isn't the issue with your indexing of the range returned by Columns. With Matlab, you can't directly use brackets to index into collections. You have to use the Item property to get individual elements:

  댓글 수: 1

Matt 22 May 2015
AS.Columns.Item(3).Select allows me to select the column. However I can not resize the selection to group it. I have tried this.
The error I got was Invoke Error, Type mismatch
I also tried this
The error here is Subscript indices must either be real positive integers or logicals.
And also:
Error: Expression or statement is incorrect--possibly unbalanced (, {, or [.
Index exceeds matrix dimensions.
Index exceeds matrix dimensions.

댓글을 달려면 로그인하십시오.


Community Treasure Hunt

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

Start Hunting!

Translated by