CODEWITHSUNDEEP
c#export-to-excel
Ros
Ros

Reputation: 634

C# export to excel replace <br/> with a line break in a cell

I'm exporting data to excel. Is it possible to replace <br/> in a string with a line break (alt+enter) so that when exported to excel the string is displayed on separate lines in the same cell.

For example:

string text = "Number One" + "`<br/>`" + "Number Two"

Excel:

Number One
Number Two

Upvotes: 5

Views: 19287

Answers (2)

isxaker
isxaker

Reputation: 9466

Only what you need it's add style="mso-data-placement:same-cell;" inside <br /> tag. Data will be displayed on separate lines but in the same cell.

<br style="mso-data-placement:same-cell;" />

Upvotes: 4

Bala R
Bala R

Reputation: 108957

string textWithNewLine = text.Replace("<br/>", Environment.NewLine);

Upvotes: 3

Related Questions