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

2 次查看（过去 30 天）
Wenquan
Wenquan 2022-12-29
编辑： 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 ?

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

采纳的回答

Cameron
Cameron 2022-12-30
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;

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by