locked
Copy/paste alt/enter from web page to excel RRS feed

  • Question

  • First, I hope I have chosen the right forum to query!

    I have a web page where I need to copy to clipboard multiple lines of information. I then paste the information into a formatted excel spreadsheet. One group of data needs to be in the same cell but on separate lines. If I was doing this manually, I would use alt/enter to start a new line. How do I do this?  See sample code below.

                data = data + Qty;
                data = data + "\t" + designation;
                data = data + "\t" + description;
                data = data + "\v" + NeedNewLine;
                data = data + "\t" + Net;
                data = data + "\r\n";

            window.clipboardData.setData('Text', data);

    What I need is for the text in "Description" to show first in the cell. Then in the same cell on a new line show the text called "NeedNewLine". The "\v" does not work and I have tried a variety of other codes to no avail.

    Thanks in advance for any suggestions.
    • Moved by jack 321 Tuesday, August 12, 2008 5:51 AM off topic (Moved from JScript for the .NET Framework to Off-Topic Posts (Do Not Post Here))
    Friday, August 8, 2008 3:33 PM

Answers