Solved

Wrap text in Excel

Posted on 2004-08-14
11
894 Views
Last Modified: 2007-12-19
Hi,

I am generating an Excel sheet pragramatically. Please let me know how can I wrap the text in Excel cell. Presently, if the text is more, it is coming in one line, without wrapping.

Waiting for reply.
Regards,
R  S
0
Comment
Question by:rajneetbhatia
  • 3
  • 3
  • 2
  • +1
11 Comments
 
LVL 15

Expert Comment

by:Colosseo
ID: 11799745
Hi R S

You can wrap the text in a cell by setting the .WrapText property of the cell to True

so for example

Range("A1").WrapText = True

Regards

Scott
0
 

Author Comment

by:rajneetbhatia
ID: 11799782
Hi Scott,

In my case, I am not giving name to a range. How can I use it without range?

Thanks,
R S
0
 
LVL 15

Accepted Solution

by:
Colosseo earned 20 total points
ID: 11799788
Hi R S

There are several ways you can do this... two more exampes are:

ActiveCell.WrapText = True
Selection.WrapText = True

how are you referencing cells when you output to them?

Scott
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 

Author Comment

by:rajneetbhatia
ID: 11799811
Hi Scott,

I am generating Excel programatically based on the data in the database. If the data is more, it is wrapping in HTML(browser), but when I export it to excel, it is coming in same line.

I want to have the data in excel in the same way as it is coming in word or browser. If you want I can give a name to the TD.

Thanks,
R S
0
 
LVL 15

Expert Comment

by:Colosseo
ID: 11799816
Hi  R S

I think it would help if you could post the code you are using to generate the excel. From there we can see what you are doing and how best to help.

Regards

Scott
0
 
LVL 10

Expert Comment

by:daleoran
ID: 11801224
Not sure if this is what you need but ...

Highlight the cells, then
Format > cells
Click the 'alignment' tab
click 'Wrap text'

Michael

0
 

Author Comment

by:rajneetbhatia
ID: 11838186
"I think it would help if you could post the code you are using to generate the excel. From there we can see what you are doing and how best to help.
"

Hi,

I am writing following two lines in my java code, which asks me to open or save in excel, and thus I am able to save my html generated code into excel.

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=a.xls");

Thanks,
R S
0
 
LVL 9

Expert Comment

by:cwolves
ID: 11903576
put the content in quotes if it's a CSV:

"this content
should wrap
in excel"

if you're using html, use "<BR>" tags instead of linebreaks.

or use chr(10) or chr(13) instead of linebreaks
0
 
LVL 9

Expert Comment

by:cwolves
ID: 12810659
sample:

<table>
<tr>
<td style="height:100%;width:50px;">test
test
test
test
test<br />
</td>
</tr>
</table>
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
html input type 3 31
How can I convert HTML files to .pdf files? 9 53
Are there any non javascript based chart/graph solutions? 14 31
paypal ipn url 5 56
Introduction The Google Maps API offers various ways to draw dynamic and static maps.  Using a combination of PHP and JavaScript, you can draw active JavaScript maps that allow pan-and-zoom in the client browser window.  You can also draw "static" …
This article discusses how to create an extensible mechanism for linked drop downs.
In this tutorial viewers will learn how add a scalable full-width header using CSS3. Create a new HTML document with an internal stylesheet. Set a tiled background.:  Create a new div and name it Header. Position it with position:absolute at the top…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question