ExcelTextRotation

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?

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?