Anyway to run excell commands from matlab? Like draw a boarder range?

Question

Steven 2019-9-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/482541-anyway-to-run-excell-commands-from-matlab-like-draw-a-boarder-range

编辑： Lucie S. 2020-4-23

I know how excel com commands can be called from matlab with activex com.

How could I draw a border with com?

Sub SetRangeBorder() 
 
 With Worksheets("Sheet1").Range("B2").Borders(xlEdgeBottom) 
 .LineStyle = xlContinuous 
 .Weight = xlThin 
 .ColorIndex = 3 
 End With 
 
End Sub

Source: Microsoft Excel Borders

Excel = actxserver('excel.application');
WB = Excel.Workbooks.Open(xlsfile,0,false);
DataSheetObj.Range('B2:B4').Borders.Item('xlEdgeLeft').LineStyle = 1;
DataSheetObj.Range('B2:B4').Borders.Item('xlEdgeLeft').Weight = -4138;
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

I have tried the above code, it throws an error:

Expected one output from a curly brace or dot indexing expression, but there were 5 results.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Steven Lord 2019-9-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/482541-anyway-to-run-excell-commands-from-matlab-like-draw-a-boarder-range#answer_393856

How did you create DataSheetObj and what is its size? Does it have one element or five?

5 个评论
显示 3更早的评论隐藏 3更早的评论

Steven Lord 2019-9-30

在 MATLAB Online 中打开

Generally I use a comment if I'm asking a question that's unlikely to lead directly to an answer. In this case, I was kind of expecting DataSheetObj to be an array that has five elements, which would directly cause this problem and lead you to investigate why.

Your link is a link directly back to this Answers post. Where specifically did you get this code from originally? Did you create it yourself? If so, it can't work as written -- DataSheetObj is undefined. Did you copy it from some documentation example or webpage? If so, where? The line of code that creates DataSheetObj may be present in the original code but been omitted accidentally when copied.

Doing a quick Google search, if the original code you were using as a model was this one, note that it does create DataSheetObj.

AppObj = actxserver('Excel.Application');
AppObj.Visible = true;
WkbkObj = AppObj.Workbooks;
DataWkbkObj = WkbkObj.Add;
DataWkbkObj.Sheets.Add().Name = 'Test';
DataSheetObj = DataWkbkObj.Sheets.Item('Test');

So please show the section of your code corresponding to the last four lines of that snippet, and show us the size of the DataSheetObj created by your code.

Steven Lord 2019-9-30

Try using the code from the answer to which I linked in the sentence starting with "Doing a quick Google search" as a starting point. You will need DataWkbkObj to be defined if you want to use it to control the borders of a region.

Lucie S. 2020-4-23

编辑：Lucie S. 2020-4-23

Indeed, this works all together

AppObj = actxserver('Excel.Application');

AppObj.Visible = true;

WkbkObj = AppObj.Workbooks;

DataWkbkObj = WkbkObj.Add;

DataWkbkObj.Sheets.Add().Name = 'Test';

DataSheetObj = DataWkbkObj.Sheets.Item('Test');

DataSheetObj.Range('B2:B4').Borders.Item('xlEdgeLeft').LineStyle = 1;

DataSheetObj.Range('B2:B4').Borders.Item('xlEdgeLeft').Weight = -4138;

% Other examples of modifying borders, I struggle to find:

DataSheetObj.Range('B2:B4').Borders.Item('xlEdgeBottom').Weight = -4138; % quite thick border weight

DataSheetObj.Range('B2:B8').Borders.Item('xlEdgeTop').Weight =2; % default border weight

% To do borders on many cells:

DataSheetObj.Range('B2:E8').Borders.Item('xlInsideVertical').LineStyle = 1; % All inside vertical borders

DataSheetObj.Range('B2:E8').Borders.Item('xlInsideHorizontal').LineStyle = 1; % All inside Horizontal borders

DataSheetObj.Range('B2:E8').Borders.Item('xlInsideVertical').Color =hex2dec('00FF00'); % change color using hexa coded RGB color

DataSheetObj.Range('B2:E8').Borders.Item('xlInsideVertical').ColorIndex =15; % change color using Excel Color Index (here grey) (google to find more colors)

请先登录，再进行评论。

Anyway to run excell commands from matlab? Like draw a boarder range?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

5 个评论
显示 3更早的评论隐藏 3更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

Anyway to run excell commands from matlab? Like draw a boarder range?

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

5 个评论 显示 3更早的评论隐藏 3更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论