I'm asking this for someone else so I'm not sure why they need the data formatted this way but!!!!
they are using the command:
<% Response.ContentType="application/vnd.ms-excel"%>
to create an Excel file from within ASP using the HTML Table commands (<tr> = new excel Row, <td> moves to new Col etc...) and all works fine. They need to create multi lines of data within one cell, not a wrap, but separate lines of data. They tried my suggestion of using the <br> command to force a new line within the cell. However they said that moves the data into a new row instead of a new line within the same cell.
Does anyone know how to force a new line within the same cell of an excel sheet from within ASP, using the above 'Response.ContentType' method.
thanks for your help ... Glen
they are using the command:
<% Response.ContentType="application/vnd.ms-excel"%>
to create an Excel file from within ASP using the HTML Table commands (<tr> = new excel Row, <td> moves to new Col etc...) and all works fine. They need to create multi lines of data within one cell, not a wrap, but separate lines of data. They tried my suggestion of using the <br> command to force a new line within the cell. However they said that moves the data into a new row instead of a new line within the same cell.
Does anyone know how to force a new line within the same cell of an excel sheet from within ASP, using the above 'Response.ContentType' method.
thanks for your help ... Glen
