i trying learn web programming , javascript.
i'm trying take whatever user copied excel spreadsheet , create javascript spreadsheet/table includes dropdowns out of it.
so user paste input blank field, press submit button, , javascript generate excel-like spreadsheet have data sorted accordingly. dropdowns @ top of each column , allow user select either ready/not ready. being designed confluence wiki page.
this have far, right code parses input-field , creates multi-dimensional array. after that, array logged on console. need getting displayed on wiki page.
<html> <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> </head> <body> <textarea id="textarea"></textarea> <button id="loadpaste">parse</button> <script type="text/javascript"> var excel = new array(); $(document).ready(function() { $('#loadpaste').click(function() { var text = $('#textarea').val(); var rows = text.split("\n"); (var = 0; < rows.length; i++) { excel[i] = rows[i].split("\t"); } console.log(excel); }); }); </script> </body> </html>
lets close one: //this @downgoat response little explanation xml parser.
use xml parser var xml = (new domparser()).parsefromstring($('#textarea').val(), 'text/xml')
var text, parser, xmldoc; text = "<bookstore><book>" + "<title>everyday italian</title>" + "<author>giada de laurentiis</author>" + "<year>2005</year>" + "</book></bookstore>"; parser = new domparser(); xmldoc = parser.parsefromstring(text,"text/xml"); document.getelementbyid("demo").innerhtml = xmldoc.getelementsbytagname("title")[0].childnodes[0].nodevalue;<html> <body> <p id="demo"></p> </body> </html>