Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cell wrap using vb.net & EPPlus

I am trying to wrap a value in a cell using EPPlus and VB.net / ASP.Net
Have anyone been able to do this? I searched SO & google, but no luck.

like image 236
DNR Avatar asked Oct 18 '11 14:10

DNR


People also ask

How do I wrap a cell in VBA?

Wrap Text to a Cell using VBADefine the cell where you want to apply the wrap text using the range property. Type a dot to see the list of the properties and methods for that cell. Select the “WrapText” property from the list. Enter the equals sign “=” and the type TRUE to turn the wrap text ON.

How do you wrap the text in a cell?

Wrap text automaticallyOn the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)

How do you wrap text in a protected sheet?

Go to Home. Select the column that you want to apply the Wrap Text function by highlighting it. On the Alignment group, click Wrap Text. Save the changes.


1 Answers

This will wrap the value of a cell (EPPlus 3.0.0.2) c# code:

workSheet.Cells[1, 1].Style.WrapText = true;
like image 72
gsk Avatar answered Oct 07 '22 00:10

gsk