ansaurus

Question

paste excel data into html table

Answer 1

A:

Here is a very similar question: http://stackoverflow.com/questions/686995/jquery-catch-paste-input

jjclarkson 2009-07-07 22:25:55

Answer 2

A:

This is going to be very difficult to do really well.

Off the top of my head, I'd say the best approach would be to give the users a <textarea> that they can paste into. Then, in the onchange event handler, use some JS parsing to figure out where the rows and columns line up, create the HTML table and inject it into the DOM.

This should work alright for a relatively "square" dataset - you might run into more issues with merged columns/rows and "jagged" data

nikmd23 2009-07-07 22:26:51

Answer 3

A:

This would only work reliably on IE since Firefox (and likely others) don't allow access to the clipboard without specifically allowing it; the earlier suggestion of pasting into a textarea first might work better than this.

When you copy from a spreadsheet, generally the cells are separated with a tab (chr9) and the rows with a CR (chr13). This script converts the clipboard into a 2D array and then builds a table from it. Not too elegant but it seems to work copying data out of Excel.

<html>
<head>
<script language="javascript">
function clip() {

    // get the clipboard text

    var clipText = window.clipboardData.getData('Text');

    // split into rows

    clipRows = clipText.split(String.fromCharCode(13));

    // split rows into columns

    for (i=0; i<clipRows.length; i++) {
     clipRows[i] = clipRows[i].split(String.fromCharCode(9));
    }


    // write out in a table

    newTable = document.createElement("table")
    newTable.border = 1;
    for (i=0; i<clipRows.length - 1; i++) {

     newRow = newTable.insertRow();

     for (j=0; j<clipRows[i].length; j++) {
      newCell = newRow.insertCell();
      if (clipRows[i][j].length == 0) {
       newCell.innerText = ' ';
      }
      else {
       newCell.innerText = clipRows[i][j];
      }
     }
    }

    document.body.appendChild(newTable);
}
</script>
</head>
<body>
<input type="button" onclick="clip()">
</body>
</html>

pjabbott 2009-07-07 22:52:28

Thanks!!! I'll try this out tonight.

perrinmeyer 2009-07-09 17:31:31

Answer 4

A:

perrinmeyer 2009-07-11 05:17:03

ansaurus

tags:

views:

answers:

paste excel data into html table

related questions