Pasting Data into excel file correctly from textbox

Question

 foreach (string TempSize in sizeArr)
            {
                txtResult.Text += store + "\t" + attributeSet + "\t" + configurableAttri + "\t" + type + "\t" + (ID + "_" + TempColour + TempSize) + "\n";
            }

I am trying to generate Multiple Rows that i can use to paste into excel file. "\n" doesn't seem to show on the "new line" of the textbox.

I tried manually doing "\n" aka shift+enter and copy paste the 3 rows into excel, Excel place a empty space between each of them, anyway to remove that problem too?

Thanks in advance!

Problem Fixed with "\r\n" instead of "\n" hat's how Windows controls represent newlines — JohnDotOwl
– JohnDotOwl, Commented Mar 3, 2013 at 19:03

JohnDotOwl · Accepted Answer · 2013-03-03 19:03:55Z

1

Problem Fixed with "\r\n" instead of "\n" hat's how Windows controls represent newlines

answered Mar 3, 2013 at 19:03

JohnDotOwl

3,78514 gold badges58 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pasting Data into excel file correctly from textbox

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related