Wrap text in Excel

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
rajneetbhatiaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ColosseoConnect With a Mentor Commented:
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
 
ColosseoCommented:
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
 
rajneetbhatiaAuthor Commented:
Hi Scott,

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

Thanks,
R S
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
rajneetbhatiaAuthor Commented:
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
 
ColosseoCommented:
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
 
daleoranCommented:
Not sure if this is what you need but ...

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

Michael

0
 
rajneetbhatiaAuthor Commented:
"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
 
cwolvesCommented:
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
 
cwolvesCommented:
sample:

<table>
<tr>
<td style="height:100%;width:50px;">test
test
test
test
test<br />
</td>
</tr>
</table>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.