How can I set text orientation in Excel using matlab actxserver?

Question

Wenquan 2022-12-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1886112-how-can-i-set-text-orientation-in-excel-using-matlab-actxserver

编辑： Walter Roberson 2022-12-30

Hello, I'm using matlab actxserver to write a excel table. I want to change the orientation of text. I have checked some VBA codes and tried a few codes. Actually I don't know how to transform a VBA code in Matlab code. I have tried:

eSheet.Range.Orientation=90;
eSheet.Range.XlOrientation=-4171;

( https://learn.microsoft.com/en-us/office/vba/api/excel.xlorientation )

( https://learn.microsoft.com/en-us/office/vba/api/excel.range.orientation )

They don't work.

Can anyone help with the right syntax. Is there a good guide anywhere for the matlab activex syntax versions of VBA commands ?

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

请先登录，再进行评论。

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

Answer 1

Cameron 2022-12-30

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1886112-how-can-i-set-text-orientation-in-excel-using-matlab-actxserver#answer_1138767

在 MATLAB Online 中打开

Excel = actxserver('Excel.Application');
set(Excel, 'Visible', 1);
Workbooks = Excel.Workbooks;
Workbook = invoke(Workbooks, 'Add');
Excel.ActiveWorkbook.ActiveSheet.Range("C3").Value = "Example Text";
Excel.ActiveWorkbook.ActiveSheet.Range("C3").Orientation = 90;