Copy/Paste from Excel to a web page

by

You don’t lose the delimiters, the cells are separated by tabs (\t) and rows by newlines (\n) which might not be visible in the form. Try it yourself: copy content from Excel to Notepad, and you’ll see your cells nicely lined up. It’s easy then to split the fields by tabs and replace them with something else, this way you can build even a table from them. Here’s a example using jQuery:

var data = $('input[name=excel_data]').val();
var rows = data.split("\n");

var table = $('<table />');

for(var y in rows) {
    var cells = rows[y].split("\t");
    var row = $('<tr />');
    for(var x in cells) {
        row.append('<td>'+cells[x]+'</td>');
    }
    table.append(row);
}

// Insert into DOM
$('#excel_table').html(table);

So in essence, this script creates an HTML table from pasted Excel data.

More Related Contents:

  1. html form that passes information to a variable in javascript [closed]
  2. My form’s validate() is not working
  3. Stop form refreshing page on submit
  4. HTML5 form required attribute. Set custom validation message?
  5. Submit form without page reloading
  6. Submit two forms with one button
  7. Submitting a form on ‘Enter’ with jQuery?
  8. JavaScript Form Submit – Confirm or Cancel Submission Dialog Box
  9. How can I set the form action through JavaScript?
  10. How to send a JSON object using html form data
  11. How to submit an HTML form without redirection
  12. Prevent form redirect OR refresh on submit?
  13. HTML form action and onsubmit issues
  14. passing form data to another HTML page
  15. Intercept a form submit in JavaScript and prevent normal submission
  16. Understanding HTML Form Element behavior
  17. Stop an input field in a form from being submitted
  18. How to get number of rows in using JavaScript?
  19. Form Submit Execute JavaScript Best Practice? [closed]
  20. Want HTML form submit to do nothing
  21. Enable/Disable submit button if checkbox is checked/unchecked?
  22. a way to check validity of HTML5 forms?
  23. submit event does not fire if submit initiated programmatically
  24. Passing javascript variables between pages [duplicate]
  25. Angular form validation ng-disabled not working
  26. How to create dynamically
  27. How best to make a link submit a form
  28. How do I export multiple html tables to excel?
  29. Custom Checkbox
  30. Disable scrolling on “

Leave a Comment