Text Orientation?

[Ryan]

Is there a way to change the orientation of text within a cell? In other words, can I insert text into a cell that's slanted?

If you go into an excel spreadsheet, right-click on a cell, select "Format Cells", and then the "Alignment" tab, you'll notice there's an Orientation field that allows you to slant your text.

Can this be done in XlsIo?

Thanks.

-ryan

[Melba Winshia]

Hi Ryan,

You can set the orientation (rotation) of the text inside the cell by using the Rotation property of the CellStyle object. Please refer the following code snippet that illustrates the above:

[C#]
//Text Orientation Setting
sheet.Range["A1"].CellStyle.Rotation = 60;
sheet.Range["A2"].CellStyle.Rotation = 90;

Please refer the following sample which implements the above said feature:

Orientation.zip

Please take a look and let me know if you have any other questions.

Best Regards,
Melba