ExcelTextRotation

[Ethan Young]

I see an enumeration in the help for ExcelTextRotation, and I need to use it, but I can''t find any place to set it. I need to make the text in a cell rotated so that it reads sideways from bottom to top (counter clockwise rotation). How do I do that?

[Administrator]

Hi Ethan,

You can rotate the text by specifying the rotation angle

mySheet.Range["A1"].CellStyle.Rotation = 90;

However, there seems to be no method that would accept the TextRotation Enum. I will ask the development team to provide a property to accept an TextRotation Enum.

Thanks,

Stephen.

>I see an enumeration in the help for ExcelTextRotation, and I need to use it, but I can''t find any place to set it. I need to make the text in a cell rotated so that it reads sideways from bottom to top (counter clockwise rotation). How do I do that?