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

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 ?

Answer 1

[Cameron]

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;

[Wenquan]

Thank you very, very much! It works now.