Excel (cell format) via ASP

[gba]

Using ASP to output a table to an Excel spreadsheet file using the following method:

<% Response.ContentType=&quot;application/vnd.ms-excel&quot;%>

This works, the excel file is created and populated etc... Problem I'm having is that I have one cell that contains a long string of text that is wrapping inside the Excel cell,instead of the cell expanding to accommodate the string on one line.

Things I've tried:
- the string contains no CR/LF characters and looks fine from within MS-Access (source)
- Tried expanding the width of the cell in the ASP/HTML code (<td> width=100>) .
- used ' CELLSPACING=1 CELLPADDING=1' in the table line (which actually solved wrap
in other cells)
- increase the width in the MS-Access table to show entire line (reaching here).

anyone have any ideas... thnx

 

[Layton]

Have you tried <td nowrap> for that cell?

 

[jonscott8]

SWAG, but try adding the NOWRAP attribute to the cell:

<TD NOWRAP>My Long String</TD> Jon Hawkins

 

[gba]

Thanks .... never even thought of that...