Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to make Text Vertical in Excel by using the EPPLUS?

Tags:

c#

excel

how to make Text Vertical in Excel by using the EPPLUS?

I couldn't find the api. For an example, "TEXT" in a cell should looks like

T
E
X
T
like image 557
Henry Gao Avatar asked Mar 30 '16 03:03

Henry Gao


1 Answers

you can achive that with the "TextRotation" property, you basically give an integer value equivalent to the amounth of degrees you want to turn the text, for your example it will be 180 so you can do it like this:

myExcelSheet.Cells[row, column].Style.TextRotation = 180;

Hope this helps, greetings.

like image 107
JCO9 Avatar answered Oct 02 '22 21:10

JCO9