Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all, I would like to create xls file via code (C#), and I've thought to
create a simple html file renaming it to xls. That works, but I'm no able to write return character in a single cell (Alt+Return). If I write 'html return' (<br), excel creates a new cell, but I would return to be in the same cell! Any suggestion? Thanks a lot Edo |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Are you formatting your output as a table ? Excel normally keeps the conent
of a <td in the same cell. Try wrapping your multi-line text in a single-cell table. Tim -- Tim Williams Palo Alto, CA "Edo" wrote in message ... Hi all, I would like to create xls file via code (C#), and I've thought to create a simple html file renaming it to xls. That works, but I'm no able to write return character in a single cell (Alt+Return). If I write 'html return' (<br), excel creates a new cell, but I would return to be in the same cell! Any suggestion? Thanks a lot Edo |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Tim, yes, I'm formatting output as a table. Each <tr become a single row
and each '<td' become a single cell; the problem is when I want to insert 'return' character (Alt+Return) in a single cell. I think I need a special char that will be interpreted as a return by excel... Thanks, Edoardo "Tim Williams" <timjwilliams at gmail dot com wrote in message ... Are you formatting your output as a table ? Excel normally keeps the conent of a <td in the same cell. Try wrapping your multi-line text in a single-cell table. Tim -- Tim Williams Palo Alto, CA "Edo" wrote in message ... Hi all, I would like to create xls file via code (C#), and I've thought to create a simple html file renaming it to xls. That works, but I'm no able to write return character in a single cell (Alt+Return). If I write 'html return' (<br), excel creates a new cell, but I would return to be in the same cell! Any suggestion? Thanks a lot Edo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Carriage return | Excel Discussion (Misc queries) | |||
Carriage Return | Excel Worksheet Functions | |||
Excel import txt file carriage return as delimiters | Excel Discussion (Misc queries) | |||
carriage return that works when pasted into a text file (eg. Notep | Excel Discussion (Misc queries) | |||
Prn file carriage return deletion within notepad | Excel Programming |