New Line Problem in HTML Table

Help Studio
,
1

Hello. I have a data table which has multiple lines in some cells. I used program below to turn this data table to HTML table, but this program changes every text in cells into one line, new lines disappears, all values become one line. How can I solve this problem?

The code part which gets the cell text is below:

String.Format(“{0}”, row(data.ColumnName).ToString)

2

Give a try to replace the Linebreaks from Origin cell Text with <br>
IT should be doable with the replace method

3

Thank for your reply. Now, I think my first message doesn’t have enough info about problem. I have also solve the problem even if I am not sure it is a good way of solving it. My table code is like here:

<table border=1>
  <tr>
    <th>Name</th>
    <th>Days1</th>
    <th>Date1</th>
    <th>Time1</th>
    <th>Days2</th>
    <th>Date2</th>
    <th>Time2</th>
  </tr>
  <tr>
    <td>Anna Dewitt</td>
    <td>2</td>
    <td>
      02.09.1992 12.09.1993
    </td>
    <td>
      13:10 11:00
    </td>
    <td>1</td>
    <td>
      04.01.1996</td>
    <td>
      06:45</td>
    <tr>
</table>

I changed the <td>Anna Dewitt</td> part with <pre><td>Anna Dewitt</td></pre> and it is solved.

I think I can’t use <br> in lines cause lines actually comes from excel macro. I use vbCrLf in macro for new line.

4

@AnnaDewitt
lets assume following excel input:
grafik

we do have a linebreak in the cell

After readin with read range we get it as following:
grafik

The windows Linebreaks with Environment.NewLine are the composition of \r\n
grafik
so a replace using \r\n = Environment.NewLine will fail.
grafik

But following code does the replace:
grafik