New Line in Excel while exporting Grid to Excel

Question

0.00/5 (No votes)

See more:

Hi,

I have a data table in which it contains various rows an columns.
In one column i have append \n between two words to get it in a new line.
Then i assign this data table to a grid view data source and binding it,Later
i have exported this grid view to a excel file.My problem is that the newline(\n)
is not reflecting in the excel file.So please help in this or guide me to put a new line in excel file while exporting it via C#.

Thanks & Regards
Somu Jose

Posted 15-May-12 23:52pm

somujose

Add a Solution

Comments

Member 11606892 22-Apr-17 23:00pm

Hi, I am dealing with the same issue right now.Can you please let me know any suggestions? Did you resolve this... Can you please help me with a solution.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Lanng · Answer 1 · 2012-05-16T00:30:00

Solution 1

Try either Environment.NewLine or "\r\n".

I think that the office products are a bit more pedantic when it comes to line feeds and it reqires a carrage return also.

Posted 16-May-12 0:30am

Andy Lanng

Updated 16-May-12 11:22am

v2

Comments

Maciej Los 16-May-12 7:00am

Good answer, my 5!

Prasad Avunoori 29-May-14 5:55am

This didn't work for me.